topic Re: out of memory error in New SAS User

out of memory error

OnkarS — Thu, 28 Mar 2019 06:50:39 GMT

Hi,

I am using SAS EG 7.1 and I was trying to import the data (data file is quite huge). The system shows System out of memory exception error. How to solve this issue.

Thanks

Re: out of memory error

Kurt_Bremser — Thu, 28 Mar 2019 06:53:25 GMT

What kind of file are you importing?

Do you use code you write, or are you relying on the import wizard of EG?

Does the error message come from EG (please provide screenshot) or from the SAS log of the task node (post the log useing the {i} button)?

Re: out of memory error

OnkarS — Thu, 28 Mar 2019 07:16:26 GMT

I am using CSV file (FIle size 3.8 gb)
Yes I am relying on import wizard of EG.

[image: SAS_EG_error.png]

Thank you

Re: out of memory error

Kurt_Bremser — Thu, 28 Mar 2019 07:22:23 GMT

Then I would suggest the following:

use the Copy Files task to move the file to the server
write a data step to read the file into a dataset; you can use proc import first to get a prototype data step on which you can improve

PS your image link was not inserted correctly. Did you use the "Photos" button?

Re: out of memory error

OnkarS — Thu, 28 Mar 2019 07:27:26 GMT

Hi I attached the photo.

Re: out of memory error

Kurt_Bremser — Thu, 28 Mar 2019 07:45:46 GMT

I only see this in your previous post:

[image: SAS_EG_error.png]

which does not work.

Anyway, try an upload with the Copy Files task.