Handbook of SAS DATA Step Programming

191Useful SAS

®

Procedures

DAT4_TRANSPOSE:

TEST_NUM JOHN_E JOHN_M MARY_E MARY_M

1 1 89 78 92 76

2 2 90 89 . 91

3 3 92 90 81 89

Program 10.14A:

data dat4;

input s_name $ E1 - E3 M1 - M3;

datalines;

John 89 90 92 78 89 90

Mary 92 . 81 76 91 89

;

proc sort data = dat4 out = dat4_sort1;

by s_name;

run;

proc transpose data = dat4_sort1 out = dat4_out1;

by s_name;

run;

title 'First use of PROC TRANSPOSE for dat4';

proc print data = dat4_out1;

run;

Output from Program 10.14A:

First use of PROC TRANSPOSE for dat4

Obs s_name _NAME_ COL1

1 John E1 89

2 John E2 90

3 John E3 92

4 John M1 78

5 John M2 89

6 John M3 90

7 Mary E1 92

8 Mary E2 .

9 ...