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

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

Accepted Solution Solved
Reply
Regular Learner
Posts: 1
Accepted Solution

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

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.


Accepted Solutions
Solution
‎10-23-2017 03:54 AM
Super User
Posts: 5,849

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

Posted in reply to JanHettema

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...

Data never sleeps

View solution in original post


All Replies
Solution
‎10-23-2017 03:54 AM
Super User
Posts: 5,849

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

Posted in reply to JanHettema

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...

Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 166 views
  • 1 like
  • 2 in conversation