topic Proc Freq Output not Consistent in SAS Procedures

Proc Freq Output not Consistent

JBerry — Fri, 18 Jul 2014 17:11:10 GMT

When I run this statement on a dataset, I usually get 5 columns. TableVar, TableVarLabel, NLevels, NMissLevels, NNonMissLevels

ods output nlevels=nlevelsds;

proc freq data=LIB.DATASET nlevels;

tables _all_/noprint;

run;

But when I change the dataset to a different dataset, I only get 3 columns! TableVar, TableVarLabel, NLevels

Why? Would this happen if my dataset had no missing values?

Is there a way to force these columns to appear?

The unpredictable output is really giving me problems with programming and automation.

Re: Proc Freq Output not Consistent

stat_sas — Fri, 18 Jul 2014 18:28:54 GMT

This is happening because your second data set contains variables that don't have missing values. If at least one of the variables in your second dataset has missing values then you will get 5 columns in nlevelsds.

Re: Proc Freq Output not Consistent

JBerry — Fri, 18 Jul 2014 18:44:55 GMT

Is there no way to force a consistent output? I would like to create macros, but if one of the

This blows my mind that the output structure is dependent upon the values of the data.... because when I automate a process, it will fail if the column doesnt exist (even though it SHOULD exist, just with a 0 for missing values)

Re: Proc Freq Output not Consistent

Reeza — Fri, 18 Jul 2014 19:06:01 GMT

Create an empty table with all the columns expected and insert the output into it. You'll also have to verify the variable type, character or numeric. Or use a different method entirely to generate your output.

But yes, the structure doesn't appear to be static and this is common pitfall of ODS tables. For example if you do a one way table versus a two way table in proc freq the output table names are different.