SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Chapter 5Creating and Managing Tables Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Understanding Methods of Creating Tables

Creating an Empty Table by Defining Columns

Overview

Example

Specifying Data Types

Specifying Column Widths

Specifying Column Modifiers

Example

Displaying the Structure of a Table

Overview

Example

Creating an Empty Table That Is like Another Table

Overview

Example

Specifying a Subset of Columns from a Table

Example

Creating a Table from a Query Result

Overview

Example

Copying a Table

Example

Inserting Rows of Data into a Table

Overview

Inserting Rows by Using the SET Clause

Example

Inserting Rows by Using the VALUES Clause

Example

Inserting Rows from a Query Result

Example

Creating a Table That Has Integrity ...