SAS® Certification Prep Guide: Advanced Programming for SAS®9 Second Edition

Chapter 5. Creating and Managing Tables Using PROC SQL

• Overview 161

  • Introduction 161

  • Objectives 162

  • Prerequisites 162

• Understanding Methods of Creating Tables 162

• Creating an Empty Table by Defining Columns 163

  • Example 164

  • Specifying Data Types 165

  • Specifying Column Widths 166

  • Specifying Column Modifiers 167

  • Example 167

• Displaying the Structure of a Table 168

  • Example 169

• Creating an Empty Table That Is Like Another Table 169

  • Example 169

  • Specifying a Subset of Columns from a Table 170

  • Example 171

• Creating a Table from a Query Result 172

  • Example 172

  • Copying a Table 173

  • Example 174

• Inserting Rows of Data into a Table 174

  • Inserting Rows by Using the SET Clause 175

  • Example 176

  • Inserting Rows by Using the VALUES Clause 177

  • Example 179

  • Inserting Rows from a Query Result 180