topic character columns not being reported by proc means in SAS Programming

character columns not being reported by proc means

axescot78 — Mon, 24 Jun 2019 04:13:32 GMT

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?

Re: character columns not being reported by proc means

andreas_lds — Mon, 24 Jun 2019 05:14:11 GMT

With proc means you can't do this, try proc freq instead.

Re: character columns not being reported by proc means

axescot78 — Mon, 24 Jun 2019 07:02:43 GMT

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

Re: character columns not being reported by proc means

Ksharp — Mon, 24 Jun 2019 12:50:46 GMT

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

proc sql;
select n(name) as n,nmiss(name) as nmiss from have;
quit;