Dear Team,
I have created a Data job having 30 nodes and it's taking 16 hours to complete. I want to run the job in Parallel. How to do that ?
I have attached one data job which is conatins 30 nodes.
I have created New process job and then what will I do ?
Thanks and regrads,
Shakti
The way I run SAS DQ jobs in parallel is to split the DQ job into separate jobs, one for each parallel stream. Then I run the DQ jobs from a SAS program which uses SAS/CONNECT to run the jobs in separate SAS sessions. If you don't have SAS/CONNECT you could always just run separate SAS programs as batch jobs at the same time. The job originally took over 12 hours and now runs in less than 4 hours.
I've never tried it the way you are doing it. I call a DQ job from a SAS program like this:
data _null_;
rc = dmsrvauthdom("DMServerAuth");
JobName = 'My DQ Job Name.ddf';
jobid = dmsrvBatchJob (JobName, 'http://MyDQAppServer.com', 21036);
jobstatus = dmsrvJobStatus(jobid, 'http://MyDQAppServer.com', 21036, -1, 5);
put _all_;
run;
If you are not familiar with this way and you don't know how to code SAS programs then I suggest that you continue with your way and open a Tech Support track to get help.
After a bit of research I think you need to use the Fork node. The Parallel Iterator is for when you want to loop multiple times in parallel.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.