DATA Step, Macro, Functions and more

Removing a 'class' of data within a variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Removing a 'class' of data within a variable

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.


Accepted Solutions
Solution
‎12-19-2016 04:32 PM
Super User
Posts: 17,912

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

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');

View solution in original post


All Replies
Solution
‎12-19-2016 04:32 PM
Super User
Posts: 17,912

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

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');
Occasional Contributor
Posts: 14

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

perfect
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 133 views
  • 0 likes
  • 2 in conversation