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. ... View more

I have a macro below that is used to assign values to macro variables. I then want to call that macro inside another written macro that takes a value in the sas dataset as the parameter for the other macro.  %macro pde1b (Table = ); proc sql noprint; select sd_ded into :sd_ded from work.&Table; quit; proc sql noprint; select sd_icl into :sd_icl from work.&Table; quit; %mend pde1b;   Example code: %macro pde1; data x; %pde1b (Table = x.id); /**DO OTHER THINGS USING MACRO VARIABLES**/ run; %mend pde1;   I am also getting a 1 unclosed DO block error message for the %pde1b but I do not have any do blocks in that code and all sections have quit; The code works before I added this as well.    How can I fix this? Or is there another way I can accomplish this? ... View more

I currently have code with a bunch of %let statements which are then used to do calculations with my data. My goal is to create a macro that reads in a sas table and changes those %let value statements. Is there a way to assign %let to variable values in a table? ... View more