topic Re: Issues importing in EG 4.3 in SAS Enterprise Guide

Issues importing in EG 4.3

Lee_1 — Tue, 11 Oct 2016 13:48:16 GMT

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?

Re: Issues importing in EG 4.3

Reeza — Tue, 11 Oct 2016 14:09:44 GMT

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.

Re: Issues importing in EG 4.3

Lee_1 — Tue, 11 Oct 2016 14:58:06 GMT

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?

Re: Issues importing in EG 4.3

Kurt_Bremser — Tue, 11 Oct 2016 15:50:11 GMT

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.

Re: Issues importing in EG 4.3

Lee_1 — Tue, 11 Oct 2016 16:01:01 GMT

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.

Re: Issues importing in EG 4.3

Kurt_Bremser — Tue, 11 Oct 2016 16:22:52 GMT

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.

Re: Issues importing in EG 4.3

Reeza — Tue, 11 Oct 2016 19:32:48 GMT

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

Re: Issues importing in EG 4.3

ChrisHemedinger — Tue, 11 Oct 2016 22:11:43 GMT

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.

Re: Issues importing in EG 4.3

Kurt_Bremser — Wed, 12 Oct 2016 06:36:16 GMT

@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.

Re: Issues importing in EG 4.3

Lee_1 — Wed, 12 Oct 2016 12:49:17 GMT

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