topic Stop SAS EG when maximum size exceeds in SAS Enterprise Guide

Stop SAS EG when maximum size exceeds

amity21 — Fri, 04 Jan 2019 22:52:23 GMT

Hi,

So I am looking for a way to put a maximum size limit on my SAS EG so that if code ever loops, the project/query stops with an error (mentioning excess size hopefully).

I saw another article where someone has this as an error when their size went over 5MB and they turned off project logs, but I don't see an option to actually set it up with size.

I use SAS EG7.1 on a corporate network which I believe is connected to a remote server.

They send an automatic email if the maximum work library size has exceeded and I have asked them as well if this is a possible solution available on the remote server side.

Any help is greatly appreciated.

Re: Stop SAS EG when maximum size exceeds

Sajid01 — Sun, 06 Jan 2019 16:56:47 GMT

The size of 5 MB mentioned is about SAS logs. There are ways and means to overcome this.
What size you want to limit?

Need clarity on this.

Re: Stop SAS EG when maximum size exceeds

SASKiwi — Sun, 06 Jan 2019 20:06:32 GMT

If your code loops then it is good practice to set upper limits so it cannot go beyond these. Code does not loop unless you have logic to cause it. It would be helpful if you posted an example of the type of looping you have.

Re: Stop SAS EG when maximum size exceeds

amity21 — Mon, 07 Jan 2019 09:39:54 GMT

Applying ab observation limit will work, but most looping happens when I overlook something. For example, doing a join of two tables creating a huge amount of outcomes.
If there is a generic size I can put on my work library as when it goes over 50GB, crash all programs.

Re: Stop SAS EG when maximum size exceeds

SASKiwi — Mon, 07 Jan 2019 19:09:42 GMT

Setting individual space limits on WORK libraries is possible using OS commands like ulimit if your are running on Unix. What OS do your SAS servers run on?