topic Re: %let statement with value from table in SAS Programming

%let statement with value from table

vicmaria98 — Tue, 02 Nov 2021 13:43:06 GMT

Is there a way to do something like the below?

%let x = &Table.x;

I want to assign the macro variable to the value that is found in the Table. I cannot use proc sql no print as I am doing this in a datastep.

Re: %let statement with value from table

PeterClemmensen — Tue, 02 Nov 2021 13:52:28 GMT

Use the Call Symputx Routine

like this

data have;
   x = 100;
   
   call symputx('x', x);
run;

%put &x.;

Re: %let statement with value from table

Kurt_Bremser — Tue, 02 Nov 2021 13:50:22 GMT

To set a macro variable from dataset values, you either need PROC SQL with SELECT INTO, or a DATA step with CALL SYMPUT/CALL SYMPUTX.

Re: %let statement with value from table

Tom — Tue, 02 Nov 2021 14:11:21 GMT

@vicmaria98 wrote:

Is there a way to do something like the below?

%let x = &Table.x;

I want to assign the macro variable to the value that is found in the Table. I cannot use proc sql no print as I am doing this in a datastep.

Use the CALL SYMPUTX() function to create a macro variable from a data step.

data _null_;
  set table;
  call symputx('x',x);
run;

But remember that if you need to use that macro variable in the same data step you will need to use the SYMGET() or SYMGETN() to retrieve the value. If you just reference the macro variable with &X that reference will be resolved BEFORE the data step is compiled and so definitely before the CALL SYMPUTX() function call can execute.

If you do need to use the value within the same data step then just leave the value in a data step variable instead of converting it to text to store into a macro variable and then back from text to a variable. Note that you could use a variable that is not written to the output dataset(s). If you need to prevent the data step from setting the variable to missing when it starts its next iteration then use the RETAIN statement.

Re: %let statement with value from table

yabwon — Tue, 02 Nov 2021 15:57:18 GMT

I'm just fooling around but you could "resolve" this problem with %let statement too 😉 😉

data table;
  x = 42;
run;

data _null_;
  set table;
  rc = resolve('%let x = ' || put(x, best32.) || ';');
run;

%put &=x.;

B-)