topic Re: PROC TABULATE suppressing the n count rows in SAS Procedures

PROC TABULATE suppressing the n count rows

GreggB — Thu, 17 Aug 2017 17:16:45 GMT

Is it possible to suppress the rows that show the n count? I only want percentages

Code:

ods pdf file='fakepath.pdf';
proc tabulate data=one;
where elatook ne '';
class efagrade /*school*/;
class elalev1 elalev2;
tables elalev1='Literary Text'*(n*f=6.0 pctn<elalev1>='PCT'*f=6.0) all='TOTAL'*(n*f=6.0)
elalev2='(LT)Meaning/Context'*(n*f=6.0 pctn<elalev2>='PCT'*f=6.0) all='TOTAL'*(n*f=6.0)
efagrade='Grade' all='Total' /rts=25 misstext='0' printmiss;
format elalev1-elalev2 perf.;
run;
ODS pdf close;

Re: PROC TABULATE suppressing the n count rows

Reeza — Thu, 17 Aug 2017 17:25:28 GMT

What happens if you remove the N from the code below?

Re: PROC TABULATE suppressing the n count rows

GreggB — Thu, 17 Aug 2017 17:27:47 GMT

I feel a tad foolish.

Re: PROC TABULATE suppressing the n count rows

Reeza — Thu, 17 Aug 2017 17:37:24 GMT

I will never forget SAS tech supports to some really stupid mistakes I made in my code when I first started programming in SAS:

"I've never seen it done that way before, but I think what you're trying to do is ... "

Incredibly polite of them and didn't make me feel like a fool!

We've all been there 🙂