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; ... View more

I am trying to set my variables for gender to equal 1=female and 0= male this is the code that i am using:   data want; set have; if GENDER = "female" then newgender = 0; else newgender = 1; run;   data want; set have; if GENDER = "male" then newgender = 1; else newgender = 0; run; However, when i run this it sets females and males to 1 and not 1= female and males=0. Is there another way to go about this? ... View more