Issues importing in EG 4.3

[Lee_1]

I just installed SAS EG 4.3 (working with my company to get a newer version).  When I go to import excel I can't get past Step 1 in the wizard.  See attachment, I don't have an option to go to Step 2.  Could it be a server issue?

[Reeza]

 it's trying to run locally, but it may depend on your setup. 

Try a basic proc import code? 

 EG 4.3 may not be able to deal with XLSX files depending on the SAS version behind the scenes. 

[Lee_1]

Thanks for the reply, I tried it as xls and the same problem. When I try to open the “Local” under the Servers menu I get a connection error.  Can you help me with the setup?

[Kurt_Bremser]

Then try to start SAS in Display Manager mode.

In Windows, go to Start - All Programs - SAS - SAS 9.4 and start that. See if it starts up OK or has problems.

[Lee_1]

Thank you, this must be my problem.  I get the message attached when I try to login...I have contacted our company IT folk to hopefully resolve the issue.

[Kurt_Bremser · Accepted solution]

So you have a SAS installation but somehow the license was not updated.

Actually, once you get a simple setinit.sas file with the license procedure (proc setinit) included, you can run

\path_to_sas\sas.exe -setinit -sysin \path_to_sas_file\setinit.sas

from the cmd window, and everything should be fine.

[Reeza]

2000?  Something seems off there...is this a new SAS installation?

[Kurt_Bremser]

---

@Reeza wrote:

2000?  Something seems off there...is this a new SAS installation?

---

That also occured to me. Maybe there are remnants of an old and never used SAS install that tricks EG into assuming there's a working local SAS, while in fact EG is a part of a pure client/server setup.

If client/server is the case, then the import needs to be reworked.

[Lee_1]

Thanks everyone, I contacted IT and received a new licence key.  This has solved my problem.

[ChrisHemedinger]

SETINIT is definitely the problem here, and unfortunately SAS EG can't provide a good error message when the license has already expired -- because it can't connect to SAS to find out the issue!

For other people trying to get EG to work with a Local SAS, check out these explanations and steps.