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
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.