Creating and Displaying School Grade Data

The script is divided into five logical sections, each creating and displaying a data table (Grades1 to Grades5). The first section shows simple creation and display. Subsequent sections introduce the use of the VAR statement in PROC PRINT to select and order columns. One section demonstrates how to calculate a new variable (totalscores) within a DATA STEP. The last section shows how to modify the value of an existing column. This script is a good example for beginners learning the fundamentals of DATA STEP and the PRINT procedure.

Data Analysis

Type : CREATION_INTERNE

All data is created and integrated directly into the SAS script using the `DATALINES` statement within each DATA STEP. No external data source is required or used.

1 Code Block

DATA STEP Data

Explanation :
This code block creates a SAS table named `Grades1`. The `input` statement defines the data structure by reading variables from specific column positions. Data is provided directly in the code via `DATALINES`.

Copied!

1	DATA Grades1;
2	INPUT subj 1-4 name $ 5-23 sex exam1 exam2 exam3 exam4 exam5 project finalexam;
3	DATALINES;
4	1011 Alia Bhatt 2 100 65 83 84 99 91 96
5	1012 Maria Smith 1 78 82 86 . 100 95 97
6	1111 Thomas Jones 2 88 81 96 69 91 90 98
7	1121 Benedictine Arnold 2 68 82 82 89 89 93 99
8	1301 Trisha Gupta 1 51 69 79 59 85 64 100
9	;
10	RUN;

2 Code Block

PROC PRINT

Explanation :
This procedure displays the entire content of the `Grades1` table in the results output window.

Copied!

1	PROC PRINT DATA=Grades1;
2	RUN;

3 Code Block

DATA STEP Data

Explanation :
Creates a second table `Grades2`, identical to `Grades1`, to demonstrate a different display functionality.

Copied!

1	DATA Grades2;
2	INPUT subj 1-4 name $ 5-23 sex exam1 exam2 exam3 exam4 exam5 project finalexam;
3	DATALINES;
4	1011 Alia Bhatt 2 100 65 83 84 99 91 96
5	1012 Maria Smith 1 78 82 86 . 100 95 97
6	1111 Thomas Jones 2 88 81 96 69 91 90 98
7	1121 Benedictine Arnold 2 68 82 82 89 89 93 99
8	1301 Trisha Gupta 1 51 69 79 59 85 64 100
9	;
10	RUN;

4 Code Block

PROC PRINT

Explanation :
Displays the `Grades2` table. The `var` statement is used to specifically select the columns to display and define their order.

Copied!

1
2	PROC PRINT
3	DATA=Grades2;
4	var name exam1 exam2 exam3 exam4 project finalexam;
5	RUN;
6

5 Code Block

DATA STEP Data

Explanation :
Creates a third table `Grades3` to illustrate another variation of column display.

Copied!

1	DATA Grades3;
2	INPUT subj 1-4 name $ 5-23 sex exam1 exam2 exam3 exam4 exam5 project finalexam;
3	DATALINES;
4	1011 Alia Bhatt 2 100 65 83 84 99 91 96
5	1012 Maria Smith 1 78 82 86 . 100 95 97
6	1111 Thomas Jones 2 88 81 96 69 91 90 98
7	1121 Benedictine Arnold 2 68 82 82 89 89 93 99
8	1301 Trisha Gupta 1 51 69 79 59 85 64 100
9	;
10	RUN;

6 Code Block

PROC PRINT

Explanation :
Displays the `Grades3` table and uses the `var` statement to reorder columns in a different order than their natural order in the table.

Copied!

1
2	PROC PRINT
3	DATA=Grades3;
4	var name project finalexam exam1 exam2 exam3 exam4;
5	RUN;
6

7 Code Block

DATA STEP Data

Explanation :
Creates the `Grades4` table. A new variable `totalscores` is calculated by summing the scores from exams, project, and final exam. Note that if one of the calculation variables is missing ('.') as for 'Maria Smith', the `totalscores` result will be missing.

Copied!

1	DATA Grades4;
2	INPUT subj 1-4 name $ 5-23 sex exam1 exam2 exam3 exam4 exam5 project finalexam;
3	totalscores = exam1 + exam2 + exam3 + exam4 + exam5 + project + finalexam;
4	DATALINES;
5	1011 Alia Bhatt 2 100 65 83 84 99 91 96
6	1012 Maria Smith 1 78 82 86 . 100 95 97
7	1111 Thomas Jones 2 88 81 96 69 91 90 98
8	1121 Benedictine Arnold 2 68 82 82 89 89 93 99
9	1301 Trisha Gupta 1 51 69 79 59 85 64 100
10	;
11	RUN;

8 Code Block

PROC PRINT

Explanation :
Displays the `Grades4` table, including the newly calculated `totalscores` column to verify the calculation result.

Copied!

1
2	PROC PRINT
3	DATA=Grades4;
4	var name exam1 exam2 exam3 exam4 project finalexam totalscores;
5	RUN;
6

9 Code Block

DATA STEP Data

Explanation :
Creates the `Grades5` table. In this DATA STEP, the value of the existing variable `exam2` is modified by adding 1 to it for each observation.

Copied!

1	DATA Grades5;
2	INPUT subj 1-4 name $ 5-23 sex exam1 exam2 exam3 exam4 exam5 project finalexam;
3	exam2 = exam2 + 1;
4	DATALINES;
5	1011 Alia Bhatt 2 100 65 83 84 99 91 96
6	1012 Maria Smith 1 78 82 86 . 100 95 97
7	1111 Thomas Jones 2 88 81 96 69 91 90 98
8	1121 Benedictine Arnold 2 68 82 82 89 89 93 99
9	1301 Trisha Gupta 1 51 69 79 59 85 64 100
10	;
11	RUN;

10 Code Block

PROC PRINT

Explanation :
Displays the `Grades5` table to visualize the result of the modification made to the `exam2` column.

Copied!

1
2	PROC PRINT
3	DATA=Grades5;
4	var name exam1 exam2 exam3 exam4 project finalexam ;
5	RUN;
6

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste

Expert Advice

Stéphanie

Spécialiste Machine Learning et IA.

« This script serves as the foundational blueprint for SAS programming. It perfectly illustrates the primary SAS workflow: reading raw data, performing logical transformations in the DATA step, and generating structured reports via PROC PRINT. »