topic PROC FREQ-Levels in SAS Programming

PROC FREQ-Levels

Ronein — Thu, 09 Feb 2023 11:42:03 GMT

Hello

In first example I get only Levels column.

In second example I get more columns: frequency, percent,Cum freq, Cum percent.

Why is it??

proc freq data =sashelp.cars nlevels;
tables Origin;
run;

proc freq data =sashelp.cars nlevels;
tables _ALL_;
run;

Re: PROC FREQ-Levels

PaigeMiller — Thu, 09 Feb 2023 12:20:04 GMT

In the first example, I get levels followed by the frequency table (including frequency, percent, cumulative frequency, cumulative percent). Show us what you see.

Re: PROC FREQ-Levels

Kathryn_SAS — Thu, 09 Feb 2023 13:24:46 GMT

The NLEVELS option in PROC FREQ will create a separate table regardless of how many variables you request. The number of columns in the table will depend on if the variable(s) have missing values or not. In the first case, Origin does not have missing values, so the table will only show the variable name and the number of unique levels. In the second case, where you chose all variables (or if you had chosen the Cylinders variable initially), you will see columns for Levels, Missing Levels, and Nonmissing Levels. The sum of the Missing Levels and Nonmissing Levels is Levels. There is also a column for Labels if any of the variables has a label assigned.

Re: PROC FREQ-Levels

ballardw — Thu, 09 Feb 2023 15:55:56 GMT

Here is my output for the first proc freq which has frequency, percent, cum freq and cum percent as I expected. The only thing I can think would that wouldn't do such is some other options not shown, such as an ODS Select left over from previous code.

The FREQ Procedure

Number of Variable Levels
Variable	Levels
Origin	3

Origin	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Asia	158	36.92	158	36.92
Europe	123	28.74	281	65.65
USA	147	34.35	428	100.00