Date:         Fri, 15 Feb 2008 12:20:00 -0800
Reply-To:     pchoate <paulchoate61@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         pchoate <paulchoate61@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: append varous datasets with same column names in a sas macro
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi Stefan  -

In SAS there is proc append:

proc append base=ds0 data=ds1 ds2 ds3;
run;

Which has the advantage of not reading the base dataset ds0.

To do this in a macro would simple mean wrapping the above in the
macro...

%macro append;
      proc append base=ds0 data=
   %do  i =  1 %to 3;
         ds&i
   %end;
     ; run;
%mend append;

%append;

or something like that.  You need to show some examle code for a more
specific answer.

HTH - Paul Choate


On Feb 15, 10:59 am, stefan.p...@ISH.DE (Stefan Pohl) wrote:
> Hi sas-group,
>
> I want to append various data set which have the same columns. Normally I
> would use the set statement.
> My problem is that I use a macro in which I produce n of such data sets, n
> is the number of rows of the
> original data set.
>
> How can I append this n datasets within my macro?
>
> Thank you for help.
>
> Stefan.