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?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.