topic Source and Target Details in macro variable after Completion of SAS DI Job in SAS Studio

Source and Target Details in macro variable after Completion of SAS DI Job

ruchir_m — Mon, 19 Nov 2018 14:36:25 GMT

Hi All,

I need to insert the Source & Target Table Details into a table after completion of my all SAS DI jobs.

I am using a SAS macro as a postcode of my DI job to collect all other details but I am not able to get the source and target table details.

In DI job, I have seen details of the Source/ Target Table in the comment but I am not able to find a process to capture this detail and use it later.

Please let me know if anyone is aware of it.

Thanks in advance

Re: Source and Target Details in macro variable after Completion of SAS DI Job

Kurt_Bremser — Mon, 19 Nov 2018 14:43:06 GMT

Do a

%put _all_;

to see all currently defined macro variables, it might help you.

Just an idea, I don't work with DI Studio.

Re: Source and Target Details in macro variable after Completion of SAS DI Job

ruchir_m — Mon, 19 Nov 2018 14:48:06 GMT

Thanks Kurt.

I tried but i wasn't able to find the macro variable for details on Source and Target table.

Re: Source and Target Details in macro variable after Completion of SAS DI Job

kiranv_ — Mon, 19 Nov 2018 16:45:44 GMT

it has been very longtime i did used DI studio. check for something like below like &_output which is your target table ot &syslast or &_input for source tables

data
&_OUTPUT; 
  set &SYSLAST; 
  length sex $1; 
  if gender = "Male" then 
    sex = "M"; 
  else if gender = "Female" then 
    sex = "F"; 
  else 
  sex="U"; 
run;

Re: Source and Target Details in macro variable after Completion of SAS DI Job

Patrick — Mon, 19 Nov 2018 23:31:38 GMT

@ruchir_m

Look into the code of the transformation where you use the tables as source and target. You'll find in there macro variables generated like &_input and &_output.

Add post code to this node which does something like

%global mySourceTbl myTargetTbl;
%let mySourceTbl=&_input;
%let myTargetTbl=&_output;

You then can use these macro variables in your job post code.

Re: Source and Target Details in macro variable after Completion of SAS DI Job

ruchir_m — Tue, 20 Nov 2018 03:30:59 GMT

Hi Patrick ,

I am not able to find _input and _output variables. Do I need to enable some option?