topic Re: Excluding Frequency of Missing Values in Proc Freq Procedure in New SAS User

Excluding Frequency of Missing Values in Proc Freq Procedure

JackZ295 — Mon, 15 Jul 2019 13:23:16 GMT

Is there a way to exclude the frequency of missing values in a proc freq procedure? For example if you run a proc freq procedure with or without the /missing option:

proc freq data=one;

tables variables;

run;

proc freq data=one;

tables variables/missing;

run;

I believe you still get the frequency of missing values, though the latter option counts the missing values in the percentage, correct? However, is there a way to exclude the missing values in the frequency table all together?

Re: Excluding Frequency of Missing Values in Proc Freq Procedure

Ksharp — Mon, 15 Jul 2019 13:29:10 GMT

proc freq data=one(where=(variables is not missing)); tables variables; run;

Re: Excluding Frequency of Missing Values in Proc Freq Procedure

Ksharp — Mon, 15 Jul 2019 13:29:21 GMT

proc freq data=one(where=(variables is not missing)); tables variables; run;