Selecting specific SAS inputfiles for a DIS job based on the content of a control table

[JanHettema]

I would like to use a control table (sas table) to define (part of) the name of the input file (sas table) in a DIS job.

For instance in the case where we have a large number of jobs reading year specific input files (sas files)

I would like to create a control table (containing for instance the current year 2017) and then be able to use the content of this control table to steer the inputfile name into my job. So in this case my job will start to use the INPUT_A_2017 and INPUT_B_2017 sas files as input for the job and when I change the datafield in the control file to current year 2018, it will run the same job using the INPUT_A_2018 and INPUT_B_2018 as inputfiles. Where of course these input files 2017 and 2018 have the exact same structure.

If someone could point in a direction I could be persuing to achieve this or to existing information that relates to this question that would be nice. I am trying to use as much standard transformations or user defined transformations to keep it flexible and DIS like, rather than coding it out completely.

[LinusH · Accepted solution]

You want to look for parameterized job. You map the values from your control table to macro variables that you can resolve in your specific job. And then you define your metadata object (SAS file = SAS table?) using the macro variable as part of the physical name.

http://documentation.sas.com/?docsetId=etlug&docsetTarget=p0vak6rd3mdyxhn100mrlh4jzg2b.htm&docsetVer...