93 proc append
95 data=work.transaction_two force;
NOTE: Appending WORK.TRANSACTION_TWO to WORK.TRANSACTION_ONE.
WARNING: Variable Type was not found on BASE file. The variable will not be added to the BASE file.
NOTE: FORCE is specified, so dropping/truncating will occur.
NOTE: There were 1 observations read from the data set WORK.TRANSACTION_TWO.
NOTE: 1 observations added.
NOTE: The data set WORK.TRANSACTION_ONE has 3 observations and 2 variables.
NOTE: PROCEDURE APPEND used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
The FORCE option is required because the DATA= dataset has more variables than the BASE= dataset. Any additional variables in the DATA= dataset are ignored in the final appended result.
This is visible in the newly appended version of work.Transaction_one:
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.