how to transpose my data

comeon2012 — Tue, 18 Feb 2014 00:10:24 GMT

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.

Re: how to transpose my data

overmar — Tue, 18 Feb 2014 00:43:38 GMT

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.

topic how to transpose my data in SAS Procedures

how to transpose my data

Re: how to transpose my data