topic Re: DI Studio looping with parameters -error in SAS Data Management

DI Studio looping with parameters -error

cnilsen — Wed, 15 Nov 2017 16:46:38 GMT

Hi Community!

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!!

Re: DI Studio looping with parameters -error

cnilsen — Wed, 15 Nov 2017 19:07:39 GMT

as a follow up.. I realized that this might be an issue.. did I set up this path correctly as part of my parameter settings: /dmadata/AS400
I am using &filename as my input parm.

Re: DI Studio looping with parameters -error

RLigtenberg — Wed, 15 Nov 2017 21:01:05 GMT

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.

Re: DI Studio looping with parameters -error

RLigtenberg — Wed, 15 Nov 2017 21:12:48 GMT

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.

Re: DI Studio looping with parameters -error

cnilsen — Thu, 16 Nov 2017 15:51:12 GMT

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?

Re: DI Studio looping with parameters -error

RLigtenberg — Thu, 16 Nov 2017 21:23:14 GMT

I suggest getting the Inner Job to work first so it completes successfully by itself, before putting it in the Loop Job.

Does the Inner Job run successfully with a hardcoded value for the File Name on the File Location tab in screen shot #3?
Does the Inner Job run successfully with &filename as the File Name, the double quotes option and a default value for the &filename parameter? You can assign a default value, for example, on the Parameters tab in the GFGB table properties or with a %let statement in the job or transformation precode. This default value can include the full path to the source file. (The Prompt Type can be "Text". The "File or directory" type gives the convenient Browse feature to pick up the path and file)