How to scan a where statment out from a macro variable

[Coooooo_Lee]

Hi 

I stored some where statements into a macro variable separated by '# ' and I'd like to scan the statement out one by one for deriving a new variable.
Below is a simple example but failed

%let whr=%str(TYPE eq 'A'#TYPE eq 'B'#TYPE eq 'C'#TYPE eq 'D');
%let x=%scan(&whr,1,'#');

%put &x;

When I tried to %put &x, only 'TYPE eq' was displayed in log.

Does anyone can give a hand? Thanks!

[ChrisNZ · Accepted solution]

You are telling SAS that the single quote is a separator, so SAS obeys.

This works:

%let x=%scan(&whr,1,#);

[Kurt_Bremser]

Background: the macro language is a text processor and knows no other datatype, so quotes are not needed to identify strings. Instead they will become part of the "data".