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?
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.
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.
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?
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.
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.
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.
2000? Something seems off there...is this a new SAS installation?
@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.
Thanks everyone, I contacted IT and received a new licence key. This has solved my problem.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.