Desktop productivity for business analysts and programmers

SAS EG hangs when I try to join a table for a query

Reply
New Contributor
Posts: 2

SAS EG hangs when I try to join a table for a query

My SAS EG freezes when I try to join a table for a query on my WOG laptop, screenshot below for reference. How do I resolve this? sas.jpg

Super Contributor
Posts: 321

Re: SAS EG hangs when I try to join a table for a query

Hi,

 

A few questions, the answers to which might be of some help:

 

  1. What version of SAS EG are you using?
  2. Have you successfully run this query before with the same software set up, if yes, has anything changed since then?
  3. Have you successfully run any query with the same software set up?
  4. How many rows are in the tables you're trying to join?
  5. Is there any SQL code generated that you can show?
  6. The status bar (at the bottom) shows "Ready" are you able to interact with SAS EG at this point?
  7. Can anyone you know try the same join with the same set up?
  8. I assume you have tried rebooting your laptop?

 

 

Regards,

Amir.

New Contributor
Posts: 2

Re: SAS EG hangs when I try to join a table for a query

Hi, 

Am using SAS EG 7.1. Yes I have run it before, this 'freezing' happens occassionally. I have tried to run a join on SASHELP library however when i clicked the query builder button, it freezes again. The table im trying to join only has 428 rows. CARS. I have no other issues with running queries on my other laptop. I have checked system compatibilities, both running on 64 bit and installed memory ram available is 19.9gb.

 

Thank you.

Super Contributor
Posts: 321

Re: SAS EG hangs when I try to join a table for a query

Hi,

 

The fact that you have no issues on another laptop with the same setup indicates either an installation or (less likely) hardware issue.

 

I would try uninstalling and reinstalling SAS EG to see if that helps.

 

If that's not an option or you still have issues after reinstalling then I would advise that you raise a track with SAS Technical Support:

 

https://support.sas.com/en/technical-support/contact-sas.html

 

I did a web search and found the following similar sounding issue with some SAS Technical Support feedback supplied by @Yarlanil59:

 

https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-7-1-Freezes/td-p/321384

 

 

Regards,

Amir.

Ask a Question
Discussion stats
  • 3 replies
  • 145 views
  • 0 likes
  • 2 in conversation