topic Re: Problem with connection to EG in SAS Enterprise Guide

Problem with connection to EG

noetsi — Tue, 06 Sep 2022 17:22:45 GMT

Re: Problem with connection to EG

noetsi — Tue, 06 Sep 2022 17:27:01 GMT

Sorry I messed up the post and can not figure out how to edit the original post where I did not list the problem. I run

proc setinit;
run;

and have no problem. A colleague with the same license is doing this, his license just changed, and he gets

Error: The connection to the server has been lost.

We are trying to fix this, but don't know what is causing it.

Re: Problem with connection to EG

Kurt_Bremser — Tue, 06 Sep 2022 18:19:43 GMT

Do both of you connect to the same remote SAS server, or do both of you use the "Local" server with the SAS System installed on your PC's?

Re: Problem with connection to EG

noetsi — Tue, 06 Sep 2022 18:24:49 GMT

I believe we both use the local servers on our computer although I am not in IT and am no expert in this. No one has ever actually told me this.

Re: Problem with connection to EG

Kurt_Bremser — Tue, 06 Sep 2022 18:36:14 GMT

With a local SAS installation, you will also have a link in your Start menu to start SAS directly without EG. Try that to see if the SAS System itself works.

Re: Problem with connection to EG

noetsi — Tue, 06 Sep 2022 20:42:01 GMT

This is what happened when he tried.

Re: Problem with connection to EG

SASKiwi — Tue, 06 Sep 2022 20:58:05 GMT

That screenshot is perfectly healthy. To get EG working again all you need to do is to edit the connection profile and repoint it at your local server.

Re: Problem with connection to EG

noetsi — Tue, 06 Sep 2022 21:07:01 GMT

SASKiwi (are you from NZ) 🙂 how would I do this?

"To get EG working again all you need to do is to edit the connection profile and repoint it at your local server."

I am not in IT, but since we have no SAS IT experts, they are going to want to know how that is done.🙄 We are an organization unfortunately with limited knowledge of SAS other than coding/analysis. Its why I ask here, no one in our IT unit knows anything about it.

Re: Problem with connection to EG

SASKiwi — Tue, 06 Sep 2022 22:42:06 GMT

In EG, on the menu bar click Tools, then select Connections. This will bring up the Connection window. If no profiles appear in the Profiles list, select the Add button and that opens the Create Profile window. For the Server option select local and the IWA option. Filling out the the rest of the screen should be simple - use defaults where possible.

Note, you can use EG help to get more instructions on creating an EG profile.

Yep, based in Wellington NZ 😀

Re: Problem with connection to EG

Kurt_Bremser — Wed, 07 Sep 2022 05:59:13 GMT

You must get a SAS administrator (*), and also develop a strategy for your SAS usage. Depending on the number of SAS users and the necessary interactions between them, a centralized SAS server may be better than a heap of local SAS installations.

*) this does not mean you have to hire an additional person, but one of you needs to develop the necessary skills and knowledge, best through the appropriate SAS courses.

Re: Problem with connection to EG

noetsi — Wed, 07 Sep 2022 16:05:21 GMT

Its not my decision. We have a strange organization in that we bought SAS to do statistical, and SQL, analysis, but there is no interest in actually doing so. So they won't commit any resources including developing any expertise. I try myself, but I lack administrative rights at my organization (that is very much command orientated) to do many things. I do statistical analysis, but I have essentially no IT background other than coding and absolutely no authority to do key IT functions. Our strategy for SAS is to buy it then, other than what I do on my own, ignore it. After 12 years of this I am retiring.

Re: Problem with connection to EG

Kurt_Bremser — Wed, 07 Sep 2022 16:10:23 GMT

@noetsi wrote:
After 12 years of this I am retiring.

Understandable.

Re: Problem with connection to EG

noetsi — Wed, 07 Sep 2022 16:19:20 GMT

Actually I apologize for my complaint - its a sore point with me and has been for years, that we won't support a software that we actually really need and that we put so little value on formal analysis. But this organization is entirely political and not data driven. So we spend lots of money on a software that, other than my license, we can't actually operate (there are two other licenses, neither works). I suggested getting rid of all but my license since I am the only one that ever uses it, and they said no. 🙂

Re: Problem with connection to EG

Tom — Wed, 07 Sep 2022 16:51:15 GMT

Since your license works it means they are still paying SAS. So when you have an issue you can open a support ticket with SAS. It is covered by your license fee.

Re: Problem with connection to EG

SASKiwi — Wed, 07 Sep 2022 20:05:43 GMT

@noetsi - As @Tom says, if you are still having problems configuring your EG connection profile after trying my my instructions, then open a SAS Tech Support track. All it would take is an online call including screen sharing to walk you through it. They do this type of interaction all the time in my experience.

Re: Problem with connection to EG

noetsi — Wed, 07 Sep 2022 20:54:14 GMT

I was about to do that. I always have in the past. But I was working on reports, using sas naturally, and since my SAS works I delayed it until the reports run. Amusingly I run subsidiary analysis in another software to supplement my sas and for the first time ever that software became corrupted lol. Some days are better than others.

Thanks very much all for the many suggestions.

Re: Problem with connection to EG

noetsi — Tue, 13 Sep 2022 21:43:02 GMT

We tried the solution listed and ran into some problems (our lack of expertise is showing).

It did not show a profile, at least one that we understood.

So we tried to add a profile by using the add button and doing this

When we tried to use that (my colleague not me since mine works) he got

I am going to follow up with the suggestion of creating a technical track. Thanks very much for all the help.

Re: Problem with connection to EG

SASKiwi — Wed, 14 Sep 2022 02:06:43 GMT

Sorry, my instructions weren't correct. In your case choosing the "No Profile" option is the correct choice. Here are some much better ones: Using SAS Enterprise Guide with your local SAS ins... - SAS Support Communities

Re: Problem with connection to EG

noetsi — Wed, 14 Sep 2022 15:11:55 GMT

thanks