SAS DI Studio- how do I get automated variable values?

josh_rodriguez — Wed, 13 Jul 2022 15:57:19 GMT

Hi and thank you in advance for reading!

I have a DI Studio job which has a File Reader transformation and then I have a User Written transformation that makes processing based on said data. A silly problem I have is (and this is largely due to my inexperience) I can't get variable values that are automatically generated by the transformation.

Specifically speaking, I'm interested in the value of the personSisID field. The User Written transformation creates this bunch of automatic code based on the file reader, but I just cannot seem to be able to grab the value for said field. How do I get the value of personSisID? Below, I'm pasting said code.

---------------------------------

/*==========================================================================*
* Step: User Written A5UC8ACB.BT0001N6 *
* Transform: User Written *
* Description: *
* *
* Source Table: File Reader - work.W192M8FDL A5UC8ACB.BU0001EY *
* Target Table: User Written - work.W192ZG5OU A5UC8ACB.BU0001F0 *
* *
* User Written: SourceCode *
*==========================================================================*/

%let transformID = %quote(A5UC8ACB.BT0001N6);
%let trans_rc = 0;
%let etls_stepStartTime = %sysfunc(datetime(), datetime20.);

%let etls_recnt = -1;
%let SYSLAST = %nrquote(work.W192M8FDL);

/* Runtime statistics macros */
%etls_setPerfInit;
%perfstrt(txnname=%BQUOTE(_DISARM|&transformID|&syshostname|UserWritten), metrNam6=_DISROWCNT, metrDef6=Count32) ;

%let _INPUT_count = 1;
%let _INPUT = work.W192M8FDL;
%let _INPUT_connect = ;
%let _INPUT_engine = ;
%let _INPUT_memtype = VIEW;
%let _INPUT_options = %nrquote();
%let _INPUT_alter = %nrquote();
%let _INPUT_path = %nrquote(/File Reader_A5UC8ACB.BU0001EY%(WorkTable%));
%let _INPUT_type = 1;
%let _INPUT_label = %nrquote();
%let _INPUT_filetype = WorkTable;

%let _INPUT1 = work.W192M8FDL;
%let _INPUT1_connect = ;
%let _INPUT1_engine = ;
%let _INPUT1_memtype = VIEW;
%let _INPUT1_options = %nrquote();
%let _INPUT1_alter = %nrquote();
%let _INPUT1_path = %nrquote(/File Reader_A5UC8ACB.BU0001EY%(WorkTable%));
%let _INPUT1_type = 1;
%let _INPUT1_label = %nrquote();
%let _INPUT1_filetype = WorkTable;

%let _OUTPUT_count = 1;
%let _OUTPUT = work.W192ZG5OU;
%let _OUTPUT_connect = ;
%let _OUTPUT_engine = ;
%let _OUTPUT_memtype = DATA;
%let _OUTPUT_options = %nrquote();
%let _OUTPUT_alter = %nrquote();
%let _OUTPUT_path = %nrquote(/User Written_A5UC8ACB.BU0001F0%(WorkTable%));
%let _OUTPUT_type = 1;
%let _OUTPUT_label = %nrquote();
/* List of target columns to keep */
%let _OUTPUT_keep = lastName socialSecurityNumber personSisID personCrmId firstName

...

%let _OUTPUT_col1_input0 = socialSecurityNumber;
%let _OUTPUT_col1_input0_table = work.W192M8FDL;
%let _OUTPUT_col1_exp = ;
%let _OUTPUT_col1_input = socialSecurityNumber;
%let _OUTPUT_col1_input_count = 1;
%let _OUTPUT_col2_name = personSisID;
%let _OUTPUT_col2_table = work.W192ZG5OU;
%let _OUTPUT_col2_length = 11;
%let _OUTPUT_col2_type = $;
%let _OUTPUT_col2_format = $11.;
%let _OUTPUT_col2_informat = $11.;
%let _OUTPUT_col2_label = %nrquote();
%let _OUTPUT_col2_input0 = personSisID;
%let _OUTPUT_col2_input0_table = work.W192M8FDL;
%let _OUTPUT_col2_exp = ;
%let _OUTPUT_col2_input = personSisID;
%let _OUTPUT_col2_input_count = 1;
%let _OUTPUT_col3_name = personCrmId;

...

%let _OUTPUT1_keep = lastName socialSecurityNumber personSisID personCrmId firstName

...

%let _OUTPUT1_col1_label = %nrquote();
%let _OUTPUT1_col1_input0 = socialSecurityNumber;
%let _OUTPUT1_col1_input0_table = work.W192M8FDL;
%let _OUTPUT1_col1_exp = ;
%let _OUTPUT1_col1_input = socialSecurityNumber;
%let _OUTPUT1_col1_input_count = 1;
%let _OUTPUT1_col2_name = personSisID;
%let _OUTPUT1_col2_table = work.W192ZG5OU;
%let _OUTPUT1_col2_length = 11;
%let _OUTPUT1_col2_type = $;
%let _OUTPUT1_col2_format = $11.;
%let _OUTPUT1_col2_informat = $11.;
%let _OUTPUT1_col2_label = %nrquote();
%let _OUTPUT1_col2_input0 = personSisID;
%let _OUTPUT1_col2_input0_table = work.W192M8FDL;
%let _OUTPUT1_col2_exp = ;
%let _OUTPUT1_col2_input = personSisID;
%let _OUTPUT1_col2_input_count = 1;
%let _OUTPUT1_col3_name = personCrmId;
%let _OUTPUT1_col3_table = work.W192ZG5OU;

...

---------------------------------

What I have been trying to do is something around this, but to no avail:

%let EMPLID = 1234567;
%let EMPLID = &_OUTPUT1_col2_input;
%let EMPLID = personSisID;

Thank you again!

-Josh

topic SAS DI Studio- how do I get automated variable values? in SAS Programming

SAS DI Studio- how do I get automated variable values?