Date:         Mon, 12 Jan 1998 19:56:43 -0500
Reply-To:     Jules Bosch <JBOSCH/0006974523@MCIMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Jules Bosch <JBOSCH/0006974523@MCIMAIL.COM>
Subject:      Discovering Missing Data

A user was interested in discovering missing values in a data set.  The SAS
product "SAS Today - A Year of SAS Tips" (a day-at-a-time desk calendar full
of interesting SAS info) lists a program that allows one to get the count
and % of missing values for each var in a given data set.
 
It reads -
 
proc format;
   value NUMFMT
       .         = 'missing'
       ._, .A-.Z = 'special missing';
 
   value $CHARFMT
       ' '       = 'missing'
       other     = 'not missing';
 
proc freq data=dsn;
   tables _all_ / missing;
   format _numeric_ NUMFMT.
          _character_ $CHARFMT.;
run;
 
HTH.
 
Jules Bosch
jules_bosch@mcimail.com