Help using Base SAS procedures

how to transpose my data

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

how to transpose my data

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.

Attachment

Accepted Solutions
Solution
‎02-17-2014 07:43 PM
Frequent Contributor
Posts: 83

Re: how to transpose my data

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.

View solution in original post


All Replies
Solution
‎02-17-2014 07:43 PM
Frequent Contributor
Posts: 83

Re: how to transpose my data

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 184 views
  • 0 likes
  • 2 in conversation