Date:         Mon, 14 Jan 2008 15:34:23 -0500
Reply-To:     Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Subject:      Re: How to use macro to merge many dataset
Comments: To: tammy1207@yahoo.com.tw
In-Reply-To:  <250fe19f-3bc2-4a05-b73b-afbbe69a76f2@v4g2000hsf.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

In the code I put last, the lines

do until(eof) and

end

are not needed.

Use Proc Append for your needs, as in this case, the data sets are not read
into memory.

Muthia Kachirayan


On Jan 14, 2008 3:21 PM, <tammy1207@yahoo.com.tw> wrote:

> Yes, I am trying to do the vertical concatenation.
> Without macro, my code will be
>
> data all;
>   set a250 a251 a252..... a750;
> run;
>
> My quesetion is how to use macro or any other way to complete the
> merge rather than write down each single dataset? Thanks.
>
> Tammy
>
>
> On Jan 14, 2:31 pm, datan...@GMAIL.COM ("data _null_,") wrote:
> > If the data sets have exactly the same variable then merging sounds
> > like the wrong thing.  Perhaps vertical concatenation?
> >
> > On Jan 14, 2008 1:26 PM,  <tammy1...@yahoo.com.tw> wrote:
> >
> >
> >
> > > I have 500 dataset named from a251 to a750. All of them have exactly
> > > the same variables. How can I merge them into one dataset by using
> > > macro? Thanks.- Hide quoted text -
> >
> > - Show quoted text -
>