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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.