SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Parameterized and Iterative Job

Reply
Super Contributor
Posts: 426

Parameterized and Iterative Job

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!

Super User
Posts: 5,256

Re: Parameterized and Iterative Job

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?

Data never sleeps
Super Contributor
Posts: 426

Re: Parameterized and Iterative Job

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

 

 

Super User
Posts: 5,256

Re: Parameterized and Iterative Job

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.

Data never sleeps
Contributor
Posts: 53

Re: Parameterized and Iterative Job

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.

Ask a Question
Discussion stats
  • 4 replies
  • 371 views
  • 1 like
  • 3 in conversation