topic Re: Proc tabulate selecting one level of a variable to be printed in SAS Procedures

Proc tabulate selecting one level of a variable to be printed

MilenaNF — Sun, 01 Dec 2019 00:48:53 GMT

Hi,

I'm using proc tabulate to create a table and I'm wondering if there's a way to select one level of a categorical variable to be printed, but keeping the % considering all the levels.

See below the table that I have. I wanted the same table but to export in excel only the lines 'Yes' for the variable sick.

See the code I have right now. Any other ideas are welcome.

Thanks in advance!

ods excel file="C:\ExampleTable1.xlsx" style=minimal;
proc tabulate data=ex;
class sick sex doctor location;
table (sex=' ')*(sick=' ' all), (location=' ' ALL)*(doctor=' ')*(n pctn<sick all>*f=10.1)/ nocellmerge printmiss misstext='0' box="Sick";
keylabel PctN="%" N="n" All="Total";
run;
ods excel close;

Re: Proc tabulate selecting one level of a variable to be printed

Reeza — Sun, 01 Dec 2019 01:56:24 GMT

Not easily. It’s easier to push the proc tabulate table to a dataset, filter it and then use proc report to display it.

Re: Proc tabulate selecting one level of a variable to be printed

MilenaNF — Sun, 01 Dec 2019 23:49:01 GMT

Hi Reeza,

thanks for your reply. I'm not very familiar with proc report, would you be able to show me an example on how to use proc report to output a table similar to the one I have now?

Re: Proc tabulate selecting one level of a variable to be printed

Reeza — Mon, 02 Dec 2019 00:13:34 GMT

Sorry, I'm not as familiar with PROC REPORT either.

I would expect that you would use an ACROSS to specify the doctors/location and then the Gender/Sick Variable as grouping variables.
You can use COMPUTE if want to custom format your data.

Note that you I strongly suspect you'll still need to use PROC TABULATE to get the percentages or PROC FREQ.

You could also just use PROC FREQ + TRANSPOSE + PROC PRINT to display it if you're not familiar with PROC REPORT.

PROC TABULATE has an OUT= option on the statement that will push your data to an output data set.

Proc Report examples - there's a few that are relevant to you or you can find many many examples on Lexjansen.com. I'd probably find the one that was closest to what I wanted and start from there.
https://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=n1pl56sdqo09cyn1fifuhcz8dl2f.htm&locale=en

Re: Proc tabulate selecting one level of a variable to be printed

ballardw — Mon, 02 Dec 2019 16:29:51 GMT

For Yes/No True/False type variables I generally find that a numeric value coded 1/0 works best for what you describe as a want. The SUM of a 1/0 coded variable is the count of "Yes" or "True" and the mean is the percentage of Yes.

So perhaps:

data want;
   set ex;
   sicknum= (Sick='Yes');
run;

proc tabulate data=want;
   class  sex doctor location;
   var Sicknum ;
   table (sex=' ')*(sicknum=' ' , 
         (location=' ' ALL)*(doctor=' ')*(sum='n'*f=best5. mean='%'*f=percent8.1))/ nocellmerge printmiss misstext='0' box="Sick";
   ;
run;

Re: Proc tabulate selecting one level of a variable to be printed

MilenaNF — Mon, 02 Dec 2019 19:21:33 GMT

Hi, it worked, thank you so much!!