topic Re: Proc Sql - How tables can create in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145269#M38600 <HTML><HEAD></HEAD><BODY><P>Well, I could be wrong here as haven't pushed the boundaries, but from memory you can put many sql create table statements (just tested creating 500 tables no probs), into one SQL step.&nbsp; Couldn't get a limit there.&nbsp; However I have run into difficulties when combining - e.g. merging/using as lookup, lots of tables - i.e. &gt; 20 in one sql step.&nbsp; (So select * from A left join B left join C etc.).&nbsp; So yes, just test it (and if you hit a boundary ask yourself are you coding it in the best way).&nbsp; </P></BODY></HTML> Fri, 30 Jan 2015 13:49:24 GMT RW9 2015-01-30T13:49:24Z Proc Sql - How tables can create https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145267#M38598 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have one doubt, within single block of sql -&nbsp; how many tables we can create?</P><P></P><P>Best Regards,</P><P>Hima</P></BODY></HTML> Fri, 30 Jan 2015 09:10:44 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145267#M38598 HimaAalamuri 2015-01-30T09:10:44Z Re: Proc Sql - How tables can create https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145268#M38599 <HTML><HEAD></HEAD><BODY><P>try to reach the limit. </P></BODY></HTML> Fri, 30 Jan 2015 13:15:51 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145268#M38599 jakarman 2015-01-30T13:15:51Z Re: Proc Sql - How tables can create https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145269#M38600 <HTML><HEAD></HEAD><BODY><P>Well, I could be wrong here as haven't pushed the boundaries, but from memory you can put many sql create table statements (just tested creating 500 tables no probs), into one SQL step.&nbsp; Couldn't get a limit there.&nbsp; However I have run into difficulties when combining - e.g. merging/using as lookup, lots of tables - i.e. &gt; 20 in one sql step.&nbsp; (So select * from A left join B left join C etc.).&nbsp; So yes, just test it (and if you hit a boundary ask yourself are you coding it in the best way).&nbsp; </P></BODY></HTML> Fri, 30 Jan 2015 13:49:24 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Sql-How-tables-can-create/m-p/145269#M38600 RW9 2015-01-30T13:49:24Z