topic Re: How to run a program in EG5.1 without connecting to a server in SAS Enterprise Guide

How to run a program in EG5.1 without connecting to a server

JayG — Fri, 26 Jul 2013 19:09:06 GMT

I have entered a sample program in EG program editor and select the test and run. I got a message saying that 'Unable to run this item. The server is not defined in the current repository'. I don't have any servers to connect. Is it possible to run a program in EG without connecting to a server? Thanks for your time and help.

Re: How to run a program in EG5.1 without connecting to a server

Reeza — Fri, 26 Jul 2013 19:13:54 GMT

As long as you have a local set up yes. If you click the little arrow besides Run it should say run on local. Otherwise you have a set up problem somewhere.

Can your do anything else in EG?

Re: How to run a program in EG5.1 without connecting to a server

JayG — Fri, 26 Jul 2013 19:18:36 GMT

Thanks for quick reply. I don't see 'Run on Local' in Run menu. I can see 'Run' and 'Run Selection' (Disable mode). I can perform other operations like create project, programs, import data etc. I am very new to SAS. Do i need to make any configuration changes to set up 'Local'? Thank You.

Re: How to run a program in EG5.1 without connecting to a server

MichelleHomes — Fri, 26 Jul 2013 20:06:37 GMT

EG needs to connect to SAS somewhere to run the SAS code EG generates. EG by itself is not SAS. You either connect to a SAS server or SAS locally (SAS installed on the same machine as EG). It seems that you may need to install SAS.

Re: How to run a program in EG5.1 without connecting to a server

sas_9 — Fri, 26 Jul 2013 20:14:50 GMT

Hey J - you can write program - right click on it and choose option 'run locally' from server selection option or direct option...

this way you can check if its running or not - if not describe error message, someone can explain

Re: How to run a program in EG5.1 without connecting to a server

Fugue — Fri, 26 Jul 2013 21:39:48 GMT

At the very least, EG requires one server to run programs or tasks. The "server" can be local, but whether a local server exists and associated configuration settings may be controlled by your SAS Administrator.

The first thing you need to check is whether a local server has been defined. On the Menu Bar, select View --> Server List. (Note: this is not the only way to access the server list).

In the Server List pane (by default, this pane will appear on the lower left side of EG), expand the server list by clicking on the "+". This should allow you to see a server called "Local". If you can see the server called "Local", left-click on it and SAS will try to connect to it by default. Wait a few seconds while SAS does it's magic. Eventually, SAS/EG will connect (or not).

If you cannot see a "Local" server or if EG fails to connect to the Local server, then you have a problem.

If you have a successful connection to a "Local" server, then you need to make sure that your code is set to run on the Local server.

In the Process Flow window, RIGHT click on your code icon and select Select Server --> Local. (You can also do this in the Project Tree window). You will probably have to do this for each code object if you have more than one. Then, try running your process flow again.

Re: How to run a program in EG5.1 without connecting to a server

JayG — Sat, 27 Jul 2013 01:48:41 GMT

I don't see any 'Local' under Servers in EG. Do i need to install SAS separately for local server?

Re: How to run a program in EG5.1 without connecting to a server

Fugue — Sat, 27 Jul 2013 02:33:13 GMT

During a typical EG install, SAS should automatically install any SAS software it needs. EG is basically a client/application interface, with the SAS engine doing the heavy lifting behind the scenes.

Have you set up a connection profile?

* In SAS Enterprise Guide, select Tools --> SAS Enterprise Guide Explorer --> File --> Manage Profiles --> Profiles --> Add

* create a local server named Local and check Local (under Machine)

Re: How to run a program in EG5.1 without connecting to a server

JayG — Sat, 27 Jul 2013 20:16:02 GMT

I have tried creating a profile as you recommended. I am not sure which credentials that i need to specify. I have selected IWA, but connection is not working. Are there any default credentials for SAS Metadata Repository?

Re: How to run a program in EG5.1 without connecting to a server

Patrick — Sun, 28 Jul 2013 03:29:03 GMT

As others already said SAS EG is the client (client tier). To execute SAS programs you need to connect to a SAS Server (compute tier). To be able to create such a connection you need to authenticate yourself on the SAS Metadata server (mid tier).

In order to authenticate yourself you need a SAS Metadata identity defined. This paper should give you some insights of how this works: http://support.sas.com/resources/papers/proceedings13/420-2013.pdf

IWA must be configured in your environment in order to use it. From what you've told us so far I doubt that this is the case in your environment.

If you have a local installation of SAS then you can also use EG without any metadata server and you don't need to define a profile at all.

This will then let you use your locally installed SAS without the need for any further configuration.

Re: How to run a program in EG5.1 without connecting to a server

jakarman — Sun, 28 Jul 2013 06:29:29 GMT

Jay

All replies are having the information how it should be technically solved. I am wondering....

You have the client Side (Eguide) being deliverd. Who has done this?

Options:

1/ Is it yourself.

- you probably have a local (desktop) installation. The installation of SAS/base (Foundation) also is needed (dms).

- The task is setting up a whole sas server/client environment? whhh..., this will be challenging to handle in a discussion like this.

2/ Being delivered to you.

- The one that has it delivered must alos give you all other needed information

Server name, port numbers etc. How the credetials are beig doen (keys/psed) etc. This is given in the profile.

- No one nows the SAS server location name etc? Has this been organized?

Could be to far simplified project planning.

++ Need to deliver the interface Eguide (in the project).

++ Forgotten the server side, nobody mentioned or has been deleted in the project as it was not needed by you.

( do not laugh it happens.)

Re: How to run a program in EG5.1 without connecting to a server

Fugue — Mon, 29 Jul 2013 17:43:34 GMT

Don't select IWA unless you are configured for it, as Patrick pointed out. Don't set a login or pw. Once you've added the Local Server, you should be able to see it in your server list.

Re: How to run a program in EG5.1 without connecting to a server

jakarman — Mon, 29 Jul 2013 18:43:22 GMT

@Fugue, It would make sense JayG would tell explain:

a/ his role, b/ what is expected from him, c/ what information he has, d/ what he has running e/ wich contacts fo support he has etc.etc.

We can give a lot of advices, but as seen the questions with responses there is clearly some misunderstanding.

Re: How to run a program in EG5.1 without connecting to a server

Fugue — Mon, 29 Jul 2013 19:00:23 GMT

I agree, Jaap. I was trying to keep it simple as I didn't want to overload JayG. SAS/EG is not the most user-friendly product to get up and running, as you know.

And as Patrick pointed out, JayG should be able to set up a Local server without a connection profile. But, setting up a connection profile to Local without any credentials should accomplish that.

If JayG cannot create and connect to a Local server, then I think we should explore all those questions you raise.

Re: How to run a program in EG5.1 without connecting to a server

JayG — Mon, 29 Jul 2013 21:11:25 GMT

Thank you all for your wonderful replies.

As some of you recommended, i could not create a 'Local' connection profile. When i click on new connection, i can enter name as 'Local' and select 'localhost'. The next step is to enter credentials or IWA. If i don't enter credentials or don't select IWA, 'Save' button is disabled. So, i could not save Local profile.

When i open EG, there is a profile in connections box with name '<do not use a profile>'. I can select that, but could not set active. When i close the Connections box, i am seeing 'No profile selected' in bottom right corner. I could not run any program in EG with this set up.

Re: How to run a program in EG5.1 without connecting to a server

Fugue — Mon, 29 Jul 2013 21:36:29 GMT

Perhaps one of the members with more experience in 5.1 can help you with this? I'm running 4.3, and the setup is a little different.

As per Jaap's question(s), did you install EG yourself or did your SAS Administrator install it? What version of EG are you running (Help --> About Enterprise Guide)?

Re: How to run a program in EG5.1 without connecting to a server

Patrick — Tue, 30 Jul 2013 20:43:12 GMT

"When i close the Connections box, i am seeing 'No profile selected' in bottom right corner"

That means this is the active profile.

If you look closely at the screen shots I've sent through in my last post you can see that "set active" is also greyed out there. That's because the profile is already active. It's the same for you.

Can you then also see a server "Local" in the Server List (like in the 2nd screen shot)? And if yes: What happens if you click on the '+' sign in front of this server?

If you don't see a server Local then SAS has not been installed (or properly installed) on your local computer and you need to connect to a remote SAS server. In order to do so you need to know the connection info to this server and how to connect. Is this a personal installation or are you using SAS in a professional environment?

"It's not working" - what is not working? What are you doing EXACTLY and how are you "told" that it's not working?

For "debugging"

Delete all profiles you've created so far so that only "no profile selected" remains. Then try to create a session by clicking on the '+' sign in fron of server Local. If this works then try and execute some code.

Let us know how this went and where you got stuck (if at all).

Re: How to run a program in EG5.1 without connecting to a server

JayG — Wed, 31 Jul 2013 23:59:16 GMT

I don't see "Local" in the server list. When i click on '+' sign, nothing show up. No child elements under 'Server'.

I have installed my self on my own in my laptop to learn SAS programming.

"It's not working" means i could not 'Run' any SAS program from EG. When ever i select program and click on 'Run', system showing an alert box saying 'Unable to run this item. The server is not defined in current repository.'

Please let me know if there is any work around to run SAS programs from EG.

Re: How to run a program in EG5.1 without connecting to a server

SASKiwi — Thu, 01 Aug 2013 01:16:16 GMT

If you installed it yourself what SAS products did you install? For EG to work you have to have Foundation aka Base SAS also installed on your desktop:

From your Windows Start button, click All Programs - do you have a SAS folder and is SAS 9.3 listed as well as SAS Enterprise Guide 5.1? If it is then try starting SAS 9.3 by clicking on it. It should bring up a series of windows.

If you don't have SAS 9.3 listed, then this needs to be installed also before EG will work.

Re: How to run a program in EG5.1 without connecting to a server

JayG — Thu, 01 Aug 2013 01:44:20 GMT

I don't see SAS 9.3 listed under SAS folder in program files.