topic Re: SAS Enterprise Guide 7.1 Freezes in SAS Enterprise Guide

SAS Enterprise Guide 7.1 Freezes

Dee16 — Wed, 28 Dec 2016 04:39:06 GMT

When modify existing query in SAS EG 7.1 I was using the up arrow to move multiple columns further up in the Seelct Data list. During this process the screen locked. Showed Running Validate: query name Running Proc SQL. Not sure why the validate step started to run. The query no longer responded and had to close EG via Task Manager. Myself and a colleaugue have been having problems with EG locking since went to version 7.1. The project was built in EG 7.1 and the query I was editing is reading one work table created by the previous step in the project. Has anyone else encountered similar problems with EG 7.1 lockng when modifying a query?

Re: SAS Enterprise Guide 7.1 Freezes

jimbarbour — Thu, 29 Dec 2016 18:36:04 GMT

Hmm, I actually did yesterday with SAS EG 7.13 HF1 running on a Windows 7 Enterprise, SP1, 64 bit. I was trying to drag and drop some columns and it locked up on me. I used Task Manager to kill SAS EG. The problem did not recur.

Re: SAS Enterprise Guide 7.1 Freezes

Yarlanil59 — Wed, 07 Jun 2017 14:58:33 GMT

The Same problem occurred to me. So I raised Ticket with SAS Tech support. They gave me the following resolution.

In the query builder when I use the up/down arrow to change field order it will sometimes lock up and I have to crash the SAS instance and start over.

Go to Tools>Option in SAS EG
Go to Query option

Then uncheck “Automatically validate query whenever changes are made” and “Automatically attempt to join tables in query”

After that, I never face that issue. Hope this helps.

Re: SAS Enterprise Guide 7.1 Freezes

OskarBak — Wed, 24 Oct 2018 20:07:16 GMT

I have the same issue. Tried the suggested solution but it does not help. Furthermore I never have problems on the same laptop when it is docked and not on wifi.