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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.