Desktop productivity for business analysts and programmers

SAS Enterprise Guide freezes after stored process run

Reply
New Contributor
Posts: 4

SAS Enterprise Guide freezes after stored process run

Hi All,

Regarding SAS EG freezing issue in SAS 9.4 M3. We are running stored process in EG. Once Stored proces complete, Output window show as ""LOADING" and EG screen freezes. After that we are not able to do anything in EG. We need to close the EG and open again.

 

To resolve this issue, we just de-selected the "Automatically open data when added to project" in options. That resolve the freezing issue.

 

Please let me know if you have faced this issue and what solution you implemented other than above?  or If there any other parmanent solution of this issue?

As per my opinion, this issue is occurring due to data volume. What is your view on this?

 

Thanks,

HR Prasad

Esteemed Advisor
Posts: 6,646

Re: SAS Enterprise Guide freezes after stored process run

Your output might be so large that it

- takes a very long time to load

- causes a memory overflow in EG that you detect as "freeze".

What happens when you run your STP through the web interface?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: SAS Enterprise Guide freezes after stored process run

I generated the EG log and verified but did not find any specific error for memory issue.

We are using EG to run STP, did not tried on web interface.

Esteemed Advisor
Posts: 6,646

Re: SAS Enterprise Guide freezes after stored process run

Have you taken a look at the STP server logs?

 

Apart from that, I can only repeat: run the STP from the web (or another) interface so you can isolate EG as the culprit if nothing bad happens there.

At least you can take a look at the STP output this way.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Community Manager
Posts: 2,691

Re: SAS Enterprise Guide freezes after stored process run

What type of data are you creating?  Some sequential data types, such as accessed via the XML or XLSX libname engines, can cause a hang in EG (though this has been fixed in the most recent EG 7.12 hotfix).

Ask a Question
Discussion stats
  • 4 replies
  • 316 views
  • 0 likes
  • 3 in conversation