Things under legendu
**
Things under legendu
union all (keep all rows) vs union (distinct/unique) prefer to use union all union and union all relies on column positions another way is to use proc append which appends data by matching column names
append as advantages over sql union append tries to match column names while sql union relies on the column orders.
be careful when you use append, be sure to remove previous data sets ... as you might run the same piece of code multiple times