Desktop productivity for business analysts and programmers

Issues importing in EG 4.3

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Issues importing in EG 4.3

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?

 

 

Attachment

Accepted Solutions
Solution
‎10-12-2016 08:49 AM
Esteemed Advisor
Posts: 6,646

Re: Issues importing in EG 4.3

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Grand Advisor
Posts: 17,325

Re: Issues importing in EG 4.3

 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. 

New Contributor
Posts: 4

Re: Issues importing in EG 4.3

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?

Esteemed Advisor
Posts: 6,646

Re: Issues importing in EG 4.3

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Issues importing in EG 4.3

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.

Attachment
Solution
‎10-12-2016 08:49 AM
Esteemed Advisor
Posts: 6,646

Re: Issues importing in EG 4.3

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Grand Advisor
Posts: 17,325

Re: Issues importing in EG 4.3

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

Esteemed Advisor
Posts: 6,646

Re: Issues importing in EG 4.3


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Issues importing in EG 4.3

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

Community Manager
Posts: 2,692

Re: Issues importing in EG 4.3

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 9 replies
  • 426 views
  • 0 likes
  • 4 in conversation