Make sure the length and justification and case of the lname and fname fields are exactly the same in all of the datasets

-----Original Message----- From: Khan, Muhammad [mailto:mkhan@OXHP.COM] Sent: Wednesday, September 23, 1998 1:39 PM To: SAS-L@UGA.CC.UGA.EDU 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;