topic ERROR Import Data from a Text File in SAS Enterprise Guide

ERROR Import Data from a Text File

Murilo — Thu, 28 Mar 2013 11:02:38 GMT

Hi Dear,

I'm beginning to learn SAS EG

I'm trying to import data from a Text File .txt

on Step" file -> Import Data"

But, I am receiving the error
""
Does anyone know what this error might be?

Thanks so much!

Murilo Almeida

Re: ERROR Import Data from a Text File

ChrisHemedinger — Thu, 28 Mar 2013 12:17:35 GMT

What version of EG is this? 4.1?

It looks like something is wrong with the EG installation. I suggest tracking this with SAS Technical Support.

Chris

Re: ERROR Import Data from a Text File

Murilo — Thu, 28 Mar 2013 12:44:05 GMT

Hi Chris.

Version of EG is 5.1.

Thanks so much!

Re: ERROR Import Data from a Text File

ChrisHemedinger — Thu, 28 Mar 2013 12:53:07 GMT

Yes, you should definitely track with Tech Support. Something is amiss in your installation.

Re: ERROR Import Data from a Text File

sas4ml — Fri, 29 Mar 2013 21:59:27 GMT

Hi, I had responded to a similar issue . It could be a compatibility issue meaning if SAS is 64 bit( can check in HELP) and the Office that you are running is 32 bit. I know in such a situation you normally receive "Class not registered" or Excel engine not found" messages.

Try checking the Excel version and if different from SAS version try Installing 64 bit Office 2010 to match your version of SAS .

Try the following links in the order given

http://www.office.com/office64setup

The following links involve more steps using PC Server Files with Import Wizard

http://support.sas.com/kb/44197

Iinstalling a SAS PC File server which provides a bridge between 32 bit Office and 64 bit SAS.

http://support.sas.com/kb/43802

Thanks,