Report Top Up a Page Previous Next Up a Map TOC Page Index File Index What's New Page Bottom
Buffalo SAS Users Group Meeting : Putting the MEOW in Data Set Con-CAT-enation : SAS Programming Examples : Example of Concatenation using PROC APPEND published Tue, Jul 22, 2003 - 15:05 EDT

Example of Concatenation using PROC APPEND


This example concatenates the data sets using the APPEND procedure. New observations are appended to the end of the original data set, as specified in the procedure options.


Download this SAS file.   (Instructions for downloading)
Download this log file.   (Instructions for downloading)

SAS File Contents:

options nofmterr errors=1;

libname sbdata '/doc/cognigen/mis/sas/sasbuffs/2003-06/data/';

data tran1;
    set sbdata.tran1;
    
proc append base=tran1 data=sbdata.tran2;

Log File Contents:

1                                                          The SAS System                                19:01 Monday, June 16, 2003

NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
      Licensed to COGNIGEN CORP, Site 0027965002.
NOTE: This session is executing on the SunOS 5.8 platform.




This message is contained in the SAS news file, and is presented upon
initialization.  Edit the files "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.



NOTE: SAS initialization used:
      real time           0.05 seconds
      cpu time            0.05 seconds
      

NOTE: AUTOEXEC processing beginning; file is /home/darcy/autoexec.sas.


NOTE: AUTOEXEC processing completed.

1          options nofmterr errors=1;
2          
3          libname sbdata '/doc/cognigen/mis/sas/sasbuffs/2003-06/data/';
NOTE: Libref SBDATA was successfully assigned as follows: 
      Engine:        V8 
      Physical Name: /doc/cognigen/mis/sas/sasbuffs/2003-06/data
4          
5          data tran1;
6              set sbdata.tran1;
7          

NOTE: There were 100001 observations read from the data set SBDATA.TRAN1.
NOTE: The data set WORK.TRAN1 has 100001 observations and 13 variables.
NOTE: DATA statement used:
      real time           15.67 seconds
      cpu time            0.95 seconds
      

8          proc append base=tran1 data=sbdata.tran2;
9          
NOTE: Appending SBDATA.TRAN2 to WORK.TRAN1.
NOTE: There were 100001 observations read from the data set SBDATA.TRAN2.
NOTE: 100001 observations added.
NOTE: The data set WORK.TRAN1 has 200002 observations and 13 variables.
NOTE: PROCEDURE APPEND used:
      real time           14.91 seconds
      cpu time            0.80 seconds
      

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           31.97 seconds
      cpu time            1.92 seconds
2                                The SAS System      19:01 Monday, June 16, 2003

      


Page authored by Darcy Foit

Buffalo SAS Users Group Meeting : Putting the MEOW in Data Set Con-CAT-enation : SAS Programming Examples : Example of Concatenation using PROC APPEND published Tue, Jul 22, 2003 - 15:05 EDT
Report Top Up a Page Previous Next Up a Map TOC Page Index File Index What's New Page Top