Thanks a lot Flip for your help.It's really helpful but the thing is when i am using Innerjoin its giving the both records (36k) of Table A(18k records) and Table B(18k records)
I can perform Proc sort with nodup option but ??
is there any alternative for Except like innerjoin.
Thanks in advance.
here is the log;
358 proc sql;
359 create table test10 as select
359! a.member_no,a.fee,a.surnames,a.title,a.pcode,a.expiry,a.joined,a.name,a.dob,a.email,a.cn
359! tr,a.postc,
360 b.member_no,b.fee,b.surnames,b.title,b.pcode,b.expiry,b.joined,b.name,b.dob,b.email,b.cn
360! tr,b.postc
361 from lsfeb10.febld as a INNER JOIN lsmar10.marld as b
362 on a.surnames=b.surnames and a.pcode=b.pcode;
WARNING: Variable Member_No already exists on file WORK.TEST10.
WARNING: Variable FEE already exists on file WORK.TEST10.
WARNING: Variable Surnames already exists on file WORK.TEST10.
WARNING: Variable Title already exists on file WORK.TEST10.
WARNING: Variable PCODE already exists on file WORK.TEST10.
WARNING: Variable Expiry already exists on file WORK.TEST10.
WARNING: Variable Joined already exists on file WORK.TEST10.
WARNING: Variable Name already exists on file WORK.TEST10.
WARNING: Variable Dob already exists on file WORK.TEST10.
WARNING: Variable Email already exists on file WORK.TEST10.
WARNING: Variable cntr already exists on file WORK.TEST10.
WARNING: Variable postc already exists on file WORK.TEST10.
NOTE: Table WORK.TEST10 created, with 37858 rows and 12 columns.
363 quit;
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be
shifted by the "BEST" format.
NOTE: PROCEDURE SQL used (Total process time):
real time 1.90 seconds
cpu time 0.14 seconds
Message was edited by: ssas
Message was edited by: ssas
... View more