Data and Descriptors for the Examples

Access Descriptors for the CA-Datacom/DB Tables

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;

Top of Page