03-11-2011 10:28 PM
03-21-2011 10:13 AM
12-04-2012 06:44 AM
I'm not sure on how you need to use this.
Depending on your issue, but maybe using _output_col0_exp might help in some situations?
I have also felt the need to have more help with the input definitions, but I have more looked for something corresponding to all that is set up for output.
12-04-2012 07:09 AM
Using _output_col0_exp actually shows my problem. It contains an unqualified reference to the mapped column so the originating table cannot be established. Bottom line is I think there is no straightforward solution.
Anyways I am still looking for the macro code. I once downloaded it but lost the file and now the link is broken. Anyone?
12-04-2012 08:37 AM
I guess you are looking for a way to see the column mapping as macro variables?
This could be very handy, but the question is how to use it right off? The method of choosing input data is very different between SQL and the data step, for instance, so it would still require some additional macro programming.