03-30-2015 01:17 AM
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.
How to proceed now, Is there any other work around to import
03-30-2015 02:11 AM
Export to csv and then read that with a data step. Avoid proc import.
03-30-2015 05:24 AM
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
03-30-2015 06:20 AM
Please show code and log of your data step.