topic Re: Parameterized and Iterative Job in SAS Data Management

Parameterized and Iterative Job

Babloo — Thu, 03 Mar 2016 15:26:50 GMT

Could someone of you guide me to understand the Parameterized and Iterative Job with some real time example? I've trouble understanding this concept after reading the documentaion. May be some simple example would help me.

Thanks!

Re: Parameterized and Iterative Job

LinusH — Thu, 03 Mar 2016 15:44:32 GMT

A simple example is to import a bunch of files wit the same file structure.

The parameter could be mapped from a list of file names.

The inner job will do the actual importing of files, and insert/append to a permanent data set/table.

If you search support.sas.com there are a few papers with examples. The best way to learn is trying to reproduce them in your environment, using your/sample data.

Do you have any current requirement that maybe can be solved by using this technique?

Re: Parameterized and Iterative Job

Babloo — Thu, 03 Mar 2016 16:25:21 GMT

I don't have any requirement at the moment. However, I would like to know how these jobs will work in real life.

I don't understand the following lines from your comment. Could you please tell me how to pass the parameters to the inner with real example?

The parameter could be mapped from a list of file names.

The inner job will do the actual importing of files, and insert/append to a permanent data set/table

Re: Parameterized and Iterative Job

LinusH — Thu, 03 Mar 2016 18:56:04 GMT

Have a table (registered or a work-table), which for a variable holds name (and potentially the path) to files that you would like to import.

Link that table to the Loop transform. Then add the job that holds the actual ETL logic. Now in the Loop transform you can map the input variables from the parameter table, to the parameter(s) defined for the inner job (Parameter Mapping tab).

There are examples of this in the documentation. Again, try yourself and it will be clearer.

Re: Parameterized and Iterative Job

UCFAngel — Wed, 04 May 2016 14:56:54 GMT

I presented a paper at SAS Global Forum in 2011 on Parameterized and Iterative jobs that may provide an example. The conference proceedings can be found at http://support.sas.com/resources/papers/proceedings11/144-2011.pdf. This paper details an iterative process I developed to create a data table of graduate students for multiple terms.