topic Re: Assessing Missing/Nulls in character fields in SAS Procedures

Assessing Missing/Nulls in character fields

mMike5 — Fri, 05 Jul 2013 17:47:26 GMT

Hi,

I was wondering whether there is an easy way to assess the no. missing/null values in a field?

I use the following for numeric and string variables. Its fine for numeric variables, but the code for string variables returns a frequency table of values, if there is a lot of records and a string ID field the output can be massive. Is there a way to output a report of only the count of the number of missing values for each character variable?

thanks,

/* Asess numeric variables */

proc means data = Datafile n nmiss;

var _numeric_;

run;

/* Asess categorical variables */

proc freq data = Datafile;

tables _character_ ;

Re: Assessing Missing/Nulls in character fields

mMike5 — Fri, 05 Jul 2013 17:56:17 GMT

... just in case anyone was wondering!

proc format;

value $miss " "="missing"

other="nomissing";

run;

proc freq data=datafile;

tables _character_ / missing;

format _character_ $miss.;

run;

Re: Assessing Missing/Nulls in character fields

Ksharp — Sat, 06 Jul 2013 01:06:55 GMT

data have;
 set sashelp.class;
 if ranuni(-1) lt 0.5 then call missing(name);
 if ranuni(-1) lt 0.5 then call missing(age);
run;

proc sql;
 select cats('nmiss(',name,') as nmiss_',name) into : list separated by ','
  from dictionary.columns 
   where libname='WORK' and memname='HAVE';

 create table want as
  select &list from have;
quit;

Ksharp