SYSTEM 2000 Software

SYSTEM 2000 Database Files

SYSTEM 2000 has eight database files associated with each database. The first six files are required.

File 1 - Master Record and Definition Table
File 2 - Distinct Values Table
File 3 - Extended Field Table
File 4 - Multiple Occurrence Table
File 5 - Hierarchical Table
File 6 - Data Table
File 7 - Update Log (optional)
File 8 - Rollback Log (optional)

When you are working in a single-user environment, you must allocate the appropriate database files in your SAS session before accessing the data. For a Multi-User environment, the database files can be allocated before the Multi-User software is initialized or, in Release 12.0 and later of SYSTEM 2000, the files can be dynamically allocated during execution by using the ALLOC command.

For more information about SYSTEM 2000 terms and concepts, see Topics for Database Administrators and Advanced Topics for Users.

Top of Page