11-15-2017 11:46 AM
I find myself at a loss with a problem. As my SAS skills are in the early stages of development, I am again reaching out for help.
I've written a DIS (v4.901) program to process input files from a remote system. All will have the same format, but different names. Once I was satisfied it worked, I created an outer program to read create a contents listing of all files to be processed and pass the names as a parameter . I initially had this working, but I made a copy to try out another process... and I made a change somewhere that has now caused 2 errors.
I have attached a word doc with my process and settings for some of the relevant transformations on it as well as the errors I am getting.
Any help would be greatly appreciated!!
11-15-2017 02:07 PM
11-15-2017 04:01 PM
In your Word doc, 3rd screen shot showing the File Location tab, try the option that says "Double quotes around file name". Because you are using a parameter in the file name.
11-15-2017 04:12 PM
And in the 8th screen shot, Prompt Type and Values tab, in the Default value box, can you Browse to the files? If so, select a default for testing. If not, you may need a server definition for the server where the files are located.
11-16-2017 10:51 AM
Selecting the Double quotes option didn't seem to help, but once I did select a file as a default.. it worked ok.
The problem is that the files I process with be moved to an archive folder. so, once this file processed.. it was removed.
The next time I tried to run the program, it said file not found. meaning the defaulted file. I believe that I have to use &filename to represent my incoming file.. but that somewhere in the file location tabs.. I need to default in the Path of the file(s). and I cannot do so using the prompt type and values.
When I had this version working.. I made a renamed copy and changed something. this change affected other versions/copies of the program it seems. I should exported the original to save the settings.
do I have my parm type correct as file or directory? since this will be a filename passed from my control file?
11-16-2017 04:23 PM
I suggest getting the Inner Job to work first so it completes successfully by itself, before putting it in the Loop Job.