topic Help needed with Loop transformation in SAS Data Management

Help needed with Loop transformation

forumsguy — Wed, 08 Feb 2012 18:18:54 GMT

Hi there,

Can somebody give me guideline on how to achieve this using SAS DI loop transform...

Flow is SAS Base Table =====> Table Loader======> Staging Table

This SAS Base Table has structure of

Column1 Column2 Filename

1 2 file1.csv

2 3 file2.csv

3 4 file3.csv

Now in my Final Staging Table I have unique ID which I am getting from my audit table

Column1 Column2 Filename File_ID

1 2 file1.csv 367

2 3 file2.csv 385

3 4 file3.csv 396

So basically I need to iterate this job for all groups of filenames from my input table. I hope I am clear with my requirement and making sense....

Help needed with Loop transformation

Halaku — Thu, 09 Feb 2012 20:51:14 GMT

Create the inner job that you want to run in the loop. the job should have INPUT parameters defined.

These input parameters will be mapped later.

1. Put a LOOP transformation and link it to stage-table.

2. Open 'Parameter Mapping' tab of the LOOP and map the parameters you want, Column1 and File_Id in your case.

Put the END LOOP and the end.

Run the job.

Help needed with Loop transformation

forumsguy — Fri, 10 Feb 2012 19:29:58 GMT

Thank you very much.. it worked... now can somebody help me in integrating this in one job itself... because this is for loading csv files in table and we will have around 50 fact tables so this will create about 100 jobs which are difficult to maintain......

Please find attached snapshot of my outer and inner job... can we do both these things in same job is my question...