Chapter Contents
Previous
Next
SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Access Descriptors

MYLIB.EMPLOYE Access Descriptor

This section describes the MYLIB.EMPLOYE access descriptor for the EMPLOYEE database used in most of the examples in this manual. This section contains the statements used to create the MYLIB.EMPLOYE access descriptor. You can create the MYLIB.EMPLOYE access descriptor using the following statements in batch or interactive line mode: 

proc access dbms=s2k;
  create mylib.employe.access;
  database=employee s2kpw=demo mode=multi;
  assign=yes;
  rename forename=firstnme office_e=phone
         yearsofe=yearsgender=sex 
         degree_c=degree;
  length firstnme=13 lastname=13 c101=16;
  list all;
run;
Listing of MYLIB.EMPLOYE Access Descriptor contains the LIST output printed to the SAS log.

Listing of MYLIB.EMPLOYE Access Descriptor
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.


Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.