LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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?
Comments:   To: sas-l@uga.edu
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.


Back to: Top of message | Previous page | Main SAS-L page