topic Re: display proc freq output in SAS Procedures

display proc freq output

lmyers2 — Fri, 19 Feb 2021 00:54:31 GMT

Hello - I'm trying to get a proc freq output that contains 3 columns (all patients, COPD=0, COPD=1) instead of running 2 procedures and coping the answers over by hand. Can you help?

proc freq order=freq; table race; run;
proc freq order=freq; table race*COPD; run;

Desired output:

All COPD=0 COPD=1

race1

race2

race3

Also, is there a way to order by a certain column or will SAS always order by descending row sum?

Re: display proc freq output

Astounding — Fri, 19 Feb 2021 03:24:08 GMT

You're probably better off switching from PROC FREQ to PROC TABULATE. Here's some untested code:

proc tabulate data=have;
   class race copd;
   tables race, all copd;
run;

Re: display proc freq output

ballardw — Fri, 19 Feb 2021 09:45:03 GMT

If @Astounding's suggestion does not do what you want then please show us what you actually expect for out. Better would be to provide some example data in the form of a data step or use one of the SAS supplied data sets such as SASHELP.Class.

Plus you can make many tables with a single proc freq call such as

proc freq order=freq; tables race race*COPD; run;

Or if you want multiple tables with different options use multiple tables statements like

Proc freq order=freq;
   tables race;
   table race*copd/ chisqr;
run;

Re: display proc freq output

Reeza — Fri, 19 Feb 2021 16:08:59 GMT

Doesn't the second PROC FREQ generate what you want? There's a total column by default.
It may depend on how your data is structured but you haven't shared that information.