Proc TRANSPOSE

This procedure is used to transpose specific variables into observations and hence, restructuring the data into a desired format to be used by the procedure of interest.

proc sort data = dataname1; by var1 var2; 

proc transpose data = dataname1 

                        out = dataname2 

                        name = var3

                        prefix = var7; 

id var1 var2;

by var1 var2;

var var4 var5 var6;

run;