topic Re: Which Proc should I use to know the number of missing value of character variable? in SAS Procedures

Which Proc should I use to know the number of missing value of character variable?

vishalrajpoot3 — Fri, 14 Sep 2018 07:37:01 GMT

I know proc means with N and Nmiss option provides the no of populated and missing observation for numeric variable. But which proc/options we use to know the missing value of character variable ?

Lets have the below data set as an example.

data abc;
input name $ state $;
datalines;
a up
b mp
c .
d hp
e .
f mp
. gj
h hp
;
run;

Re: Which Proc should I use to know the number of missing value of character variable?

RW9 — Fri, 14 Sep 2018 08:14:25 GMT

Proc freq with missing option:

https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_freq_sect016.htm

Re: Which Proc should I use to know the number of missing value of character variable?

PeterClemmensen — Fri, 14 Sep 2018 12:52:15 GMT

proc freq data=abc;
   tables state / missing nocum nopercent;
run;

Re: Which Proc should I use to know the number of missing value of character variable?

Ksharp — Fri, 14 Sep 2018 12:53:48 GMT

PROC SQL.

data abc;
input name $ state $;
datalines;
a up
b mp
c .
d hp
e .
f mp
. gj
h hp
;
run;
proc sql;
select nmiss(name) as nmiss_name,nmiss(state) as nmiss_state
 from abc;
quit;

Re: Which Proc should I use to know the number of missing value of character variable?

Rick_SAS — Fri, 14 Sep 2018 14:00:25 GMT

For a discussion and examples, see the article "Count the number of missing values for each variable."