DATA Step, Macro, Functions and more

proc transpose with different number of by values

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

proc transpose with different number of by values

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


Accepted Solutions
Solution
‎01-06-2013 10:08 AM
PROC Star
Posts: 7,363

Re: proc transpose with different number of by values

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;

View solution in original post


All Replies
Solution
‎01-06-2013 10:08 AM
PROC Star
Posts: 7,363

Re: proc transpose with different number of by values

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;

Occasional Contributor
Posts: 16

Re: proc transpose with different number of by values

Thanks Arthur, it just works perfect!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 193 views
  • 0 likes
  • 2 in conversation