How do I filter for exclusion of certain values of a variable (BRFSS)

joelee1 — Wed, 11 Mar 2020 16:19:05 GMT

Hi,

I am new to SAS and trying to code to exclude a certain value of a variable. I have:

DATA work.LNGSCNELGBLE;
set brfss.LUNGSCREEN2;
WHERE (PCKYRS >=30) AND (55<= _AGE80 <=80) AND (QTSMKYRS<=15);

Run;

For selecting values of variables that I want, but what code would I use to exclude CNCRTYP1=24. I tried WHERE NOT, which I saw elsewhere, but that did not work. Thank you!

Re: How do I filter for exclusion of certain values of a variable (BRFSS)

PaigeMiller — Wed, 11 Mar 2020 16:50:42 GMT

WHERE (PCKYRS >=30) AND (55<= _AGE80 <=80) AND (QTSMKYRS<=15)
and cncrtyp1^=24;

topic How do I filter for exclusion of certain values of a variable (BRFSS) in SAS Programming

How do I filter for exclusion of certain values of a variable (BRFSS)

Re: How do I filter for exclusion of certain values of a variable (BRFSS)