topic Proc Freq Output Style in Statistical Procedures

Proc Freq Output Style

c_webb — Tue, 11 Mar 2025 15:09:42 GMT

Hi everyone. I have a quick question regarding output styles in SAS Enterprise Guide. I know that proc surveyfreq gives this kind of thing. where both variables are on the left axis and it just lists one as a subset of the other:

Proc freq, however, has one variable on the top, with the other variable on the left, like so:

Is there any way that we can make the proc surveyfreq output more similar to the proc freq output in the way that the variables and values are arranged (We want one variable per axis)?

Re: Proc Freq Output Style

Season — Wed, 12 Mar 2025 07:07:56 GMT

Swap the variable names standing for the rows and columns in the procedure syntax that you think is inapproriate and have a look. Like this:

Before:

proc freq data=xxx;
tables a*b;
run;

After:

proc freq data=xxx;
tables b*a;
run;

Re: Proc Freq Output Style

ballardw — Thu, 13 Mar 2025 01:37:17 GMT

What is the purpose of having Surveyfreq and Freq output appear similar?

And by "output style" are you referring to the appearance in the result window only? The ODS OUTPUT creating a data set in Surveyfreq and either the OUT=option in Proc Freq or the ODS output to create data sets may be easier to similar output structures and then use a report procedure such as Print, Tabulate or Report to create desired human readable output.

Re: Proc Freq Output Style

c_webb — Thu, 13 Mar 2025 13:28:13 GMT

It sounds like there's no way to adjust the style of the output table directly within the proc surveyfreq statement. So I'll try as you suggested and save the proc surveyfreq output, and then use a different procedure statement to make a more reader-friendly table. Thank you for the help.