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

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

aj34321 — Tue, 17 Sep 2013 08:31:15 GMT

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

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

LinusH — Tue, 17 Sep 2013 09:26:00 GMT

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

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

ballardw — Tue, 17 Sep 2013 16:57:29 GMT

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?

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

Reeza — Tue, 17 Sep 2013 17:06:08 GMT

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

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

ns999 — Fri, 20 Feb 2015 18:03:20 GMT

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 contains specific characters

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