SAS set where=?

[blakezen]

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__ · Accepted solution]

The proper syntax is

where=(var2 NE 0)

or you could use ^= but I like mnemonics.

[blakezen]

Thanks so much!