Here I have an example of using CALL EXECUTE. I wonder why the second code does not work when I omit the concatenation oeprator.
data test;
input a $;
cards;
1
2
3
;
data _null_;
set test end=last;
call execute('proc print data=sashelp.class (obs='||a||'); run;');
run;
data test;
input a $;
cards;
1
2
3
;
data _null_;
set test end=last;
call execute('proc print data=sashelp.class (obs='a'); run;');
run;
The call execute function requires a string to be passed to it as its only parameter. This
'proc print data=sashelp.class (obs='a'); run;'
is not a string, it is two strings:
'proc print data=sashelp.class (obs='
'); run;'
and something undefined.
Function form:
call execute(<string>);
By using the concatenate symbols you are creating one string out of the two given strings and the value held in the variable a.
One other thing, as a string in the dataset is given a length of 8 (as you didn't define it!) you may want to use cats:
data _null_; set test end=last; call execute(cats('proc print data=sashelp.class (obs=',a,'); run;')); run;
This should remove any blanks around a.
This message:
ERROR 253-185: The EXECUTE subroutine call has too many arguments.
provides the answer.
CALL EXECUTE expects ONE argument of type character. You are supplying three: a string constant, a variable of type character, and another string constant.
Because it isn't valid SAS code. The string isn't being created, there's no default concatenation.
The call execute function requires a string to be passed to it as its only parameter. This
'proc print data=sashelp.class (obs='a'); run;'
is not a string, it is two strings:
'proc print data=sashelp.class (obs='
'); run;'
and something undefined.
Function form:
call execute(<string>);
By using the concatenate symbols you are creating one string out of the two given strings and the value held in the variable a.
One other thing, as a string in the dataset is given a length of 8 (as you didn't define it!) you may want to use cats:
data _null_; set test end=last; call execute(cats('proc print data=sashelp.class (obs=',a,'); run;')); run;
This should remove any blanks around a.
Thank you, all. I was assuming I was creating a string by enclosing variable a in quotation marks.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.