SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Example Data in This Book

This book uses a SYSTEM 2000 database named EMPLOYEE and several SAS data files to show you how to use the SAS/ACCESS interface to SYSTEM 2000 software. The database and the SAS data files MYDATA.CLASSES, V6.BIRTHDY, and MYDATA.CORPHON were created for a company's employee information. The data file TRANS.BANKING (used as an example for the DBLOAD procedure) was created for banking transactions. All of the data are fictitious. The database is used to show how the interface treats SYSTEM 2000 data. It is not meant as an example for you to follow in designing databases for any purpose.

Example Data gives more information about the example data used in this manual. Appendix 3 provides the entire EMPLOYEE database definition, the SAS jobs used to create the data files, and the definitions of the view descriptors. In addition, the EMPLOYEE database data that the view descriptors access is provided.

The SAS jobs to create the SAS data files are on your installation media; see your SAS System Consultant to create the SAS data files. The EMPLOYEE database is on the SYSTEM 2000 installation tape; see your Database Administrator to ensure the data is available and restored to its original state.

You will create the access descriptor MYLIB.EMPLOYE and the view descriptors VLIB.EMPPOS and VLIB.EMPSKIL in Defining SAS/ACCESS Descriptor Files. You will need to create the other view descriptors in this book on your own using the definitions shown in Example Data.

Chapter Contents
Previous
Next
Top of Page