https://communities.sas.com/t5/SAS-Data-Management/SAS-Data-Integration-Studio-parametrizing-job-using-a-csv-file/m-p/636186#M19052 <P>There are of course several ways of doing, what to chose is based on your detailed requirement.</P> <P>&nbsp;</P> <P>One way is to import the csv to a SAS data set, and then perform an inner join or WHERE <EM>x</EM> IN(<EM>subquery</EM>...) construct.</P> <P>Another way is to again import the csv file, and then use it as a driver to a loop transformation, where you map you file contents to job parameters (which you can use as macro variables in the "inner" job).</P> <P>&nbsp;</P> Tue, 31 Mar 2020 11:54:22 GMT LinusH 2020-03-31T11:54:22Z https://communities.sas.com/t5/SAS-Data-Management/SAS-Data-Integration-Studio-parametrizing-job-using-a-csv-file/m-p/636110#M19050 <P>Hi!</P><P>&nbsp;</P><P>How can we create parameters for SAS DI jobs by reading a .csv file. For example, I would like to select all rows with where clause with parameters from the .csv file.</P><P>&nbsp;</P><P>Regards</P> Tue, 31 Mar 2020 09:15:05 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-Data-Integration-Studio-parametrizing-job-using-a-csv-file/m-p/636110#M19050 TomekQ 2020-03-31T09:15:05Z https://communities.sas.com/t5/SAS-Data-Management/SAS-Data-Integration-Studio-parametrizing-job-using-a-csv-file/m-p/636186#M19052 <P>There are of course several ways of doing, what to chose is based on your detailed requirement.</P> <P>&nbsp;</P> <P>One way is to import the csv to a SAS data set, and then perform an inner join or WHERE <EM>x</EM> IN(<EM>subquery</EM>...) construct.</P> <P>Another way is to again import the csv file, and then use it as a driver to a loop transformation, where you map you file contents to job parameters (which you can use as macro variables in the "inner" job).</P> <P>&nbsp;</P> Tue, 31 Mar 2020 11:54:22 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-Data-Integration-Studio-parametrizing-job-using-a-csv-file/m-p/636186#M19052 LinusH 2020-03-31T11:54:22Z