It is used to prevent run-away PROC SQL statements, typically when debugging.
For example, if you are adding a new table to an SQL statement and forget to properly join the table it could create a huge table. If you had the LOOPS option set it wouldn't runaway on you during testing.
Is it like INOBS, OUTOBS but restricts based on the number of inner loop executions.
Ike
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.