sas macro1

[pawandh]

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

[LinusH]

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.

[pawandh]

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.

[Jagadishkatam]

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

[Jagadishkatam]

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