BookmarkSubscribeRSS Feed
sugita
Calcite | Level 5

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?


Pic2.jpgpic1.jpg
3 REPLIES 3
shivas
Pyrite | Level 9

Hi,

Check this SAS Note..

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

Thanks,

Shiva

sugita
Calcite | Level 5

i tried what that webpage suggest

but i get error like in the attached pictureUntitled.jpg

sugita
Calcite | Level 5

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2166 views
  • 0 likes
  • 2 in conversation