topic sas macro1 in SAS Programming

sas macro1

pawandh — Sun, 03 Jan 2016 06:05:23 GMT

%macro ab(x);

proc print data=test1 ;where rating in(&x);run;

%mend;
%ab(2,3,4)

here i'm getting error that more positional parameters found but if i write

proc print data=test1 ;where rating in(2,3,4);run;

i'm getting the desired output.

&x also doing the same then y error is cmng?

I think after resolving macro variable to (2,3,4) it should work like a normal sas program.

Please explain how the macro processor is processing these values.

Re: sas macro1

LinusH — Sat, 02 Jan 2016 07:36:08 GMT

The commas between the values make the macro compiler treat them as separate parameters.
In your case the simplest is to skip the commas since IN () can handle blanks as a list separator.

Re: sas macro1

Jagadishkatam — Sun, 03 Jan 2016 02:06:32 GMT

Please mask the commas using the %str while compilation and you could avoid the error. Try calling the macro as below

%ab(%str(2,3,4))

Re: sas macro1

pawandh — Sun, 03 Jan 2016 06:03:03 GMT

if i write

proc print data=test;

where rating in (2,3,4);run;

i get the desired output.

But instead of 2,3,4 if i write a macro variable which has the sam values(2,3,4) then it is not showing the desired result??

macro resolving to 2,3,4 only.so it should print the observations.

Re: sas macro1

Jagadishkatam — Sun, 03 Jan 2016 06:56:03 GMT

Hope you tried %ab(%str(2,3,4))