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:

set
  a_table open=defer
  b_table open=defer
  ...
;

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.

Gerhard




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...
>
>data tblMain;
>  set
>     a_table
>     b_table
>     c_table
>     ....
>     n_table;
>run;
>
>I am sure there must be a more succint way of doing this.... "set
>where table like *_table" or something.
>
>Any ideas anyone?
>
>Many thanks
>
>Andrew