Thanks Tom. That helped. So that means I do not need to use the set &SYSLAST; but a direct reference is OK. Also, the &_INPUT# usage depnds on the order of input table joins. Thanks, ... View more

That is correct. Following is my code in the GT: --------------------- code --------------------------------------------- data CODES; proc sql noprint;      select CONFIGID, PARAMETER_2, RESULT_VAL_CODE as SUBTYPE from _INPUT2       where CONFIGID='xxx1' and PARAMETER_2='xxx2';      %put CONFIGID PARAMETER_2 SUBTYPE; quit; %put CONFIGID PARAMETER_2 SUBTYPE; run; --------------------- code --------------------------------------------- But when I reference these I get an error message: --------------------- log --------------------------------------------- 174        proc sql noprint; 175             select CONFIGID, PARAMETER_2, RESULT_VAL_CODE as SUBTYPE from _INPUT2 176              where CONFIGID='xxx1' and PARAMETER_2='xxx2'; ERROR: File WORK._INPUT2.DATA does not exist. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 177             %put CONFIGID PARAMETER_2 SUBTYPE; CONFIGID PARAMETER_2 SUBTYPE 178        179        quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds --------------------- log --------------------------------------------- I think there is more to it to reference the inout tables. ... View more

I created a Generated Transformation (GT) with the following code and it is runing successfully as it returns values through my put ... statement at the end. However, despite I have checked the boxes for Input/Output tab for both input and output macro variables, I am unable to pass the values for cid and tstamp to my next transformation which is a dataloader. I'll appreciate help in mapping the values to output work table. If you need details I can do and export of the job and submit screenshots as well. Thanks, ------------------------------------------------------------------------------------------- data want; set &SYSLAST;   merge &syslast(where=(element_id=1) rename=value=cdate)         &syslast(where=(element_id=2) rename=value=chour)   ;   by case_id;   timestamp = input(compress(cdate||':'||chour||':00:00'),anydtdtm.);   format timestamp datetime.;   /*put timestamp;   */    vcid=case_id;    vtstamp=timestamp;    put vcid vtstamp; run; ---------------------------------------------------------------------------------------------------------- ... View more

Thanks to all who replied. I am extracting the data from Oracle and need to post is to SQL server. Transpose seems to be a good choice as I am not very much into SAS programming yet. Will appreciate if some one can get a simple approach to this problem. And if I am writing my own Transformation how do I connect to the output from previous transformation result ( say EXTRACT) and to output to other transformation. ... View more

You can use: %put your variable name to verify that you actually have returning values and use this at different steps to debug the code. Then after running the job you can open the LOG tab and look for the returning values to confirm that the code actually runs. ... View more