BookmarkSubscribeRSS Feed
OnkarS
Calcite | Level 5

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

5 REPLIES 5
Kurt_Bremser
Super User

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)?

OnkarS
Calcite | Level 5
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
Kurt_Bremser
Super User

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?

OnkarS
Calcite | Level 5
Hi I attached the photo.
Kurt_Bremser
Super User

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.

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1865 views
  • 0 likes
  • 2 in conversation