SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Frequent Contributor
Posts: 76

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

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


SAS Import Problem.jpg
Super User
Posts: 5,431

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

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

Data never sleeps
Super User
Posts: 11,343

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

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?

Super User
Posts: 19,822

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

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

N/A
Posts: 1

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

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.

Ask a Question
Discussion stats
  • 4 replies
  • 427 views
  • 0 likes
  • 5 in conversation