RS81 – DATA KEEP and SET KEEP inconsistent (SAS)

DATA KEEP and SET KEEP inconsistent (SAS)

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

DATA KEEP and SET KEEP inconsistent (SAS) DATA PUF97 (KEEP= DUPERSID AGECAT RACETHNX PERWT05F);
    SET CDATA.H97 (KEEP= DUPERSID AGE: RACETHNX RACEX PERWT05FX);
    IF AGE05X>=0 THEN AGE=AGE05X;
    ELSE IF AGE53X>=0 THEN AGE=AGE53X;
    ELSE IF AGE42X>=0 THEN AGE=AGE42X;
    ELSE IF AGE31X>=0 THEN AGE=AGE31X;
    ELSE AGE=AGE05X;
    IF 0<= AGE <18 THEN AGECAT=1;
    ELSE IF 18 <= AGE <65 THEN AGECAT=2;
    ELSE IF AGE>=65 THEN AGECAT=3;
    LABEL AGECAT=’AGE IN YEARS’
      RACETHNX=’RACE/ENTHNICITY’;
run;