proc transpose with different number of by values

ibsulkim — Sun, 06 Jan 2013 14:01:18 GMT

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

Re: proc transpose with different number of by values

art297 — Sun, 06 Jan 2013 15:08:10 GMT

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;

ibsulkim — Mon, 07 Jan 2013 03:29:28 GMT

Thanks Arthur, it just works perfect!