sas dis - How to make a SAS DIS job loop over rows of a parameter table -

i have sas dis job extracts , processes timestamped data. nature of job such data must processed bit @ time, month month. can use time filter ensure given run within required timeframe, must manually change parameters of table , rerun job, month month, until data processed.

since timeframes extend quite far, i'd automate process as possible. ideally i'd have table has following form:

time_parameter_1 time_parameter_2 2jan2010       1feb2010 2feb2010       1mar2010 ...            ... 

which part of iterative job continues execute processing job values of table time parameters until table exhausted.

from understand, loop transformation in sas dis designed loop on tables, rather rows of table. solution put each date in separate table, or there direct way achieve this?

much gratitude.

edit

so, of sushil's post, have determined solution. firstly, seems sas dis requires date parameters passed text , converted desired date format (at least, way things work).

the procedure follows:

in grid view of job looped over, right click , select properties. navigate parameters tab , select new group. name parameter in general tab (let's use control_start_date) , in prompt type , values tab select prompt type "text". press ok , add other parameters using same method (let's control_end_date parameter).

create controlling job loop on parameterized job. import or create table of parameters (dates) loop over. these should character representations of dates.

connect table of parameters loop transformation, connect parameterized job right end of loop transformation, , connect right end of parameterized job loop end transformation.

right click loop transformation , select properties. select parameter mapping tab , map control table date columns parameters of parameterized job (control_start_date , control_end_date). in target table columns tab ensure parameter columns mapped target table. select ok.

in parameterized job, create user written code transformation. create columns start_date , end_date (type date9.) , populate output work table using following code:

data control_dates;      start_date = input(trim("&control_start_date"),date9.);     end_date = input(trim("&control_end_date"),date9.);  run; 

connect dates in work table work.control_dates logic of job (possibly join) serve filters in desired capacity. save parameterized job.

now running controlling job should able loop on job using specified date filters.

a lot of described in following pdf, i'm not sure how long link survive , of issues encountered not addressed there.

your understanding loop transformation incorrect. not need separate table loop transformation make parameterized job flow loop. table has time parameters can input loop transformation , parameterized job can loop based on control table(input table loop transformation).

here example usage of loop transformation different 1 mentioned in sas di studio documentation , relevant problem : pdf

let me know if helps!