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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.