I'm trying to do some manipulations on a csv file which I've read in to the Job Editor Window using the standard file reader. In order to do so, I connect the file reader to the input node of a User Generated Code transformation, and then follow the instructions at this link.
To make things as simple as possible, the code simply creates a new field called TEST and sets it identically equal to 1:
DATA TEMP;
TEST = 1;
RUN;
When I try to view the output by right clicking on the output flap (after running the project) and selecting "Open", I receive the following error messages for each of the columns (*) of the input file:
Column * could not be found in the table/view identified with the correlation name W8T38KNJ....
Google thinks this link is apropos, though I disagree since I haven't renamed any of my columns.
It may be useful to mention that this is my first day working with SAS DIS. Any help with this would be greatly appreciated.
You haven't referenced a data set in your Data step. The code above would create a data set with a single variable and observation with value 1. Something like the following with a SET statement may be what you're looking for. I don't work with DI though, so not sure what the output table name should be, i.e. the name in the DATA statement.
DATA TEMP;
SET &SYSLAST;
TEST = 1;
RUN;