In our current process. We are planning to implement the parameter file in such a way to pull the records directly from a teradata table and use that as parameter file.
Table A (Permenent table in Teradata)
Expt id Run_date param_name param_value
1 12/06 coef 1.645
1 12/06 location %str('/sas/abc')
2 12/06 coef 1.765
2 12/06 location %str('/sas/b')
I need to query this table based on the run date and pull the information of the expt_id's and run the whole SAS code twice because there are two experiments.
How can I resolve the above to
%let coef = 1.645;
%let coef = %str('/sas/b');
or anyway where these are the macro variables
Appreciate your help!!