Date:         Tue, 6 Oct 1998 19:45:38 GMT
Reply-To:     shiling@MATH.WAYNE.EDU
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Shiling Zhang <shiling@MATH.WAYNE.EDU>
Organization: Deja News - The Leader in Internet Discussion
Subject:      Re: Please tell me how to add several SAS sd files together
Comments: To: EDSTAT-L@JSE.STAT.NCSU.EDU, STAT-L@VM1.MCGILL.CA

HOANG,
 
Using PROC APPEND will save a lot on I/O because no read will be performed
<ON BASE DATASET>. But the procedure will have to spend I/O on an appended
dataset(read in and append). At this point, the proc append may not be a good
strategy.
 
In article <3618EC86.6711605E@bellsygma.com>,
  "HOANG, DUC D" <duc.hoang@bellsygma.com> wrote:
> There are many answers showing :
>
> Data bigfile;
> set file1 file2 file3 .... filen;
> run;
>
> Please note that when we are doing this, we read through sequentially
> each of those datasets which can be time consuming if those datasets
> tend to be very big.
>
> Using PROC APPEND will save a lot on I/O because no read will be
> performed as it is the case with SET statement.
>
> ==> PROC APPEND BASE=BIGFILE
>                 DATA=FILE1;
>
>     PROC APPEND BASE=BIGFILE
>                 DATA=FILE2;
>
>     PROC APPEND BASE=BIGFILE
>                 DATA=FILE3;
>
>     ........................
>
>     PROC APPEND BASE=BIGFILE
>                 DATA=FILEn;
>
> conjecture@geocities.com, Christopher Chan wrote:
> >
> > Hi,
> >
> > I get a problem
> >
> > file 1
> >
> > var1       var2
> > ---------------------
> > a            12
> > b             55
> > e             66
> >
> > file 2
> >
> > var1       var2
> > ----------------------
> > ll             111
> > oo           22
> > w             88
> > q              22
> >
> > Up to
> >
> > file   n
> >
> > var1          var2
> > -------------------------
> > hgh              55
> > uu                222
> >
> > How to add the files in order to get
> > output.
> >
> > var1          var2
> > ---------------------------
> > a            12
> > b             55
> > e             66
> > ll             111
> > oo           22
> > w             88
> > q              22
> >
> > hgh              55
> > uu                222
> >
> > Thanks
>
> --
> ******************************************************************
>
> Duc Hoang,   Consultant,  CGI (HR)
> 625 Belmont Street, 3rd Floor, Montreal, Quebec, H3B 2M1
> Phone: 514-870-2746 Fax: 514-870-9892
> Internet: duc.hoang@bellsygma.com
>
 
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own