Hi, I'm trying to create a job in DI Studio which will check to see which jobs have been redeployed on the present day to send a list to our SAS admin. So i basically want to list all the files in the Jobs directory in sas config and add a date modified column, as any new modified jobs would have been deployed. Can anyone help with this please? Thanks
... View more
@PatrickOne work around i have found is by ticking Override generated INFILE statement with the following statement in the Advanced file parameters tab you can move the length statement to the correct position and you wont get a warning. i'm basically reading in the headings of multiple .csv files to make sure a certain column exists before the file is allowed to enter a flow. So if any headers are missing it will put the problem files in a check folder and carry on checking other files instead of failing.
... View more
Hi, I'm having trouble adding the filenames to a DI Studio External File. I have followed this post How to put filename into the data using SAS-DI? and In the Advanced File Parameters i have added filename=_infilename; length _infilename Filename_Used $255; Filename_Used=_infilename; But when i run the Transformation it only brings back 8 characters and the following WARNING: Length of character variable _infilename has already been set. Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable. Can anyone help please? Thanks
... View more