topic SAS MERGE GENERATING ADDITIONAL ROWS (WHY?) in SAS Programming

SAS MERGE GENERATING ADDITIONAL ROWS (WHY?)

Benbo123321 — Thu, 01 Oct 2015 14:12:06 GMT

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?

My code:

DATA WORK.TEST;

MERGE FL_AUG (IN=A) XWALK (IN=B KEEP=USSGL DR_CR_IND);

BY USSGL;

IF (A) THEN OUTPUT;

RUN;

Re: SAS MERGE GENERATING ADDITIONAL ROWS (WHY?)

Astounding — Thu, 01 Oct 2015 14:15:17 GMT

Have you checked the XWALK data to see if it contains multiple entries for the same USSGL? That's the most likely culprit.

Re: SAS MERGE GENERATING ADDITIONAL ROWS (WHY?)

PGStats — Fri, 02 Oct 2015 03:20:40 GMT

If USSGL identifies unique observations in FL_AUG then

IF A and first.USSGL then output;

should solve the problem.