Using CA-Datacom/DB Data in SAS Programs |
An advantage of the SAS/ACCESS interface to CA-Datacom/DB is that it enables SAS to read and write CA-Datacom/DB data directly using SAS programs. This section presents examples using CA-Datacom/DB data that is described by view descriptors in SAS programs. For information about the views and sample data, see Data and Descriptors for the Examples.
Throughout the examples, the SAS terms column and row are used instead of comparable CA-Datacom/DB terms, because this section illustrates using SAS procedures and the DATA step. The examples include printing and charting data, using the SQL procedure to combine data from various sources, and updating Version 6 and Version 8 and later SAS data sets with data from CA-Datacom/DB. For more information about the SAS language and procedures used in the examples, refer to the documents listed at the end of each section.
At the end of this section, Performance Considerations presents some techniques for using view descriptors efficiently in SAS programs.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.