topic Proc tabulate - Allignment in SAS Programming

Proc tabulate - Allignment

Sathish_jammy — Wed, 26 Jun 2019 12:45:19 GMT

Hi experts,

I'm trying to align my analysis in a particular format but my code won't work.

I need your suggestion to align in the given format. Kindly go through the below sample.

data have;
input age$5. Grp$ arg$;
cards;
18-25 G a
18-25 G b
18-25 O c
18-25 P a
18-25 G c
26-35 P b
26-35 G a
26-35 G a
;
proc tabulate data = have;
class age Grp arg;
tables age*Grp, arg;
run;

The result shares the perfect OP values but I required it in the right side displayed tabular format.

Please help me to rearrange the table. I tried a lot but nothing works well.

Thanks in advance!

Re: Proc tabulate - Allignment

Tom — Wed, 26 Jun 2019 13:36:44 GMT

Sounds like you want

tables age, arg*grp*N ;

You can use

keylabel n=' ';

to suppress the adding of the N label to the report.

Re: Proc tabulate - Allignment

Sathish_jammy — Thu, 27 Jun 2019 03:40:18 GMT

Thank you so much, Buddy! You made my day @Tom