proc transpose with different number of by values

[ibsulkim]

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

[art297 · Accepted solution]

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]

Thanks Arthur, it just works perfect!