topic Re: Merge datasets and control output records with IN in SAS Programming

Merge datasets and control output records with IN

apple — Wed, 06 Apr 2016 04:07:08 GMT

DATA Merged;
MERGE FileA (IN=A) FileB (IN=B) FileC (IN=C);
BY UIN;
IF A AND (B or C);


RUN;

Will "IF A AND (B or C);" output (A and B) and (A and C)?

Thank you

Re: Merge datasets and control output records with IN

Reeza — Wed, 06 Apr 2016 04:07:49 GMT

No, that resolves to

(A and B) OR (A and C)

Yours is equivalent to A and B and C

Re: Merge datasets and control output records with IN

FreelanceReinh — Wed, 06 Apr 2016 22:50:36 GMT

@apple: In everyday language, the IF condition does select "[both] observations with (A and B) and [observations with] (A and C)." In technical language (and SAS syntax), however, this is described as "(A and B) or (A and C)."