Hi,
I am using SAS 9.3 and would like to use proc transpose for the following dataset named as outputcut:
[outputcut]
month order count
200701 -1 209
200701 0 100
200701 1 89
200702 -1 324
200702 1 291
When I run the following code:
proc transpose data=outputcut out=output_num;
by month;
var count;
run;
it gives me the output as follow:
month _NAME_ COL1 COL2 COL3
200701 count 209 100 89
200701 count 324 291 .
However, I would like to get my output as follow:
month _NAME_ COL1 COL2 COL3
200701 count 209 100 89
200701 count 324 . 291
so that COL2 corresponds to the value 0 of the variable 'order', and COL3 to the value of 1 for the variable 'order'.
Any comment is appreciated!
Minsoo
You could use id and, if desired, idlabel statements. e.g.:
proc transpose data=outputcut out=output_num;
by month;
var count;
id order;
idlabel order;
run;
You could use id and, if desired, idlabel statements. e.g.:
proc transpose data=outputcut out=output_num;
by month;
var count;
id order;
idlabel order;
run;
Thanks Arthur, it just works perfect!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.