How to create a summary of a dataset in SAS without using PROC SQL

Question

i have a result set like:

  Name number reg_type1 reg_type2 reg_type3 reg_type4 reg_type5 reg_type6 reg_type7
  aaa   123       Y         N       Y          N          Y       N         N
  bbb   234       N         N       Y          N          Y       N         N
  ccc   456       Y         N       Y          Y          N       Y         Y

and i want the result set like:

  Name   number      level1       level2        level3      level4      level5 
  aaa     123       reg_type1    reg_type3     reg_type5    NULL         NULL
  bbb     234       reg_type3    reg_type5        NULL      NULL         NULL
  ccc     456       reg_type1    reg_type3     reg_type4    reg_type6   reg_type7

Thanks!!

The title and the question don't match, in addition to the answer you posted not matching either one. What are you doing here? — Joe
– Joe, Commented Jul 25, 2013 at 2:50

Joe · Accepted Answer · 2013-07-25 02:56:39Z

1

To answer what's in the question (as opposed to the title), this is easily done with array:

data have;
input Name $  number (reg_type1-reg_type7) ($);
datalines;
aaa   123       Y         N       Y          N          Y       N         N
bbb   234       N         N       Y          N          Y       N         N
ccc   456       Y         N       Y          Y          N       Y         Y
;;;;
run;
data want;
set have;
array regs reg:;
length level1-level5 $15;
array level[5] $;
_l = 1;
do _t = 1 to dim(regs);
 if regs[_t]='Y' then do;
   level[_l]=vname(regs[_t]);
   _l = _l+1;
 end;
end;
run;

answered Jul 25, 2013 at 2:56

Joe

63.5k7 gold badges51 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a summary of a dataset in SAS without using PROC SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related