| Date: | Wed, 22 Nov 2006 02:20:02 -0800 |
| Reply-To: | Sander Burggraaff <info@BURGIE-T.NL> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Sander Burggraaff <info@BURGIE-T.NL> |
| Organization: | http://groups.google.com |
| Subject: | Re: 11.500 tables in 1 set statement. Bad for performance? |
|
| In-Reply-To: | <BAY123-F9FA862984F1E00E7960C8DEEE0@phx.gbl> |
| Content-Type: | text/plain; charset="us-ascii" |
|---|
Ok, a little modification is in order:
You only have to code OPEN = DEFER once because it applies to all input
tables. So it doesn't have to be part of the loop.
Secondly, when the tables don't contain the same variables only the
variables from the first table will be saved. Any extra variables will
be ignored.
So it's wise to create a table that contains all the variables you want
but no observations. Put that table on the set statement as the first
table to load.
|