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

[joelee1]

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!

[PaigeMiller · Accepted solution]

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