Differences between revisions 1 and 2

SAS Freq

Contents

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.

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

To create a crosstab, try:

proc freq data=LIBREF.TABLE;
  tables VAR1*VAR2;
run;

To suppress certain aspects of the frequency table, specify the corresponding supresion 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 first level value on each row

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

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.

-  ⇤ ← Revision 1 as of 2023-01-14 04:39:18 → 
  Size: 1391
  Editor: DominicRicottone
  Comment:
+   ← Revision 2 as of 2023-01-14 05:23:57 → ⇥
  Size: 1652
  Editor: DominicRicottone
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 59:
+----



== 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`.