PROC SQL: Beyond the Basics Using SAS®

5.2. Creating Tables

An important element in table creation is table design. Table design incorporates how tables are structured — how rows and columns are defined, how indexes are created, and how columns refer to values in other columns. Readers seeking a greater understanding in this area are encouraged to review the many references identified at the end of this book. The following overview should be kept in mind during the table design process.

When building a table it is important to devote adequate time to planning its design as well as understanding the needs that each table is meant to satisfy. This process involves a number of activities such as requirements and feasibility analysis including cost/benefit of the proposed tables, the ...