topic Re: SAS DI Studio jobs in SAS Data Management

SAS DI Studio jobs

MG18 — Wed, 02 Jan 2019 16:24:44 GMT

Hello,

I have a question -

I have SAS DI Job which is calling user written code in it. What all different way to run the SAS DI job?

Please provide views.

Regards,

Mike

Re: SAS DI Studio jobs

r_behata — Wed, 02 Jan 2019 17:07:19 GMT

You should treat the SAS DI Job with a User Written transformation just the way you run any other DI job.

The User written transformation are usually created whenever there is no out of the box Transformation for a given task available in SAS DI . A custom task may be created in place if the task is redundant.

However, Whether you use an existing transformation , custom transformation or a user written transformation it is the SAS Code which is runs behind the scenes.

Re: SAS DI Studio jobs

MG18 — Thu, 03 Jan 2019 08:33:46 GMT

I understand ur point but I am asking What all different way to run the SAS DI job? l

ike running the DI job using DI studio and running the DI using Batchserver ?

Re: SAS DI Studio jobs

Kurt_Bremser — Thu, 03 Jan 2019 12:30:53 GMT

You can run it interactively from DI Studio, schedule it with SAS (BatchServer), or save the code to a .sas file and run it with an external scheduler (if you need to integrate with an existing scheduling system that your organization provides).

Re: SAS DI Studio jobs

LinusH — Thu, 03 Jan 2019 15:23:21 GMT

I think your point about use written confused the readers of your post.

As @Kurt_Bremser describes, the two major options are interactively, and calling them via the SASBatchServer set-up.

Using DI Studio interactively usually is fine during development and unit testing, and some rare cases when data arrive and need to be loaded manually (given that the responsibility lies within IT).

Otherwise, try to use batch for production jobs.

There is a third possibility, and that is deploy the job as Stored Process. This can come in handy in the case of manual delivery and load data, where admins and data stewards, even power user can trigger loads from a web page.