Help using Base SAS procedures

How to summarize 3 level data?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

How to summarize 3 level data?

data teast;

do C1='A' , 'B', 'C', 'A' , 'B', 'C' ;

  do C2= '1' , '2', '3','1' , '2', '3';

   C3=IFC(round(ranuni(0)), 'YES','NO') ;

   output;

   end;

end;

run;

How can I summarize the above dataset as following? If possible with percentage beside.

*All Sublevel (C2-C3) combination  summary for  1st  level  C1 . 

                                                           A                          B                           C

1- YES                                                 X                           X                           X

1-NO                                                   X                           X                           X

2-YES                                                   X                           X                           X

2-NO                                                   X                           X                           X

3- YES                                                  X                           X                           X

3-NO                                                   X                           X                           X

Thanks.


Accepted Solutions
Solution
‎05-24-2012 07:46 AM
Super Contributor
Posts: 349

Re: How to summarize 3 level data?

Hi,

Is this what you want..

data test;

do C1='A' , 'B', 'C', 'A' , 'B', 'C' ;

  do C2= '1' , '2', '3','1' , '2', '3';

   C3=IFC(round(ranuni(0)), 'YES','NO') ;

   output;

   end;

end;

run;

proc tabulate data=test;

class c1 c2 c3;

tables c2=''*c3='',c1*n=''

;

run;

Thanks,

Shiva

View solution in original post


All Replies
Solution
‎05-24-2012 07:46 AM
Super Contributor
Posts: 349

Re: How to summarize 3 level data?

Hi,

Is this what you want..

data test;

do C1='A' , 'B', 'C', 'A' , 'B', 'C' ;

  do C2= '1' , '2', '3','1' , '2', '3';

   C3=IFC(round(ranuni(0)), 'YES','NO') ;

   output;

   end;

end;

run;

proc tabulate data=test;

class c1 c2 c3;

tables c2=''*c3='',c1*n=''

;

run;

Thanks,

Shiva

Super User
Posts: 11,343

Re: How to summarize 3 level data?

Which percentage do you want? Percentage of all record count, row count or column count?

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 227 views
  • 0 likes
  • 3 in conversation