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.

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1619 views
  • 0 likes
  • 2 in conversation