topic Re: Urgent Req: Finding out Number of Missing values in SAS Programming

Urgent Req: Finding out Number of Missing values

deleted_user — Mon, 02 Mar 2009 06:21:31 GMT

Hi All,

I have a dataset with approx 40 variables which are integer as well as string datatypes. I would like to find out number of missing values and number of non missing values for each variable and output them to a output dataset.

Rather than hardcoding the variable names in proc sql i would like to automate them.

Thanks & Regards
Samuel

Re: Urgent Req: Finding out Number of Missing values

sbb — Mon, 02 Mar 2009 17:15:00 GMT

test reply - ignore.

Re: Urgent Req: Finding out Number of Missing values

sbb — Mon, 02 Mar 2009 17:16:09 GMT

[Sorry - SAS website server hangs with a more detailed post]

With PROC SQL (similar to other SAS dataset option/parameter specifications), explore using the (KEEP=_NUMERIC_) parameter to select all SAS variables of a particular type.

Scott Barry
SBBWorks, Inc.

Re: Urgent Req: Finding out Number of Missing values

sbb — Mon, 02 Mar 2009 17:16:43 GMT

[So I am breaking it up into two parts]

The SAS support website http://support.sas.com/ has SAS product documentation and supplemental technical papers - the site's SEARCH facility can be used or consider the Google advanced search argument below which yields matching search results on the site using your topic (note that the site parameter must be in lowercase characters or it is ignored by Google):

proc sql data set options site:sas.com

Scott Barry
SBBWorks, Inc.

Re: Urgent Req: Finding out Number of Missing values

Patrick — Mon, 02 Mar 2009 22:25:13 GMT

Hi Samuel
That should do the job.
HTH
Patrick

data have;
infile datalines truncover;
input var1 $1-2 var2 3-4 ;
datalines;
a 1
2

e 4
;
proc sql noprint;
select 'sum(missing('||name||')) as '||name into :SelList2 separated by ', '
from dictionary.columns
where libname='WORK' and memname='HAVE';

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

title 'N Missings per Variable';
proc print data =want noobs;
run;