I have been joining several tables one step at a time as I build my project (e.g., table A to Table B; Table C to Table D; etc.). I am at the point where I am joining those table to each other (e.g., Table AB to Table CD, etc.). Below is my code for two of those tables and the results are good. However, I use the exact same coding all the way through and on other tables and I get the join but the volume of lines result in about 1600 more lines than the two table combined contain. I am not sure why and have been looking for a reason. Any thoughts? PROC SQL; CREATE TABLE WORK.QUERY_JOIN7(label="QUERY_JOIN7") AS SELECT /* REFERRED_DATE */ (IFN(t1.REFERRED_DATE<>.,t1.REFERRED_DATE,t2.REFERRED_DATE)) FORMAT=MMDDYYS10. LABEL="REFERRED DATE" AS REFERRED_DATE, /* STATE */ (IFC(t1.STATE<>" ",t1.STATE,t2.STATE)) LABEL="STATE" AS STATE, /* PRODUCT_TYPE */ (IFC(t1.PRODUCT_TYPE<>" ",t1.PRODUCT_TYPE,t2.PRODUCT_TYPE)) LABEL="PRODUCT TYPE" AS PRODUCT_TYPE, /* LOB */ (IFC(t1.LOB<>" ",t1.LOB,t2.LOB)) LABEL="LOB" AS LOB, /* REFERRAL_TYPE */ (IFC(t1.REFERRAL_TYPE<>" ",t1.REFERRAL_TYPE,t2.REFERRAL_TYPE)) LABEL="REFERRAL TYPE" AS REFERRAL_TYPE, /* VOLUME */ (1) FORMAT=BESTX10. LABEL="VOLUME" AS VOLUME FROM WORK.QUERY_JOIN5 t1 NATURAL FULL JOIN WORK.QUERY_JOIN6 t2; QUIT; Thanks!
... View more