https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/7643#M143 Can any body tell me <BR /> <BR /> What is the functionality for LOOPS= Option in Proc SQL?<BR /> <BR /> Thanks in advance,<BR /> <BR /> Madhu.G Tue, 25 Mar 2008 09:47:33 GMT deleted_user 2008-03-25T09:47:33Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/7643#M143 Can any body tell me <BR /> <BR /> What is the functionality for LOOPS= Option in Proc SQL?<BR /> <BR /> Thanks in advance,<BR /> <BR /> Madhu.G Tue, 25 Mar 2008 09:47:33 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/7643#M143 deleted_user 2008-03-25T09:47:33Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/7644#M144 It is used to prevent run-away PROC SQL statements, typically when debugging.<BR /> <BR /> 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.<BR /> <BR /> Is it like INOBS, OUTOBS but restricts based on the number of inner loop executions.<BR /> <BR /> Ike Tue, 25 Mar 2008 14:57:59 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/7644#M144 deleted_user 2008-03-25T14:57:59Z