Date:         Fri, 30 Jun 2006 12:49:57 -0700
Reply-To:     dramage <dramage1@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         dramage <dramage1@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Replacing a Missing Value
Comments: To: sas-l@uga.edu
In-Reply-To:  <1151696839.353587.304620@75g2000cwc.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

data test ;
  infile datalines truncover;
  input s_id $ ab_id $   ;

datalines ;
233
233 55
12  1
424 65
434
434 13032
;
run;

options nocenter;
proc print; run;

proc sql;
 select all a.s_id, a.ab_id
   from test a, test b
     where a.s_id=b.s_id and a.ab_id is not null
;
quit;