BookmarkSubscribeRSS Feed
c_webb
Calcite | Level 5

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:

c_webb_2-1741705477796.png

 

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

c_webb_4-1741705700551.jpeg

 

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)?  

3 REPLIES 3
Season
Barite | Level 11

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;
ballardw
Super User

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.

c_webb
Calcite | Level 5

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 721 views
  • 0 likes
  • 3 in conversation