folks, I am using sas / connect in asynchronous mode, creating several hundred jobs with a loop. My challenge is that sas is not limiting the number of jobs it process simultaneously. It starts all jobs the CPU can take, engaging all available cores and saturating the hard drive (each job needs to create a copy of a dataset). I would like to be able to specify the maximum number of processes that are executed at any point in time, but SAS is ignoring the cpucount option. I am using SAS is 9.4, SAS/STAT 15.2 on a 12-core/Windows 10 desktop and the relevant code is as follows:   options threads cpucount=4; %let rc=%sysfunc(grdsvc_enable(_all_, resource=SASApp)); options autosignon; %macro mymacro; /* loop over zip3's */ %do i=1 %to %sysfunc(countw(&zip3list)) ; %let thisZip30=%scan(&zip3list,&i); %let taskname = t&thisZip30; %SYSLPUT year=&year./REMOTE=&taskname; %SYSLPUT thisZip3=&thisZip30./REMOTE=&taskname; rsubmit &taskname wait=no connectpersist=no inheritlib=(ineq4 onlinek); %nrstr(%%)PUT ******* zip3=&thisZip3 **************; /* extract data for zip3 and upc */ data thiZip3train&thisZip3; set ineq4.promediosWeeRetTrain&year; where store_zip3="&thisZip3"; run; /* do stuff with the extracted data */ PROC DATASETS lib=work; delete thiZip3train&thisZip3; quit; RUN; endrsubmit; %end; waitfor _all_; signoff _all_ ; %mend mymacro; %mymacro; ... View more

I have a large dataset that combines multiple rows for each of multiple units (zip codes). I need to build one regression trees for each unit and use them to impute missing values in the DV. I understand that hpsplit does not implement "by" processing, so I thought of using a macro to split, build tree, score missing values, and append to an output data set.    This is how I found this question Splitting the dataset using macros and the recommendation not to use macros. Can anyone suggest a better approach?   The version of SAS is 9.4, SAS/STAT 15.2   Thanks in advance. ... View more