BookmarkSubscribeRSS Feed
hhchenfx
Barite | Level 11

Hello Everyone,

 

I have SAS at home and SAS in my office (university).

 

For the same procedure, My home PC use 30 Gig Ram while The office PC just FLAT at 7.8 Gig!

It takes way to long time to complete the process.

 

Is there any way I can fix this problem?

I try to copy the config file from home PC to office PC but still doesn't work.      

Might be I miss something.

 

Any help please?

 

HHCFX

28 REPLIES 28
Reeza
Super User

How much physical RAM does your work PC have?

 


@hhchenfx wrote:

Hello Everyone,

 

I have SAS at home and SAS in my office (university).

 

For the same procedure, My home PC use 30 Gig Ram while The office PC just FLAT at 7.8 Gig!

It takes way to long time to complete the process.

 

Is there any way I can fix this problem?

I try to copy the config file from home PC to office PC but still doesn't work.      

Might be I miss something.

 

Any help please?

 

HHCFX


 

hhchenfx
Barite | Level 11

Both of my PC have the same config. 

SSD with 70GB free storage

32 G Ram

i7 4770

 

 

Satish_Parida
Lapis Lazuli | Level 10
Can you check your CPU utilization and Memory usage during process run and post it.
Heavy loads take time.
Reeza
Super User

Are they both running directly off the C drive, or is your work computer reading/writing from data on a network drive?

 

Is memsize the same on both machines.

 

You'll probably get faster answers from Tech Support.

hhchenfx
Barite | Level 11

This is the screen short for 2 PC running the same procedure.

 

 

ChrisNZ
Tourmaline | Level 20

Microsoft-format documents are best avoided as they are unsafe.

There is no reason whatsoever they should be used to share images.

hhchenfx
Barite | Level 11

I cant upload the screen short directly here.

SAS communities should allow us to share picture file.

 

Reeza
Super User

You can, you embed it using photos. 

 

Screenshot A:

Screen Shot 2018-02-27 at 6.47.48 PM.png

 

hhchenfx
Barite | Level 11

Thank you,

 

Below is the screen short for the 2 PC.

ram.png

Reeza
Super User

Just to confirm again (no answer), both were running directly off the C drive/work space, not a directory, correct? I can see that you definitely have a libname assigned in one, but not the other. 

 

Assuming exact same hardware, settings (memsize), and config files, directory access, I would then start looking at what else is happening at the same time on your machines.  Maybe something else is doing something to affect your processes or at least show the memory jump, ie does one have a security scan that has to happen or something along those lines. 

 

Are those graphs for your overall computer or the SAS process alone?

 

 

hhchenfx
Barite | Level 11
Both get file copy to C drive and copy to Work Lib. Both Run the same thing and nothing else running. Today, I copy the SAS Config file from home to office and nothing improve.
I heard that University SAS has limit on Ram usage (?) not sure it is the reason or not.
hhchenfx
Barite | Level 11

I try this one:


/* File I/O */

-BUFNO 200
-BUFSIZE 64K
-UBUFSIZE 64K
-UBUFNO 20
-IBUFNO 64
-IBUFSIZE MAX
-CBUFNO MAX
-tbufsize 512k
-catcache max

 

AND TRY THAT ORIGINAL (same original setting) below

-WORK "!TEMP\SAS Temporary Files"
-MEMSIZE 2G
-SORTSIZE 256M

 

Basically the same thing happen.

Reeza
Super User

You're using SAS UE? There is no RAM limit, there's a limit on the number of cores you can have though.

 

How did you even change the config file on SAS UE, I didn't think you could. What do your VM settings show for each? Can you include screenshots of that? 

 

It looks like you have a few steps in your code, so I guess I would also ask, which step is taking longer, because it's likely not all. The type of task will help pinpoint where the differences are.  My laptop for example has an SSD whereas my desktop has a FusionDrive which is about half the speed. 

 

 

 

 

hhchenfx
Barite | Level 11

So the code is for stress test purpose.

 

Data combine_file; set big big big big; run;

 

proc sort data=combine_file by decending .....; run;

 

On the screen short, you can see that the Data step take 31/19 second for home and 1:31/24.80 for Office.

Sort: home 36 second/32 second office:41/34

First number if Real time, second number is Cpu time.

 

Most difference come from Data step. So weird that Cpu time for office only 24 but then realtime turn to be 1:31.

 

SAS UE is University edition? if so the answer is Yes.

VM settings is Virtual machine or what? My sas are on real machine.

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 28 replies
  • 1184 views
  • 2 likes
  • 4 in conversation