topic Removing a 'class' of data within a variable in SAS Programming

Removing a 'class' of data within a variable

AaronJ — Mon, 19 Dec 2016 21:29:02 GMT

I want to sub-set a class of data within the variable 'Block'. Essentially, i want SAS to ignore 'D' within my 'Block' variable, while still analyzing 'Block's 'A', 'B, and 'C'.

My code goes something like this ;

Data All Events;

if Phase=1;

if Gas='Nitrous Oxide';

if Block='A','B','C';

etc.......

but i get an error in the Log saying "Expecting arithmetic operator...symbol is not recognized and will be ignored";

Please advise on how to correct this.

Re: Removing a 'class' of data within a variable

Reeza — Mon, 19 Dec 2016 21:30:48 GMT

Post your code with the error please.

From the snippet posted:

if Block='A','B','C';

This is invalid SAS code. You need to use IN as well as brackets instead.

if Block in ('A','B','C');

Re: Removing a 'class' of data within a variable

AaronJ — Mon, 19 Dec 2016 21:35:45 GMT

perfect