Date:         Wed, 23 Sep 1998 13:38:46 -0400
Reply-To:     "Khan, Muhammad" <mkhan@OXHP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Khan, Muhammad" <mkhan@OXHP.COM>
Subject:      Match merging

Hi---
I am trying to merge three data sets (b,c,d) to the master file i.e dataset
a by lname and fname.  when I use the following code. I get the result, but
it is not accurate for the dataset d.  I think I am doing something wrong
but I can't figure it out.  Any help will be greatly appreciated.
 
Thanks
 
Muhammad Khan
mkhan@oxhp.com
 
/*dataset a=oxhpkhan
  dataset b=nwkhan
  dataset c=phkhan
  datase d=lawrkhan */
 
 
 
proc sort data=oxhpkhan;
by LNAME FNAME;
run;
 
proc sort data=nwkhan;
by LNAME FNAME;
run;
 
proc sort data=phkhan;
by LNAME FNAME;
run;
 
proc sort data=lawrkhan;
by LNAME FNAME;
run;
 
 
data all;
merge oxhpkhan(in=a)
      nwkhan(in=b)
      phkhan(in=c)
      lawrkhan(in=d);
by LNAME FNAME;
if a;
if a and b then nw='Y';
else if a and c then phel='Y';
else if a and d then lawr='Y';
 
run;
 
proc sort data=all;
by LNAME FNAME;
run;
options ls=250 ps=2000 nodate nonumber;
proc print data=all;
id LNAME FNAME;
var phel lawr nw address1 address2 city state county membr_cn prov_id
spec_cod ;
run;