Desktop productivity for business analysts and programmers

Problem with import excel file

Occasional Contributor
Posts: 15

Problem with import excel file

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.



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?

Super Contributor
Posts: 350

Re: Problem with import excel file


Check this SAS Note..



Occasional Contributor
Posts: 15

Re: Problem with import excel file

i tried what that webpage suggest

but i get error like in the attached pictureUntitled.jpg

Occasional Contributor
Posts: 15

Re: Problem with import excel file


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.

Ask a Question
Discussion stats
  • 3 replies
  • 2 in conversation