General form, PROC APPEND:
PROC APPEND BASE=SAS-data-set DATA=SAS-data-set;
RUN;
BASE=SAS-data-set
names the data set
to which you want to add observations.
DATA=SAS-data-set
names the SAS data
set containing observations that you want to append to the end of
the BASE= data set.
|
Date
was
not found in the DATA= file. proc append base=work.cap2001 data=work.capacity; run;
NOTE: Appending WORK.CAPACITY to WORK.CAP2001.
WARNING: Variable Date was not found on DATA file.
NOTE: There were 50 observations read from the data set WORK.CAPACITY.
NOTE: 50 observations added.
NOTE: The data set WORK.CAP2001 has 100 observations and 8 variables.
NOTE: PROCEDURE APPEND used (Total process time): |
data work.new; set work.cap2001 work.capacity; run;
General form, PROC APPEND
with the FORCE option:
PROC APPEND BASE=SAS-data-set DATA=SAS-data-set <FORCE>;
|
proc append base=work.capacity data=work.cap2001; run;
NOTE: Appending WORK.CAP2001 to WORK.CAPACITY. WARNING: Variable Date was not found on BASE file. ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files. NOTE: 0 observations added. NOTE: The data set WORK.CAPACITY has 50 observations and 7 variables. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.02 seconds cpu time 0.03 seconds NOTE: The SAS System stopped processing this step because of errors. |
proc append base=work.capacity
data=work.cap2001 force;
run;
NOTE: Appending WORK.CAP2001 to WORK.CAPACITY. WARNING: Variable Date was not found on BASE file. NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 50 observations read from the data set WORK.CAP2001. NOTE: 50 observations added. NOTE: The data set WORK.CAPACITY has 100 observations and 7 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.03 seconds cpu time 0.03 seconds |
Date
has been dropped from
the appended version of Work.Capacity.
proc append base=work.acities data=work.westaust; run;
NOTE: Appending WORK.WESTAUST to WORK.ACITIES. WARNING: Variable City has different lengths on BASE and DATA files (BASE 22 DATA 50). ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files. NOTE: 0 observations added. NOTE: The data set WORK.ACITIES has 50 observations and 4 variables. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 1.44 seconds cpu time 0.06 seconds NOTE: The SAS System stopped processing this step because of errors. |
proc append base=work.acities
data=work.westaust force;
run;
NOTE: Appending WORK.WESTAUST to WORK.ACITIES. WARNING: Variable City has different lengths on BASE and DATA files (BASE 22 DATA 50). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 50 observations read from the data set WORK.WESTAUST. NOTE: 50 observations added. NOTE: The data set WORK.ACITIES has 100 observations and 4 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 1.44 seconds cpu time 0.06 seconds |
proc append base=work.allemps data=work.newemps; run;
NOTE: Appending WORK.NEWEMPS to WORK.ALLEMPS. WARNING: Variable Phone not appended because of type mismatch. ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files. NOTE: 0 observations added. NOTE: The data set WORK.ALLEMPS has 550 observations and 5 variables. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.08 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. |
proc append base=work.allemps
data=work.newemps force;
run;
NOTE: Appending WORK.NEWEMPS to WORK.ALLEMPS. WARNING: Variable Phone not appended because of type mismatch. NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 19 observations read from the data set WORK.NEWEMPS. NOTE: 19 observations added. NOTE: The data set WORK.ALLEMPS has 569 observations and 5 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.05 seconds cpu time 0.02 seconds |