PROC APPEND

PROC APPEND is an alternate way of stacking up datasets. It differs from concatenation since it uses the SET statement in the following ways:

  • PROC APPEND can only handle two datasets, whereas the only limitation for concatenation is the computing resources.
  • In PROC APPEND, you cannot create a new dataset.
  • PROC APPEND is the most helpful for large datasets as it does not read the dataset and merely appends the second dataset to the first.
  • The PROC APPEND procedure can be forced to create an output when the variables in datasets are of different types. Concatenation via the SET statement will stop processing and not produce an output.

We will reuse the dataset from the Concatenating section and get familiar with the syntax of ...

Get Hands-On SAS for Data Analysis now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.