I appreciate the response. While I may not have understood, the issue is directly between the variable declaration and usage in the following data step. Rather than try to reinvent the wheel here, I am looking for a solution to how to call the previous variable defined as &variable. None of the suggestions thus far have worked, so still trying to find a solution.   Thanks, Josh ... View more

Fair enough:   I'm importing a dataset that translates a text string (a) to another text string (b). I need to then take (b) and use it as a field reference in another dataset. I'm looping through the initial dataset of a to b conversions and for each (b) taking metrics from the field in dataset resultsmerged2. So for example, the first (b) is HR, so I need to add HR to &variable and use it in calculations in the calculation for baseline and change from baseline. Everything works until I try to use the variable. The data tempmod needs to define &variable somehow so I can use it in other sections of the same macro. I can try to explain anything else that is unclear   Thanks, Josh  ... View more

With both updates:   proc sql NOPRINT; /*select name into :varlist separated by ' '*/ create table _Null_ as select * from temp; quit; %let m=&sqlobs; %put &m; %macro tablecreate (Variable); %do i=1 %to &m; %put &i;   data tempmod; set temp; where seq=&i; call symputx('Variable'||trim(left(_n_)), Test, 'g');   run; 　 data resultsmerged2; set resultsmerged2; retain base_val; if timeptno=1 then   do; base_val = &variable&i; end; change_bl = &variable&i-base_val; run;   . . .   %end; %mend tablecreate;   %tablecreate;   Log doesn't show any errors but all records are now producing a value of 1 for base_val and 0 for change_bl. I'm try to take the variable name from the import and use it as the field name in dataset resultsmerged2. Any other ideas?   Thanks!   ... View more

Thank you for your reply. I'm trying to use &variable in the next step inside the macro, but it's not recognizing the variable as populated. ... View more

The variable is the "Variable" created from the symputx. I just need it to carry through to the rest of the macro. The table creation and reporting is done for a metric (ex: HR) and then moves on to the next metric, with a list imported through a csv file. I guess the real question is after the symputx, how do I call that variable in the next data step. ... View more