topic Re: How to scan a where statment out from a macro variable in SAS Programming

How to scan a where statment out from a macro variable

Coooooo_Lee — Fri, 26 Jul 2019 06:04:15 GMT

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!

Re: How to scan a where statment out from a macro variable

ChrisNZ — Fri, 26 Jul 2019 06:07:08 GMT

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

This works:

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

Re: How to scan a where statment out from a macro variable

Kurt_Bremser — Fri, 26 Jul 2019 08:03:31 GMT

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".