v
Chapter 10
Data Set Options for Relational Databases 137
Overview of Data Set Options for Relational Databases 137
Chapter 11
Macro Variables and System Options for Relational Databases 219
Introduction to Macro Variables and System Options for Relational Databases
219
Macro Variables for Relational Databases
219
System Options for Relational Databases
220
Chapter 12
The Pass-Through Facility for Relational Databases 227
Overview of the SQL Procedure’s Interactions with SAS/ACCESS
227
Syntax for the Pass-Through Facility for Relational Databases
228
PART3 Sample Code 239
Chapter 13
Accessing DBMS Data with the LIBNAME Statement 241
About the LIBNAME Statement Sample Code
241
Creating SAS Data Sets from DBMS Data
242
Using the SQL Procedure with DBMS Data
246
Using Other SAS Procedures with DBMS Data
254
Calculating Statistics from DBMS Data
259
Selecting and Combining DBMS Data
260
Joining DBMS and SAS Data
261
Chapter 14
Accessing DBMS Data with the Pass-Through Facility 263
About the Pass-Through Facility Sample Code
263
Retrieving DBMS Data with a Pass-Through Query
264
Combining a PROC SQL View with a SAS Data Set
266
Using a Pass-Through Query in a Subquery
267
Chapter 15
Sample Data for SAS/ACCESS for Relational Databases 271
Introduction to the Sample Data
271
Descriptions of the Sample Data
271
PART
4 Converting SAS/ACCESS Descriptors to PROC SQL Views 275
Chapter 16 The CV2VIEW Procedure 277
Overview of the CV2VIEW Procedure
277
Procedure Syntax 278
CV2VIEW Procedure Examples
282
Chapter 17
The CV2ODBC Procedure 285
Overview of the CV2ODBC Procedure 285
Procedure Syntax 285
CV2ODBC Procedure Examples 289
PART5 Appendixes 293
