Help using Base SAS procedures

Proc Sql - How tables can create

Reply
Contributor
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,

Hima

Trusted Advisor
Posts: 3,212

Re: Proc Sql - How tables can create

Posted in reply to HimaAalamuri

try to reach the limit.

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

Re: Proc Sql - How tables can create

Posted in reply to HimaAalamuri

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
  • 169 views
  • 0 likes
  • 3 in conversation