SAS shuts down while import (either by code or by wizard) excel / access files..

[aj34321]

I got SAS recently installed and it was give me some startup problem initially. There was some problem with editor fonts which i guess did not get registered somehow and the program editor window was not opening.

I reinstalled SAS and program window appears but now I'm facing a strange problem. It shuts down when any excel / access file is imported either by code or by import wizard.

It doesn't shows any exception details. How can i fix this problem.

Rgds, Anil

[LinusH]

First, contact your local SAS representative, If he/she can't help you, I suggest you open track to SAS tech support.

[ballardw]

Can you post an example of the code used that caused the problem?

Also, this could be operating system related so which OS are you running?

[Reeza]

How big are the files you're trying to import?

[ns999]

I had a problem with SAS shutting down during a proc import of a CSV as well. The CSV contained a messy text field that I suspect used some "problem characters." See this: 41067 - Using the XML92 engine might generate an error or shut down the SAS® System when the data co...

I cleaned up the messy text field in the CSV a bit, and was able to import successfully.