Proc SQL

[deleted_user]

Can any body tell me

What is the functionality for LOOPS= Option in Proc SQL?

Thanks in advance,

Madhu.G

[deleted_user]

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