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
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.
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 ?
.
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).
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.