BookmarkSubscribeRSS Feed
axescot78
Quartz | Level 8

I am using

 

PROC MEANS DATA=data_categorical NMISS N;
RUN;

 

to find missing values in categorical variables. 3 of these columns contain character values and do not show up in the results. How can I get these to show up?

3 REPLIES 3
andreas_lds
Jade | Level 19
With proc means you can't do this, try proc freq instead.
axescot78
Quartz | Level 8

I ended up creating dummy variables, which I will need later anyway. Thanks man!

Ksharp
Super User
data have;
 set sashelp.class;
 call missing(name);
run;

proc sql;
select n(name) as n,nmiss(name) as nmiss from have;
quit;
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 890 views
  • 0 likes
  • 3 in conversation