SAS EG Setup for Dummies

[didagreen]

Quick background, use to work in a large corporation had SAS EG, it was presented to me all ready to go. I had a SAS server, I had logins to Teradata, Oracle, all I had to do was write Proc SQL's and generate my results. I only understand SQL, that is my extent. 

Fast forward, I am at a smaller place,  zero SAS users.  Begged IT folks to get me SAS EG, and they got it for me!!

Not sure where to go from here. How do I get to a place, where I can query Oracle, have excel lookup files, generate results.  

There is no server, no login to Oracle, or Filezilla connection to refer to lookup files or receive outputs. 

I have a SAS Depot 9.4, I have the key. it is Installed, but I suspect something could be off since SAS SYSTEM VERSION  - NONE, in Configuration Details. 

Please help me get to a place where I am able to be productive. 

Any suggestions will be appreciated. 

Regards...

[Reeza · Accepted solution]

When you install it from the depot, make sure to read through each option and ensure you select the ODBC and SAS/Access connection so you can connect to data bases and ensure EG and STudio are both installed as well. They're included but not always installed.

Second, you first need to set up a connection to your oracle db via your odbc dsn. Your IT team should be able to help you there. Once you have that set up you can set a libname setting that will connect you directly to Oracle.

[ballardw]

Have you actually gone through the Install process? If you attempted the install and had errors then contact SAS tech support.

If so can you start an EG session? If an EG session won't start it is time to contact SAS tech support.

If EG will start then it is time to get into the configuration.

First would be to run this small program:

Proc setinit;
run;

Proc product_status;
run;

The Setinit will show in the LOG what SAS modules are licensed. If you don't have the SAS/Access Interface to Oracle you may want that added to have best connection to Oracle.

Similar SAS/Access Interface to PC Files for Excel and such.

If they are in the license information then the Product_Staus output will tell you if they were properly installed.

Share the results and you are likely to get hints on how a stand alone user (you) connects to the Oracle.

Read or right to Excel files should be available with LIBNAME EXCEL.

[SASKiwi]

What did you choose to install? Remember EG is just the client interface. You also need to do a complete Foundation SAS install based on the products included in your licence. If you don't have SAS 9.4 appearing in the SAS folder of your Windows Programs List then it is not installed.

[didagreen]

Wow, so many helpful suggestions!! 

I uninstalled what I had, and installed again. 

I made sure I select 

ODBC and SAS/Access connection & Foundation SAS install . 

That made a difference, and I could successfully run the code - 

Proc setinit;
run;

Proc product_status;
run;

I have a local SAS profile. 

I was able to connect to Oracle and run a query. 

This is great, this is wonderful... 

I have many more things to figure out, but at least I am able to move forward. 

Thank you community for helping me. 

Kind regards and much appreciation...

[SASKiwi]

Please mark your question as answered in that case.