topic Re: Probel of call execute in SAS Procedures

Probel of call execute

Mike_Davis — Tue, 26 Jun 2012 16:52:41 GMT

Hello everyone,

why It will cause an error in the first data step while the second data step is ok?

Thanks!

Mike

data _null_;
set sashelp.class;
call execute('%global zzz'name';');
run;
%put _user_;

data _null_;
set sashelp.class;
call execute('%global zzz'||name||';');
run;
%put _user_;

Re: Probel of call execute

Quentin — Tue, 26 Jun 2012 17:20:22 GMT

Hi,

The argument for CALL EXECUTE is a character expression.

In SAS, when you want to build a character expression from text literals and variable values, you use the concatenation operator ( || ) or concatenation functions.

So your first example fails for the same reason that the below fails:

data _null_;
  set sashelp.class;
  a='%global zzz'name';'; 
  put a=;
run;

And below succeeds:

data _null_;
  set sashelp.class;
  a='%global zzz'||name||';';
  put a=;
run;

Does that help?

--Q.

Re: Probel of call execute

FriedEgg — Tue, 26 Jun 2012 17:34:12 GMT

Quentin has provided the answer. Your first method does not create a valid character expression, so it fails. The being said, when calling macro statements in a data step with call execute I prefer to wrap them with %nrstr so that they will run sequentially after the datastep completes instead of in place. This is not always important but I find it to be a good practice to follow:

data _null_;

set sashelp.class;

call execute('%nrstr(%global zzz' || name || ';)');

run;

Another way to do this would be using call symputx:

data _null_;

set sashelp.class;

call symputx('zzz'||name,'','g');

run;