SAS/ACCESS Software for Relational Databases: Reference

Sample Data in This Book

This book uses two sets of tables to show you how to use SAS/ACCESS software, as described in DBMS Tables (Textile Data) and DBMS Tables (Airline Data). One set of tables was created for a fictitious international textile manufacturer. The second set of tables was created for a fictitious international airline. All the data in the tables is fictitious.

The tables are designed to show how the SAS/ACCESS interface treats data that is stored in relational DBMS tables. They are not meant as examples for you to follow in designing tables for any purpose.

The following list describes the files that contain examples and data that are used in this book. These files are packaged with your SAS software; see your site administrator for details.

GENSQL.SAS: contains the PROC SQL code that creates the RDBMS tables used in the Version 7 and later examples. These tables contain the international airline data.
GENDBL.SAS: contains the SAS code that creates the RDBMS tables for the Version 6 compatibility examples. These tables contain the international textile manufacturer data.
GENSAMP.SAS: contains the SAS code used in the examples chapters.
DBMACS.SAS: contains macros that enable any SAS/ACCESS interface to a relational DBMS to create the database connection statements that are used by the DBLOAD procedure in the GENDBL.SAS and GENSAMP.SAS files.
DBPTMACS.SAS: contains macros that enable any SAS/ACCESS interface to a relational database to create the database connection statements that are used by the SQL Procedure Pass-Through Facility in the GENDBL.SAS and GENSAMP.SAS files.

Chapter Contents
Previous
Next
Top of Page