SAS/ACCESS Interface to CA-DATACOM/DB: Reference

Access Descriptors for the CA-DATACOM/DB Tables

This section shows the access descriptors for the four CA-DATACOM/DB tables used in the examples. The tables are described in CA-DATACOM/DB Tables. The access descriptors are presented in alphabetical order for easy reference.

MYLIB.CUSTS Access Descriptor

The MYLIB.CUSTS access descriptor for the CUSTOMERS table was created as follows:

proc access dbms=datacom;
 create mylib.custs.access; 
  user=demo; 
  table=customers; 
  assign = yes;
  drop contact;
  list all;
  extend all;

  rename customer = custnum telephone = phone 
         streetaddress = street; 
  format firstorderdate = date7.; 
  informat firstorderdate = date7.;
  content firstorderdate = yymmdd6.;
  list all;
run;

MYLIB.EMPLOYEE Access Descriptor

The MYLIB.EMPLOYEE access descriptor for the EMPLOYEES table was created as follows:

proc access dbms=datacom;
 create mylib.employee.access;
  user=demo;
  table=employees;
  assign = yes;
  format hiredate = date7.;
  informat hiredate = date7.;
  content hiredate = yymmdd6.;
  format birthdate = date7.; 
  informat birthdate = date7.;
  content birthdate = yymmdd6.;
  list all; 
  extend all; 
 run;

MYLIB.INVOICE Access Descriptor

The MYLIB.INVOICE access descriptor for the INVOICE table was created as follows:

proc access dbms=datacom;
 create mylib.invoice.access;
  user=demo; 
  table=invoice; 
  assign = yes;
  format billedon = date7.;
  informat billedon = date7.;
  content billedon = yymmdd6.;
  format paidon = date7.;
  informat paidon = date7.;
  content paidon = yymmdd6.;
  list all;
  extend all;
  run;

MYLIB.ORDERS Access Descriptor

The MYLIB.ORDERS access descriptor for the ORDER table was created as follows:

proc access dbms=datacom;
 create mylib.orders.access;
  user=demo; 
  table=order; 
  assign = yes;
  format dateordered = date7.;
  informat dateordered = date7.;
  content dateordered = yymmdd6.;
  format shipped = date7.;
  informat shipped = date7.;
  content shipped = yymmdd6.;
  list all;
  extend all;
  run;

Chapter Contents
Previous
Next
Top of Page