Geek Answers Handbook

How to make a SAS DIS job cycle along the rows of the parameter table

I have a SAS DIS job that retrieves and processes some temporary data. The nature of the job is such that the data must be processed bit at a time, month after month. I can use a temporary filter to ensure that any given run is within the required time frame, but then I have to manually change the parameters of this table and repeat the task month after month until all the data has been processed.

Since the time frame extends quite far, I would like to automate this process as much as possible. Ideally, I would have a table that looks like this:

time_parameter_1 time_parameter_2
2JAN2010       1FEB2010
2FEB2010       1MAR2010
...            ...

which can be part of an iterative job that continues to execute my processing job with the values ​​of this table as temporary parameters until the table is exhausted.

From what I understand, loop conversion to SAS DIS is for iterating over tables, not table rows. Is there a decision to put each date in a separate table, or is there a direct way to achieve this?

Thanks a lot.

EDIT

So, using the Dried Post, I determined the solution. Firstly, it seems that SAS DIS requires that the date parameters be passed as text and then converted to the correct date format (at least this is the only way to get the work to work).

The procedure is as follows:

, , "". "" " ". "" ( control_start_date), " " " " "". OK , (, control_end_date - ).

, . () . .

, Loop .

"". " " (control_start_date control_end_date). , . .

. start_date end_date ( DATE9.) :

DATA CONTROL_DATES;

    start_date = input(trim("&control_start_date"),DATE9.);
    end_date = input(trim("&control_end_date"),DATE9.);

RUN;

WORK.CONTROL_DATES (, ), . .

.

PDF, , , , , .

+1
1

LOOP . . , , , ( ).

, SAS DI Studio : PDF

, !

+1

More articles:


All Articles