topic SAS set where=? in SAS Programming

SAS set where=?

blakezen — Mon, 16 May 2016 15:27:02 GMT

Hi,

How would I use a set statement with where= options to make a condition of where is "not equal to" x. More precisely:

data file1;

set libref.file2 (where(var 2 is not equal to 0) keep var1 var2 var3;

run;

I know this is basic but would it be something like where(var2=! 0.))

Thanks for any help you may give!

data_null__ — Mon, 16 May 2016 15:30:46 GMT

The proper syntax is

where=(var2 NE 0)

or you could use ^= but I like mnemonics.

blakezen — Mon, 16 May 2016 16:00:00 GMT

Thanks so much!