Does anyone know how to get SAS to use more than one of my four CPUs (a
quad-core processor) in running a proc sql program?
I looked it up and found, first how to check to see if SAS recognizes all of
PROC OPTIONS group=performance;
so, I know that it recognizes 4 CPUs.
Then, I used the command:
OPTIONS THREADS CPUCOUNT=4;
And then in my proc sql program I uncluded the THREADS option:
proc sql THREADS;
However, SAS continues to only use 25% of the CPUs and the program takes
over 50 hours to run (despite having 3.5 GB RAM and a 2.40 GHz processor.