how to transpose my data

[comeon2012]

Hi all,

I have a dataset needs to be reshaped.

Please see the attachment, which is only part of my dataset for your reference. Actually there are more than 2 fundcdym in my dataset.

Thanks.

[overmar · Accepted solution]

I uploaded your data and cut off everything other than fundcdym variable and est_adj because I figured those were really the only variables that you had in the dataset as they were the ones that you had transposed. The below code will output a dataset similar to what you were asking for other than the transposed columns are in alphabetical order rather than the order in your csv file.

proc sort data=have;

    by fundcdym variable;

run;

proc transpose data = have out = want;

    by fundcdym;

    id variable;

    var est_adj;

run;

Hope this helps.