Date: Wed, 21 Nov 2007 07:19:05 -0500
Reply-To: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject: Re: creating data table from many tables
not a idea for that what you want. I would use a macro for that, fetch all
what fits to the desired names from SASHELP.VCOLUMN...
But something other: are that tables all of the same structure? In that
case a SET with 100 or more tables is very inefficient! Better:
which needs less memory and less time to allocate that memory, because
only one table is open at a time, not all 100.
If nobody has a better solution e.g. with a kind of wildcard, I could help
you with a macro if you want.
On Wed, 21 Nov 2007 04:04:00 -0800, andrewjmdata@GMAIL.COM wrote:
>Hi - I have a pile of around 100 tables and I want to set them all
>into 1 table.
>At the moment it works like this...
>I am sure there must be a more succint way of doing this.... "set
>where table like *_table" or something.
>Any ideas anyone?