SAS PROC Transpose Data -

in sas, have data set similar 1 below.

id   tract    meanfa    sdfa      medianfa 1    t01      0.56      0.14      0.56 1    t02      0.53      0.07      0.52 1    t03      0.71      0.08      0.71 2    t01      0.72      0.09      0.72 2    t02      0.83      0.10      0.86 2    t03      0.59      0.10      0.62 

i not sure if transpose right concept here... want data 1 below.

id   t01_meanfa  t01_sdfa  t01_medianfa  t02_meanfa  t02_sdfa  t02_medianfa  t03_meanfa  t03_sdfa  t03_medianfa 1    0.56        0.14      0.56          0.53        0.07      0.52          0.71        0.08      0.71 2    0.72        0.09      0.72          0.83        0.10      0.86          0.59        0.10      0.62   proc transpose data=tract out=newtract;    var meanfa sdfa medianfa;    id;    id tract meanfa sdfa medianfa; run; 

i have been playing around sas code above, no success. ideas or suggestions great!

you need 2 transposes. transpose, use data step update _name_ variable, , transpose again;

proc transpose data=tract out=tract2; id tract; run;  data tract2; format _name_ $32.; set tract2; _name_ = strip(tract) || "_" || strip(_name_); run;  proc transpose data=tract2 out=tract3(drop=_name_); id; /*with no id statement, _name_ variable used*/ var col1; run;