Urgent Req: Finding out Number of Missing values

[deleted_user]

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

[sbb]

test reply - ignore.

[sbb]

[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.

[sbb]

[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.

[Patrick]

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;