I am getting a:
Expected close parenthesis after macro function invocation not found
fro this code:
data _null_; set LoopData; call execute('%nrstr(%SomeMacro('||ColumnName||'))'); run;
Cannot see anything wrong. Any ideas?
Agree, that bit looks fine. Maybe there's a problematic macro call inside of %SomeMacro, or maybe your ColumnName variable has an unmatched open parenthesis in it.
I tested your code with below, and worked fine:
%macro somemacro(columnName);
proc print data=sashelp.class;
var &columnName;
run;
%mend somemacro;
data loopdata;
input columnName $8.;
cards;
sex
weight
height
;
run;
data _null_;
set LoopData;
call execute('%nrstr(%SomeMacro('||ColumnName||'))');
run;
I would try calling %SomeMacros manually (i.e., without CALL EXECUTE), and make sure it works. Then I would look at all the values in ColumnName to check for any surprises.
Agree, that bit looks fine. Maybe there's a problematic macro call inside of %SomeMacro, or maybe your ColumnName variable has an unmatched open parenthesis in it.
I tested your code with below, and worked fine:
%macro somemacro(columnName);
proc print data=sashelp.class;
var &columnName;
run;
%mend somemacro;
data loopdata;
input columnName $8.;
cards;
sex
weight
height
;
run;
data _null_;
set LoopData;
call execute('%nrstr(%SomeMacro('||ColumnName||'))');
run;
I would try calling %SomeMacros manually (i.e., without CALL EXECUTE), and make sure it works. Then I would look at all the values in ColumnName to check for any surprises.
Personally when using CALL EXECUTE() to generate macro calls I wrap the %NRSTR() macro function just around the macro name itself and leave the macro parameters without macro quoting.
data _null_;
set LoopData;
call execute(cats('%nrstr(%SomeMacro)(',ColumnName,')'));
run;
Are you sure that the value of ColumnName does not contain '()' characters?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.