- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-15-2019 09:23 AM
(8827 views)
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc freq data=one(where=(variables is not missing));
tables variables;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc freq data=one(where=(variables is not missing));
tables variables;
run;