ERROR: Open cursor: System resource exceeded. while importing how to porceed?

Reply
Contributor
Posts: 20

ERROR: Open cursor: System resource exceeded. while importing how to porceed?

Hello All,

I am trying to import a xlsx format MS excel data into sas which is around 600 MB and 500,000+ rows with lot of formulas and arrays linked. If I try to import weather through import wizrad or through Proc import I am getting this error:

Error : Open cursor: System resource exceeded.

Error : Import unsuccessful.

30-03-2015 10-40-17.png

How to proceed now, Is there any other work around to import

Thanks

Pra

Esteemed Advisor
Posts: 6,646

Re: ERROR: Open cursor: System resource exceeded. while importing how to porceed?

Export to csv and then read that with a data step. Avoid proc import.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 20

Re: ERROR: Open cursor: System resource exceeded. while importing how to porceed?

If I try to import after convertinf to csv, it is still showing Import unsuccessful, However still the dat is getting imported But with some errors on headers, Additonally I am not able to perfrom Proc sort step

Thanks

Pra

Esteemed Advisor
Posts: 6,646

Re: ERROR: Open cursor: System resource exceeded. while importing how to porceed?

Please show code and log of your data step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 555 views
  • 0 likes
  • 2 in conversation