change row to colum of total dataset

GeorgeSAS — Sun, 19 Apr 2015 04:58:17 GMT

Hello everyone,how to change a whole data set from column to row?is there any matrix method like SAS IML or any other method can do this?(please use sashelp.class as input data)

I have a data set like:

name ID score1 score2

A 1 80 60

B 2 36 85

C 3 16 28

I want the data set convert to this:

name A B C

ID 1 2 3

scoe1 80 36 16

score2 60 85 28

which means change from row to column for whole data, you can use SAS help.class as an date set input, and for the result all variables are character will still be ok.

Thanks

Re: change row to colum of total dataset

Ksharp — Sun, 19 Apr 2015 05:11:01 GMT

No need for IML . But If you like IML check function T() .

proc transpose data=sashelp.class out=want;

var name sex age;

run;

proc transpose data=sashelp.class out=want;

id name;

run;

Xia Keshan

topic Re: change row to colum of total dataset in SAS Procedures

change row to colum of total dataset

Re: change row to colum of total dataset