Date:         Tue, 19 Sep 2000 10:29:09 -0700
Reply-To:     "Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Deppman, Laurie M" <Laurie.Deppman@DOH.WA.GOV>
Subject:      Missing Values
Content-Type: text/plain; charset="iso-8859-1"

I converted geozip from a numeric to a character variable and I tried to
convert the periods for missing values to blanks, but this code does not
work.  Any ideas?

data all (drop=geozip1);
set king(rename=(tract1=tract cnty_res=cntyname geoaddr1=geoaddr
             geocity1=geocity))
        snoh(rename=(tract1=tract cnty_res=cntyname geoaddr1=geoaddr
             geocity1=geocity))
        pier(rename=(tract1=tract cnty_res=cntyname workingadd=geoaddr));

geozip = put(geozip1,5.);
if geozip ='.' then geozip ='';
if tract ='.' then tract ='';
if gcounty='.' then gcounty='';
fcounty = '';
lat = '';
long = '';
run;