topic Re: Enable parallel processing on sas 9.3 portable in Administration and Deployment

Enable parallel processing on sas 9.3 portable

piyushdwij — Mon, 19 Oct 2015 15:07:27 GMT

Hi , i am using sas 9.3 portable version on windows 7 32 bit intel i5 processor ( 4 cores ) , i need to enable parallel processing to harness rest of the core , its using only one.

Re: Enable parallel processing on sas 9.3 portable

LinusH — Mon, 19 Oct 2015 16:05:06 GMT

"Portable" is not a SAS edition that I know of, so I just asume you are working with Base/Foundation.

Submit:

proc options group=performance;

run;

Check the options threads and cpucount. In your case, it should default to THREADS and CPUCOUNT=4.

Not all SAS processing uses threads. Sorting, aggregation by SQL and some procs uses threads.

Re: Enable parallel processing on sas 9.3 portable

piyushdwij — Mon, 19 Oct 2015 16:33:05 GMT

ok ,i just ran that code and yes it has threads and cpu count 4 , but that does not help me as when i am working with a dataset that has 400,000+ records the proc SQL taking more than 2 hours to complete and during that time resource manager shows only one CPU in full use rest 3 are idle. ho can i speed up things from here ?

Re: Enable parallel processing on sas 9.3 portable

piyushdwij — Mon, 19 Oct 2015 18:28:00 GMT

found out how to specify threads option in proc SQL .

Re: Enable parallel processing on sas 9.3 portable

LinusH — Tue, 20 Oct 2015 20:28:13 GMT

Can't see that would make any difference in your case, or did it?
Share your SQL, if it doesn't contain much sorting/aggregation it will be single threaded a part of its process time.
If you are running on a laptop chances are that you have i/o or memory constraints. Submit:

Options fullstimer msglevel =i;

To get more information in the log on what's going on.

Re: Enable parallel processing on sas 9.3 portable

piyushdwij — Thu, 22 Oct 2015 13:22:56 GMT

yes , it did not make any difference. 😞

Re: Enable parallel processing on sas 9.3 portable

SimonWilliams — Wed, 28 Oct 2015 11:02:53 GMT

Hi piyushdwij,

As LinusH already mentioned you may have an I/O bottleneck. Does laptop have seperate drives or paritions to manage your permanent and temporary SAS datasets? Having seperate disks for permanent and temporary datasets can help speed up the processing.

In addition if you are accessing an MS SQL Server (presumably not on the same machine that you have SAS on) and you are submitting SQL code, why not submit explicit MS SQL server code and have SQL server do the processing for you?

Without seing your code i don't think there is much more that i can add.

One final thought. This sounds more like a data management question so you may want to post this to: https://communities.sas.com/t5/Data-Management/ct-p/data_management

Cheers, Simon