topic Re: Filter for two variable in macros in New SAS User

Filter for two variable in macros

BrahmanandaRao — Sun, 22 Sep 2019 06:53:23 GMT

%macro t1(a,b,c);
data &a;
set &a	;
where Type eq (&c and Origin &c);
run;
%mend t1;

%t1(dsn,sashelp.cars,	'Sedan' & 'Asia');

why error please advise me

Re: Filter for two variable in macros

Kurt_Bremser — Sun, 22 Sep 2019 08:41:17 GMT

Rule #1 of macro development: start with working SAS code.

By manually resolving your macro parameters, I get this code:

data dsn;
set dsn;
where Type eq ('Sedan' & 'Asia' and Origin 'Sedan' & 'Asia');
run;

The where condition is very obviously invalid syntax. Fix that in the data step code, and then start to make it dynamic by proper use of macro variables.

Re: Filter for two variable in macros

PaigeMiller — Sun, 22 Sep 2019 11:20:34 GMT

Agreeing with @Kurt_Bremser , you have to create working SAS code without macro variables first. If your code doesn't work properly without macro variables, then it will not work properly with macro variables.

Also, you rarely need to have the values of macro variables enclosed in quotes.