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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.