Hi and thank you in advance for reading!   I have a working SOAP node. It is able to successfully read from my Request file and write to the Response file and make the Update web service action as expected. This works:   The problem is: how do I pass parameters to the Request file? It only works if I pre-populate the file.   The idea is to read from the file (as in the 1st screenshot) and pass the EMPLID field to the SOAP transformation, but I cannot get that to work. The SOAP transformation is working by itself; the File Read transformation is in no way being considered by the node, and that's were I'm stuck.   Again, thank you! -Josh     ... View more

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   ... View more

Hi, and thank you in advance!   (I'm using SAS DI Studio 4.905.)   I currently have a Job that has 3 objects in it in the following order: -Text File, which is comprised of a header with the columns, and the subsequent lines have rows of data. -A File Reader transformation, which helps read said file.  -A Data Validation transformation, which will validate that the headers/columns are correct. (Eg: validate that the EMPLID field has a header of "WCU ID". If this is not the case, the program will abort.)   Currently, this Job is working fine. It is able to process 1 file at a time.   What I'm trying to do is make it work for multiple files. Currently, I have 4 files to process, but it only seems to be doing the validation for the first file.    I have tried adding a Loop here and there, but same result. (Most likely I'm doing it wrong.)   I attached screenshots with what I have set up. I have also pasted below the User written body code of the File Reader. Please advise.   proc datasets lib = work nolist nowarn memtype = (data view); delete WHOZG0KF; quit; data work.WHOZG0KF / view = work.WHOZG0KF ; infile 'FILE_LOCATION_GOES_HERE/slatetosisupdate*' lrecl = 431 delimiter = '|' dsd missover firstobs = 1 obs = 1; ; attrib EMPLID length = $11 format = $11. informat = $11.; attrib WCU_SLATE_APP_NUM length = $50 format = $50. informat = $50.; attrib ACAD_CAREER length = $4 format = $4. informat = $4.; attrib ADMIT_TYPE length = $3 format = $3. informat = $3.; attrib ACAD_PLAN length = $10 format = $10. informat = $10.; attrib HOUSING_INTEREST length = $1 format = $1. informat = $1.; attrib WCU_SLATE_EMPLID length = $50 format = $50. informat = $50.; attrib WCU_AD_RNL_INDEX length = $5; attrib WCU_AD_AWRD_AMT length = $8; attrib ADM_APPL_NBR length = $8 format = $8. informat = $8.; attrib RECRUITMENT_CAT length = $4 format = $4. informat = $4.; attrib WCU_ARTIC_CODE length = $10 format = $10. informat = $10.; attrib PROG_ACTION length = $4 format = $4. informat = $4.; attrib PROG_REASON length = $4 format = $4. informat = $4.; attrib ACTION_DATE length = $18; attrib PROG_ACTION_2 length = $4 format = $4. informat = $4.; attrib PROG_REASON_2 length = $4 format = $4. informat = $4.; attrib ACTION_DT_2 length = $18; attrib PROG_ACTION_3 length = $4 format = $4. informat = $4.; attrib PROG_REASON_3 length = $4 format = $4. informat = $4.; attrib ACTION_DT_3 length = $18; attrib EFFSEQ length = $3; attrib ERROR length = $1; attrib WCU_STU_REC_UPD length = $1; attrib DATE1 length = $18; input EMPLID WCU_SLATE_APP_NUM ACAD_CAREER ADMIT_TYPE ACAD_PLAN HOUSING_INTEREST WCU_SLATE_EMPLID WCU_AD_RNL_INDEX WCU_AD_AWRD_AMT ADM_APPL_NBR RECRUITMENT_CAT WCU_ARTIC_CODE PROG_ACTION PROG_REASON ACTION_DATE PROG_ACTION_2 PROG_REASON_2 ACTION_DT_2 PROG_ACTION_3 PROG_REASON_3 ACTION_DT_3 EFFSEQ ERROR WCU_STU_REC_UPD DATE1; run; %rcSet(&syserr);            ... View more

Hi All, and thanks in advance!!!   I recently found out that my File Writer transformation is outputting blank spaces instead of nulls. I need it to be nulls. I've tried several things, but to no avail. The closest thing that's gotten me to where I'm trying to go is to use the "Treat consecutive delimiters as a single delimiter" option on the very first File Reader transformation and then modifying the File Writer transformation code on the "put" section to display the field values without the ""s. And it does the trick.  However, a big drawback is that it is cutting of the values of 1 or 2 other fields, for some reason. This is odd, because I double and triple-checked the lengths, formats, and informats of said fields on every single transformation and everything is in sync throughout all of the transformations.   Again, thank you for any help you might give this SAS newbie!!! -Josh ... View more