Help using Base SAS procedures

Proc SQL

Reply
N/A
Posts: 0

Proc SQL

Can any body tell me

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

Thanks in advance,

Madhu.G
N/A
Posts: 0

Re: Proc SQL

Posted in reply to 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
Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 1 in conversation