Missing Values

sanyam13 — Tue, 19 Mar 2019 10:55:48 GMT

How can I detect and treat missing values for qualitative variables ? For quantitative data, I can detect with N and Nmiss and replace them 0 or Mean. Do we have some procedure for qualitative variables as well ?

Re: Missing Values

Astounding — Tue, 19 Mar 2019 11:10:26 GMT

Detecting:

proc format;
   value $missfmt  ' ' = 'missing' other='present';
run;
proc freq data=have;
   tables varname / missing;
   format varname $missfmt.;
run;

Fixing is up to you. There is no standard method. It depends on what you intend to do with the data. The most common option is to do nothing. Why would a missing qualitative value need to be replaced? At any rate, this is a valid DATA step statement:

if varname = ' ' then varname = 'N/A';

topic Missing Values in Streaming Analytics

Missing Values

Re: Missing Values