I'm a new SAS's developer. I'm using SAS-DI to create a job. I need to put filename into a column of data because I create a job that read multiple input files and write it into a output file. The filename column will help to trackback to input file. I try to create a external file connect to file reader box. It look like below. In external file (INPUT FILE), I put additional options to keep filename into "infilename" variable. In File Reader box, I put "infilename" variable into expression at the filename column. Running is pass but It error when I try to open output of File Reader box. The error message is "Unable to execute query: SQL passthru expression contained these errors: ERROR: The following columns were not found in the contributing tables: infilename." Please advice me, How to put filename into the data using SAS-DI Please advice me, How to put filename into the data using SAS-DI?
... View more