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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.