Help using Base SAS procedures

Proc Sql - How tables can create

Posts: 44

Proc Sql - How tables can create

Hi all,

i have one doubt, within single block of sql -  how many tables we can create?

Best Regards,


Valued Guide
Posts: 3,208

Re: Proc Sql - How tables can create

try to reach the limit.

---->-- ja karman --<-----
Super User
Super User
Posts: 7,401

Re: Proc Sql - How tables can create

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.  Couldn't get a limit there.  However I have run into difficulties when combining - e.g. merging/using as lookup, lots of tables - i.e. > 20 in one sql step.  (So select * from A left join B left join C etc.).  So yes, just test it (and if you hit a boundary ask yourself are you coding it in the best way). 

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation