topic EG 4.3 not able to import excel in SAS Enterprise Guide

EG 4.3 not able to import excel

TomAdams — Wed, 01 Apr 2015 19:14:36 GMT

I'm a sas newbie. I have two customers that cannot import Excel files in enterprise guide 4.3. Has anyone experienced this

Re: EG 4.3 not able to import excel

TomKari — Wed, 01 Apr 2015 19:28:04 GMT

Please provide a little more information...how are you trying to do the import, and what diagnostics are you receiving?

Re: EG 4.3 not able to import excel

TomAdams — Wed, 01 Apr 2015 19:34:42 GMT

we have just used file -> import and pointed to the dataset on a shared drive. We get no diagnostics, the wheel just spins. One user says that at one time he got a java message but he doesn't remember it.

Eventually the import window 2 opens, but the next button is greyed out. I have installed about twenty users since the install two months ago with no problems until today

Re: EG 4.3 not able to import excel

SASKiwi — Wed, 01 Apr 2015 20:15:18 GMT

So the question is if it worked for these users yesterday, why does it not work today? What has changed?

I suggest you check the version of Java installed on the PCs where importing does not work versus those where it does. Do they have different versions and could the new version just have been added?

If the versions are different, reinstall the Java version that works and test if import now works.