10-01-2015 10:12 AM
i'm doing the equivalent of a left join in SAS on approximately 32 million rows. The output contains 7 additional rows compared to the original. I looked at the USSGL and there seems to be no pattern as to why it generated addtional rows. Any thoughts?
MERGE FL_AUG (IN=A) XWALK (IN=B KEEP=USSGL DR_CR_IND);
IF (A) THEN OUTPUT;