PROC SQL, 3rd Edition

Chapter 6: Modifying and Updating Tables and Indexes

Introduction. 195

Modifying Tables. 195

Adding New Columns. 196

Controlling the Position of Columns in a Table. 198

Changing a Column’s Length. 200

Changing a Column’s Format 204

Changing a Column’s Label 204

Renaming a Column. 204

Renaming a Table. 206

Indexes. 207

Designing Indexes. 209

Cardinality. 209

Index Selectivity. 210

Defining Indexes. 211

Creating a Simple Index. 212

Creating a Composite Index. 213

Preventing Duplicate Values in an Index. 214

Modifying Columns Containing Indexes. 214

Indexes and Function Calls. 214

Index Processing Costs. 217

Deleting (Dropping) Indexes. 217

Updating Data in a Table. 218

Summary. 219

 

Introduction

After a table is defined and populated with data, ...