topic Re: Missing values issue in New SAS User

Missing values issue

Daisy808 — Mon, 07 Dec 2020 19:30:08 GMT

I have a data set where i grouped the age groups and then i wanted to assign a number to each group but when i run the code some of them work but then some groups don't show any numbers. Only 0-9 and 65+ works the rest of them are blank

DATA work.import;
SET work.import;
IF (AGE >=0) AND (AGE<=9) THEN NAGE= "0-9 YEARS";
IF (AGE >=10) AND (AGE<=17) THEN NAGE= "10-17 YEARS";
IF (AGE >=18) AND (AGE<=35) THEN NAGE= "18-35 YEARS";
IF (AGE >=36) AND (AGE<=50) THEN NAGE= "36-50 YEARS";
IF (AGE >=51) AND (AGE<=64) THEN NAGE= "51-64 YEARS";
IF (AGE >=65) THEN NAGE= "65+";
RUN;

data work.import;
set work.import;
if NAGE =  "0-9 YEARS" THEN groupage=1;
if NAGE = "10-17 YEARS" THEN groupage=2;
if NAGE = "18-35 YEARS" THEN groupage=3;
if NAGE = "36-50 YEARS" THEN groupage=4;
if NAGE = "51-64 YEARS" THEN groupage=6;
if NAGE = "65+" THEN groupage=7;
run;

Re: Missing values issue

yabwon — Mon, 07 Dec 2020 20:06:15 GMT

Try this one:

DATA work.import;
  SET work.import;

  select;
    when ( (AGE >=0 ) AND (AGE<=9 ) ) do; NAGE= "0-9 YEARS";   groupage=1; end;
    when ( (AGE >=10) AND (AGE<=17) ) do; NAGE= "10-17 YEARS"; groupage=2; end;
    when ( (AGE >=18) AND (AGE<=35) ) do; NAGE= "18-35 YEARS"; groupage=3; end;
    when ( (AGE >=36) AND (AGE<=50) ) do; NAGE= "36-50 YEARS"; groupage=4; end;
    when ( (AGE >=51) AND (AGE<=64) ) do; NAGE= "51-64 YEARS"; groupage=5; end;
    when ( (AGE >=65)               ) do; NAGE= "65+";         groupage=6; end;
    otherwise put "ERROR: value!";
  end;
RUN;

One more side note: if I were you I would use not:

(AGE >=0 ) AND (AGE<=9 )

but rather:

(AGE >=0 ) AND (AGE < 10)

All the best

Bart

Re: Missing values issue

ballardw — Mon, 07 Dec 2020 22:04:27 GMT

The reason you only get correct values for last group is because when you use multiple IF statements with the same variable then the result from the LAST one is kept. With IF statements you would use ELSE so that when the previous test was false it go to the next one.

DATA work.import;
SET work.import;
     IF (AGE >=0) AND (AGE<=9) THEN NAGE= "0-9 YEARS";
Else IF (AGE >=10) AND (AGE<=17) THEN NAGE= "10-17 YEARS";
Else IF (AGE >=18) AND (AGE<=35) THEN NAGE= "18-35 YEARS";
Else IF (AGE >=36) AND (AGE<=50) THEN NAGE= "36-50 YEARS";
Else IF (AGE >=51) AND (AGE<=64) THEN NAGE= "51-64 YEARS";
Else IF (AGE >=65) THEN NAGE= "65+";
RUN;

And again, using

Data work.import;
   set work.import.

Is just asking for problems as this replaces the source data set every time you use the same data set.

All you need is one typo like

IF Age > 65;

to lose a lot of data.