Скачать или смотреть 52. Can you explain a situation where you have used proc sql to create macro variable in SAS Macro?

@SASInsights : [email protected] || Presented by Dhruba Joshi
In this video we discuss about a situation where we use proc sql select into clause to create macro variable.
If we need to use certain value or values from the variable of a table to further processing steps than we can change that value to macro variable value and use it back where necessary.While updating MDT, if the code runs successfully then process_Status_CD changes to dot(.). If the program throws error than process_Status_CD change to corresponding number. In such scenario, after fixing error we need to change number to 0 that means it is ready to new run. Sometimes it is not efficient to go to check MDT_Process_Status table, identify corresponding id and change the status code. In this situation, it is better to run just below code that changes the status.
Sending corresponding ID to macro variable value:
proc sql;
select ID into: Proc_ID
from DRJ.MDT_Process_Status
where process_Status_CD not in (.,0);
Quit;
%put &Proc_ID.;
Calling and using macro variable value:
proc sql;
update DRJ.MDT_Process_Status
set process_Status_CD =0
where id=&Proc_ID.;
quit;
   • 51. Describe a scenario where you had used...