5.1. Appending Tables
In SAS Enterprise Guide, there are two basic ways to combine data tables: appending and joining. You append tables when they contain the same (or almost the same) columns. For example, if you had sales data for January, February, and March in three separate tables, you could append the tables to create one table for the entire quarter.
In this example, a customer living in southern Washington is interested in traveling with the Fire and Ice Tours company. Because this customer lives between Seattle and Portland, she wants to see prices for flights from each city. Here are two data tables, one showing flights from Portland and the other from Seattle.
Looking at these two data tables, you can see they contain the same columns, ...
Get The Little SAS® Book for Enterprise Guide® 4.1 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.
