topic Re: ERROR: Not enough memory available to allocate storage. in SAS Procedures

ERROR: Not enough memory available to allocate storage.

Lei576 — Thu, 24 Sep 2015 16:21:32 GMT

Hello everyone,

I am trying to import a sheet from an excel file. However, it gave me this error message.

Here is what I did:

------------------------------------------

libname SAStry cvp "/folders/myfolders/Jobs";
proc import datafile='/folders/myfolders/Jobs/AE.xls'
out=SAStry.allsae dbms=xls;
sheet="sae";
run;

------------------------------------------

Log file:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 libname SAStry cvp "/folders/myfolders/Jobs";

NOTE: Libref SASTRY was successfully assigned as follows:

Engine: CVP

Physical Name: /folders/myfolders/Jobs

57 proc import datafile='/folders/myfolders/Jobs/AE.xls'

58 out=SAStry.allsae dbms=xls;

59 sheet="sae";

60 run;

Memory request error

ERROR: Not enough memory available to allocate storage.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.25 seconds

cpu time 0.27 seconds

62 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

--------------------------------------------------------

I used CVP engine to avoid the data truncated since this excel file contains information in different languages.

I tried google this error message or tried to increase memory in the vmware player setting. So far nothing worked.

Could anyone please give me some help/hints? Thank you:)

Lei

Re: ERROR: Not enough memory available to allocate storage.

PaigeMiller — Thu, 24 Sep 2015 16:40:31 GMT

Basically, your computer does not have enough memory to perform this task.

You can try rebooting your computer and making sure that the only application running is SAS.

But the long term fix is most likely that you need more memory in your computer AND a 64-bit operating system.

Re: ERROR: Not enough memory available to allocate storage.

hbi — Thu, 24 Sep 2015 17:04:45 GMT

Do you use Enterprise Guide or Regular SAS?

This article ( http://support.sas.com/kb/31/715.html ), though slightly dated, states that in the absence of a hotfix, "DBMS=EXCEL" should be used instead of "DBMS=XLS".

Also, are you using "OPTIONS COMPRESS=YES;"? This option is absolutely critical when you have a significant number of character variables that vary in length.

Permutations of DBMS options (EXCEL/XLS/XLSX) and file formats (.xls, .xlsx, .xml) might be worth a shot (or you can come up with your own):

try DBMS=EXCEL with your existing ".xls" file
try DBMS=XLSX with your existing ".xls" file
within Excel, save the file as ".xlsx" and try DBMS=XLSX
within Excel, save the file as Excel ".xml" and try DBMS=XLSX
within Excel, save the file as Excel ".xml" and try DBMS=XLS

Some of the above pairs may not make sense, so my suggestions should be taken with a grain of salt.

-- hbi

Re: ERROR: Not enough memory available to allocate storage.

Lei576 — Thu, 24 Sep 2015 17:08:49 GMT

Thank you for the quick reply, PaigeMiller.

I will try the reboot and see how it will turn out. My OS is windows 10 X 64 bits by the way.

Re: ERROR: Not enough memory available to allocate storage.

Lei576 — Thu, 24 Sep 2015 17:20:00 GMT

Hello Hbi,

Thank you for replying my post.

I am using SAS university Edition and my OS is windows 10x64bits.

And i did try DBMS=excel and it gave me "Error: DBMS type excel not valid for import".

-Lei

Re: ERROR: Not enough memory available to allocate storage.

SASKiwi — Fri, 25 Sep 2015 00:35:17 GMT

Try adding this statement to your code to find out how much memory SAS is using:

options fullstimer;

Re: ERROR: Not enough memory available to allocate storage.

ChrisNZ — Mon, 28 Sep 2015 10:42:36 GMT

And post the result of

proc options group=memory;run;

and of

%put Free RAM = %sysfunc(putn(%sysfunc(getoption(xmrlmem))/1024**2,comma10.))MB;