topic Re: sas mac in SAS Programming

sas mac

pawandh — Sat, 09 Jan 2016 03:29:45 GMT

%macro nn(dt);
%do i=1 %to 3;
%let x=%sysfunc(scan("&dt",&i,',');
%put &x;
data t;
set &x;
run;
proc print;run;
%end;
%mend;
%nn(one,two,three);

want to print all the three data sets,getting error that More positional parameters found than defined.

JoshB — Sat, 09 Jan 2016 03:47:06 GMT

You are passing three parameter (one , two , and three), while only defining one parameter to be passed (dt).

You can either quote what you are trying to pass to the macro

%nn(%quote(one,two,three))

Or, you can modify the macro to include a space as a delimiter in your scan function and pass the parameter separated by spaces.

%macro nn(dt);
%do i=1 %to 3;
%let x=%sysfunc(scan(&dt,&i,', '));
%put &x;
data t;
set &x;
run;
proc print;run;
%end;
%mend;
%nn(one two three)

Jagadishkatam — Sat, 09 Jan 2016 06:05:38 GMT

please try to call the macro as %nn(%nrstr(one,two,three))