topic Re: I have a question to ask on SAS Data Integration 3.4 in SAS Procedures

I have a question to ask on SAS Data Integration 3.4

deleted_user — Wed, 19 Aug 2009 08:38:20 GMT

Hi,

In SAS Data Integration Studio 3.4, Can I accept a value from outside?

THe scenario is like this i have a dataset which can be filter by year.

Can I prompt a user to enter the year so that he can read records for that year.?

Is it able to write to a file then from SAS Data Integration Studio 3.4, we read from the file then into the job?

Can it be done?

If so, how can it be done?

Thanks.

Yours Sincerely,
helphelp

Re: I have a question to ask on SAS Data Integration 3.4

GertNissen — Wed, 19 Aug 2009 11:11:56 GMT

I would not run my jobs in DI Studio - I would only use DI Studio to develop jobs.

Deploy your jobs and run them with the generated batch file or from your favorite job scheduling tool.

In DI Studio you can define the parameter for each job and/or you can use the prolog feauture to set macro variables (i.e. read from a SAS table) to define your year. This way you seperate your code and the parameter, and then you don't need to re-deploy your jobs when reading a new year.

Re: I have a question to ask on SAS Data Integration 3.4

deleted_user — Thu, 20 Aug 2009 01:24:43 GMT

Hi,

How is it actually done?

do u have guide on that?

Thanks.

Yours Sincerely,
helphelp