Problem with import excel file

sugita — Tue, 22 May 2012 04:32:49 GMT

Hi everyone,

I have an excel file that i want to import using my sas enterprise guide 4.2 32 bit windows 7 enterprise and everytime i want to import it, i always get this error

SAS Enterprise Guide has encountered a problem. We recommend that you save your work and restart SAS Enterprise Guide.

--------------------------------------------------------

System.Exception

An undefined DataTypeEnum value was encountered.

------------------------------ Technical Information Follows ------------------------------

System.Exception: An undefined DataTypeEnum value was encountered.

at SAS.Tasks.ImportData.DefineFields.BeforeDisplay()

at SAS.SharedUI.Wizard2.set_ActivePageIndex(Int32 value)

at SAS.SharedUI.Wizard2.OnNext()

at SAS.Tasks.ImportData.ImportDataView.OnNext()

at SAS.SharedUI.Wizard2.m_NextBtn_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at SAS.SharedUI.Controls.OpenButton.OnMouseUp(MouseEventArgs mea)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at SAS.SharedUI.Controls.OpenButton.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

------------------------------ End of Technical Information ------------------------------

I think its because in my excel file - coloumn Z contain a very large number that is beyond sas int data type range.

I already tried to change the format of that column cell into text but no luck. can anyone help?

Re: Problem with import excel file

shivas — Tue, 22 May 2012 04:40:43 GMT

Hi,

Check this SAS Note..

http://support.sas.com/kb/36/798.html

Thanks,

Shiva

Re: Problem with import excel file

sugita — Tue, 22 May 2012 05:12:25 GMT

i tried what that webpage suggest

but i get error like in the attached picture

Re: Problem with import excel file

sugita — Tue, 22 May 2012 05:21:47 GMT

Hi,

Sorry, I turned off my UAC and restart and then the register went successful. But after i open Enterprise Guide, and tried to import the excel file again, i still get the same error message so we back to square 1 again.

topic Re: Problem with import excel file in SAS Enterprise Guide

Problem with import excel file

Re: Problem with import excel file

Re: Problem with import excel file

Re: Problem with import excel file