Differences between revisions 2 and 4 (spanning 2 versions)

SAS Freq

Contents

SAS Freq

Usage

To display frequencies of variables, try:

proc freq data=LIBREF.TABLE order=freq;
  tables VARLIST;
run;

To list unique values, add the nlevel option to the procedure.

Tables Statement

The TABLES statement creates a table for each variable specified in VARLIST.

To create a crosstab, try:

proc freq data=LIBREF.TABLE;
  tables STUBVAR*BANNERVAR;
run;

To suppress certain aspects of the frequency table, specify the corresponding suppression option. For example, to suppress cumulative frequencies, try:

proc freq data=LIBREF.TABLE order=freq;
  tables VARLIST / nocum;
run;

The options are:

Option	Meaning
`nocum`	suppress cumulative percentages
`nopercent`	suppress cell percentages
`norow`	suppress row percentages
`nocol`	suppress column percentages
`crosslist`	trigger nested list display for crosstabs
`list`	as above and includes `STUBVAR` on each row

By Statement

The BY statement specifies one or more variables for which the PROC FREQ should be split.

Tables Out

To store the frequencies displayed on a table, try:

proc freq data=LIBREF.TABLE order=freq;
  tables VARLIST / nocum out=LIBREF.NEWTABLE;
run;

NEWTABLE will contain the enw variables COUNT and PERCENT.

Tables Plot

To plot the frequencies percentages displayed on a table, try:

proc freq data=LIBREF.TABLE order=freq;
  tables VARLIST / plots=freqplot(orient=horizontal scale=percent);
run;

To suppress everything but the plot, prepend these commands:

ods graphics on;
ods select freqplot;

To plot a crosstab with percentages, try:

proc freq data=LIBREF.TABLE order=freq;
  tables STUBVAR*BANNERVAR / plots=freqplot(groupby=row orient=horizontal scale=grouppercent);
run;

CategoryRicottone

-  ⇤ ← Revision 2 as of 2023-01-14 05:23:57 → 
  Size: 1652
  Editor: DominicRicottone
  Comment:
+   ← Revision 4 as of 2023-01-14 05:31:31 → ⇥
  Size: 2153
  Editor: DominicRicottone
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 31:
-  tables VAR1*VAR2;
+  tables STUBVAR*BANNERVAR;
 Line 35:
-To suppress certain aspects of the frequency table, specify the corresponding supresion option. For example, to suppress cumulative frequencies, try:
+To suppress certain aspects of the frequency table, specify the corresponding suppression option. For example, to suppress cumulative frequencies, try:
 Line 45:
-||'''Option'''||'''Meaning'''                                      ||
||`nocum`     ||suppress cumulative percentages                    ||
||`nopercent` ||suppress cell percentages                          ||
||`norow`     ||suppress row percentages                           ||
||`nocol`     ||suppress column percentages                        ||
||`crosslist` ||trigger nested list display for crosstabs          ||
||`list`      ||as above and includes first level value on each row||
+||'''Option'''||'''Meaning'''                              ||
||`nocum`     ||suppress cumulative percentages            ||
||`nopercent` ||suppress cell percentages                  ||
||`norow`     ||suppress row percentages                   ||
||`nocol`     ||suppress column percentages                ||
||`crosslist` ||trigger nested list display for crosstabs  ||
||`list`      ||as above and includes `STUBVAR` on each row||
 Line 75:
+----



== Tables Plot ==

To plot the frequencies percentages displayed on a table, try:

{{{
proc freq data=LIBREF.TABLE order=freq;
  tables VARLIST / plots=freqplot(orient=horizontal scale=percent);
run;
}}}

To suppress everything ''but'' the plot, prepend these commands:

{{{
ods graphics on;
ods select freqplot;
}}}

To plot a crosstab with percentages, try:

{{{
proc freq data=LIBREF.TABLE order=freq;
  tables STUBVAR*BANNERVAR / plots=freqplot(groupby=row orient=horizontal scale=grouppercent);
run;
}}}

Diff for "SAS/Freq"