Chapter Contents

Previous

Next
SAS/ACCESS Software for Relational Databases: Reference

Sample Data in This Book

This book uses two sets of tables in order to show you how to use SAS/ACCESS software. See DBMS Tables (Textile 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 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 SAS code that creates the DBMS tables used in the Version 7 examples. These tables contain the international airline data.

GENDBL.SAS
contains the SAS code that creates the DBMS 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

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.