Architecting, installing and maintaining your SAS environment

increase the value for MAXMEMQUERY

Reply
Occasional Contributor
Posts: 9

increase the value for MAXMEMQUERY

Hi All,

 

One of our SAS user trying to run the proc varcomp and they getting below error message in SAS log:

 

ERROR: Unable to allocate sufficient memory. At least 2097152K bytes were requested, but only
2097150K were available. You must either increase the amount of memory available, or approach
the problem differently.

 

I have added -MAXMEMQUERY MAX on SAS config file (sasv9.cfg), still giving the same error how can I fix this problem? Please, anyone, help me out on this.

 

 

Super User
Posts: 3,260

Re: increase the value for MAXMEMQUERY

MEMSIZE is the option to adjust here. 2G for MEMSIZE is a bit low these days. Try -MEMSIZE 3G. There is no guarantee this will fix the error. With statistical procedures like VARCOMP, simplifying the analysis is often required.

Occasional Contributor
Posts: 9

Re: increase the value for MAXMEMQUERY

Thanks for the response. I have tried -MEMSIZE 3G and -MEMSIZE MAX, it doesn't work.
Super User
Posts: 3,260

Re: increase the value for MAXMEMQUERY

What does "it doesn't work" mean? Does it actually change the MEMSIZE setting - you can confirm this by using PROC OPTIONS. Or does it successfully change the setting but VARCOMP still fails?

Ask a Question
Discussion stats
  • 3 replies
  • 212 views
  • 3 likes
  • 2 in conversation