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.
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
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
Which percentage do you want? Percentage of all record count, row count or column count?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.