Example Programs

Access Descriptors

The access descriptor MYLIB.EMPLOYE for the database EMPLOYEE is used in most of the examples in this documentation. You can create the access descriptor MYLIB.EMPLOYE by using the following program in batch or in interactive line mode. The results printed to the SAS log are shown in Listing of Access Descriptor MYLIB.EMPLOYE.

proc access dbms=s2k;
  create mylib.employe.access;
  database=employee 
  s2kpw=demo mode=s;
  assign=yes;
  rename forename=firstnme office_e=phone
         yearsofe=years gender=sex 
         degree_c=degree;
  length firstnme=13 lastname=13 c101=16;
  list all;
run;

Listing of Access Descriptor MYLIB.EMPLOYE

SYSTEM 2000 Database: EMPLOYEE
Function: CREATE  Descriptors- access: EMPLOYE  view:
  Item  C-num SAS Name Len Format       Informat     BY-key
  1     C0    *RECORD*     *RECORD*     *RECORD*
  2     C1    EMPLOYEE     4.0          4.0
  3     C2    LASTNAME 13  $13.         $13.
  4     C3    FIRSTNME 13  $13.         $13.
  5     C4    HIREDATE     DATE7.       DATE7.
  6     C5    BIRTHDAY     DATE7.       DATE7.
  7     C6    SOCIALSE     $11.         $11.
  8     C7    SEX          $6.          $6.
  9     C8    ETHNICOR     $9.          $9.
  10    C9    EMPLOYE0     $9.          $9.
  11    C10   PHONE        $9.          $9.
  12    C11   ACCRUEDV     6.2          6.2
  13    C12   ACCRUEDS     6.2          6.2
  14    C13   SECURITY     3.0          3.0
  15    C14   STREETAD     $20.         $20.
  16    C15   CITY_STA     $15.         $15.
  17    C16   ZIPCODE      $5.          $5.
  18    C100  *RECORD*     *RECORD*     *RECORD*
  19    C101  POSITION     $10.         $10.
  20    C102  DEPARTME     $14.         $14.
  21    C103  MANAGER      $3.          $3.
  22    C104  POSITIO1     $12.         $12.
  23    C105  STARTDAT     DATE7.       DATE7.
  24    C106  ENDDATE      DATE7.       DATE7.
  25    C110  *RECORD*     *RECORD*     *RECORD*
  26    C111  PAYRATE      7.2          7.2
  27    C112  PAYSCHED     $7.          $7.
  28    C113  EFFECTIV     DATE7.       DATE7.
  29    C114  CURRENTD     7.2          7.2
  30    C120  *RECORD*     *RECORD*     *RECORD*
  31    C121  PAYROLLM     DATE7.       DATE7.
  32    C122  REGULARH     6.2          6.2
  33    C123  OVERTIME     6.2          6.2
  34    C124  GROSSPAY     7.2          7.2
  35    C125  FEDERALT     7.2          7.2
  36    C126  NETPAY       7.2          7.2
  37    C130  *RECORD*     *RECORD*     *RECORD*
  38    C131  LINENUMB     4.1          4.1
  39    C132  COMMENTT     $CHAR7.      $CHAR7.
  40    C200  *RECORD*     *RECORD*     *RECORD*
  41    C201  SKILLTYP     $12.         $12.
  42    C202  PROFICIE     $5.          $5.
  43    C203  YEARSOFE     2.0          2.0
  44    C300  *RECORD*     *RECORD*     *RECORD*
  45    C301  INTEREST     $12.         $12.
  46    C302  AFFILIAT     $5.          $5.
  47    C303  COMMENT      $CHAR5.      $CHAR5.
  48    C400  *RECORD*     *RECORD*     *RECORD*
  49    C410  *RECORD*     *RECORD*     *RECORD*
  50    C411  SCHOOL       $15.         $15.
  51    C412  DEGREE       $7.          $7.
  52    C413  DATECOMP     DATE7.       DATE7.
  53    C414  MAJORFIE     $16.         $16.
  54    C415  MINORFIE     $12.         $12.
  55    C420  *RECORD*     *RECORD*     *RECORD*
  56    C421  SOURCE       $12.         $12.
  57    C422  CLASSNAM     $12.         $12.
  58    C423  DATEACCO     DATE7.       DATE7.

Top of Page