Hello, I just start learning SAS and I need to create a temporary dataset (walkbike6) selecting individuals from the variable paq635 =1 (people that report walking/biking) but do not bring the missing of this variable neither the missing or "do not know (99, 7777, 9999, etc) from the other variables in the dataset. This is my code and it seems to work but I was ask to use WHERE and IF statement and I cannot figure it out how to do it. I would really appreciate some help. Lisbeth DATA WALKBIKE6; SET NHANES.PAQ_FF; where paq635 =1 AND paq635 not= .; IF PAQ605 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ620 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ650 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ665 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ635 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ610 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ625 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ655 IN('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ670 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAQ640 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAD615 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAD630 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAD660 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAD675 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; IF PAD645 IN ('2' '7' '9' '77' '99' '7777' '9999' '.') THEN DELETE; RUN;
... View more