SAS/ACCESS 9.1 Interface To System 2000: Reference (SAS Series for Business and Industry)

SAS/ACCESS software provides an interface between SAS and SYSTEM 2000 database management software. In this title, learn how you can create SAS/ACCESS descriptor files by using the ACCESS procedure; directly access data in SYSTEM 2000 databases from within a SAS program by using the descriptor files created with the ACCESS procedure; extract SYSTEM 2000 data and place it in a SAS data file by using the ACCESS procedure or the DATA step; load data into a SYSTEM 2000 database by using the DBLOAD procedure; update data in SYSTEM 2000 databases by using the SQL procedure, SAS/FSP software, or the APPEND procedure (the SQL procedure can also be used to join SAS data files, PROC SQL views, and SAS/ACCESS view descriptors); and directly access data in SYSTEM 2000 databases by using the QUEST procedure with SYSTEM 2000 statements. You might need to learn how to combine data from several SYSTEM 2000 databases or from external databases (such as DB2) or from Version 6 and later SAS data sets. Such combinations are quite easy to do. SAS can distinguish between SAS data files, SAS/ACCESS descriptor files, and other types of SAS files, and the software will use the appropriate access method.