RS82 – DATA KEEP and DROP inconsistent (SAS)

DATA KEEP and DROP inconsistent (SAS)

The KEEP and DROP settings for the DATA needs to align so as to not cause confusion or invalid results.

DATA KEEP and DROP inconsistent (SAS) DATA PUF97 (DROP= State ZIP);
    SET CDATA.H97 (KEEP= ID Name State Zip Status Country);
    
    IF State = “NSW” THEN output state;
    ELSE IF State = 0 “Qld” THEN output zip;
    Drop Country;
run;