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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 809 views
  • 0 likes
  • 3 in conversation