DATA Step, Macro, Functions and more

PC Ram usage cap at 7.8 Gig

Reply
Super Contributor
Posts: 503

PC Ram usage cap at 7.8 Gig

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

Super User
Posts: 23,237

Re: PC Ram usage cap at 7.8 Gig

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


 

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

Both of my PC have the same config. 

SSD with 70GB free storage

32 G Ram

i7 4770

 

 

Frequent Contributor
Posts: 109

Re: PC Ram usage cap at 7.8 Gig

Can you check your CPU utilization and Memory usage during process run and post it.
Heavy loads take time.
Super User
Posts: 23,237

Re: PC Ram usage cap at 7.8 Gig

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.

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

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

 

 

PROC Star
Posts: 2,311

Re: PC Ram usage cap at 7.8 Gig

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

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

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

I cant upload the screen short directly here.

SAS communities should allow us to share picture file.

 

Super User
Posts: 23,237

Re: PC Ram usage cap at 7.8 Gig

You can, you embed it using photos. 

 

Screenshot A:

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

 

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

Thank you,

 

Below is the screen short for the 2 PC.

ram.png

Super User
Posts: 23,237

Re: PC Ram usage cap at 7.8 Gig

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?

 

 

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

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.
Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

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.

Super User
Posts: 23,237

Re: PC Ram usage cap at 7.8 Gig

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. 

 

 

 

 

Super Contributor
Posts: 503

Re: PC Ram usage cap at 7.8 Gig

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.

 

Ask a Question
Discussion stats
  • 28 replies
  • 234 views
  • 2 likes
  • 4 in conversation