Chapter Contents

Previous

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

View Descriptors

This section shows the SAS statements used to create the view descriptors for the EMPLOYEE database used in the examples in this manual. You can create all of the view descriptors used in the manual by using the following PROC ACCESS statements in batch and interactive mode.

All of the view descriptors are based on the MYLIB.EMPLOYE access descriptor shown earlier in this appendix.


VLIB.EMPBD View Descriptor

The VLIB.EMPBD view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
  create vlib.empbd.view;
     select lastname firstnme birthday;
     subset "ob lastname,firstnme";
     s2kpw=demo mode=s;     
     list view;
run;
The VLIB.EMPBD view descriptor accesses the data shown in Data Accessed by VLIB.EMPBD.

Data Accessed by VLIB.EMPBD
                  Data Accessed by VLIB.EMPBD                          1  
 
           OBS    LASTNAME      FIRSTNME      BIRTHDAY
 
             1    AMEER         DAVID         10OCT51
             2    BROOKS        RUBEN R.      25FEB52
             3    BROWN         VIRGINA P.    24MAY46
             4    CHAN          TAI           04JUL46
             5    GARRETT       OLAN M.       23JAN35
             6    GIBSON        GEORGE J.     23APR46
             7    GOODSON       ALAN F.       21JUN50
             8    JUAREZ        ARMANDO       28MAY47
             9    LITTLEJOHN    FANNIE        17MAY54
            10    RICHARDSON    TRAVIS Z.     30NOV37
            11    RODRIGUEZ     ROMUALDO R    09FEB29
            12    SCHOLL        MADISON A.    19MAR45
            13    SHROPSHIRE    LELAND G.     04SEP49
            14    SMITH         JERRY LEE     13SEP42
            15    VAN HOTTEN    GWENDOLYN     13SEP42
            16    WAGGONNER     MERRILEE D    27APR36
            17    WILLIAMSON    JANICE L.     19MAY52


VLIB.EMPEDUC View Descriptor

The VLIB.EMPEDUC view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
  create vlib.empeduc.view;
    select lastname firstnme sex degree;
    subset "ob lastname,firstnme";
    s2kpw=demo mode=s;
    list view;
run;
The VLIB.EMPEDUC view descriptor accesses the data shown in Data Accessed by VLIB.EMPEDUC.

Data Accessed by VLIB.EMPEDUC
                  Data Accessed by VLIB.EMPEDUC                        1
 
       OBS    LASTNAME      FIRSTNME        SEX       DEGREE
 
         1
         2    AMEER         DAVID           MALE      BS
         3    BOWMAN        HUGH E.         MALE      MS
         4    BOWMAN        HUGH E.         MALE      PHD
         5    BOWMAN        HUGH E.         MALE      BS
         6    BROOKS        RUBEN R.        MALE      BS
         7    BROWN         VIRGINA P.      FEMALE    BA
         8    CAHILL        JACOB           MALE      BS
         9    CAHILL        JACOB           MALE      BS
        10    CANADY        FRANK A.        MALE      MA
        11    CANADY        FRANK A.        MALE      BS
        12    CHAN          TAI             MALE      PHD
        13    CHAN          TAI             MALE      BA
        14    COLLINS       LILLIAN         FEMALE    HIGH SC
        15    FAULKNER      CARRIE ANN      FEMALE
        16    FERNANDEZ     SOPHIA          FEMALE    BS
        17    FERNANDEZ     SOPHIA          FEMALE    MS
        18    FREEMAN       LEOPOLD         MALE      BS
        19    FREEMAN       LEOPOLD         MALE      BS
        20    GARCIA        FRANCISCO       MALE      MBA
        21    GARCIA        FRANCISCO       MALE      BS
        22    GARRETT       OLAN M.         MALE      MS
        23    GARRETT       OLAN M.         MALE      BS
        24    GIBSON        MOLLY I.        FEMALE    BA
        25    GIBSON        GEORGE J.       MALE      BA
        26    GIBSON        GEORGE J.       MALE      MS
        27    GIBSON        GEORGE J.       MALE      MS
        28    GOODSON       ALAN F.         MALE      BA
        29    HERNANDEZ     JESSE L.        MALE      PHD
        30    HERNANDEZ     JESSE L.        MALE      MA
        31    HERNANDEZ     JESSE L.        MALE      BS
        32    HERNANDEZ     JESSE L.        MALE      BA
        33    JOHNSON       BRADFORD        MALE
        34    JONES         MICHAEL Y.      MALE      BS
        35    JONES         MICHAEL Y.      MALE
        36    JONES         RITA M.         FEMALE
        37    JUAREZ        ARMANDO         MALE      MS
        38    JUAREZ        ARMANDO         MALE      BS
        39    KAATZ         FREDDIE         MALE      HIGH SC
        40    KNAPP         PATRICE R.      FEMALE    BA
        41    KNIGHT        ALTHEA          FEMALE
        42    LITTLEJOHN    FANNIE          FEMALE    HIGH SC
        43    MILLSAP       JOEL B.         MALE      PHD
        44    MUELLER       PATSY           FEMALE    HIGH SC
        45    NATHANIEL     DARRYL          MALE      AA
        46    POLANSKI      IVAN L.         MALE      BS
        47    POLANSKI      IVAN L.         MALE      BS
        48    POLANSKI      IVAN L.         MALE      MS
        49    QUINTERO      PEDRO           MALE      BS
        50    QUINTERO      PEDRO           MALE
        51    REDFOX        RICHARD B.      MALE      BS
        52    REED          KENNETH D.      MALE
        53    REID          DAVID G.        MALE      BS
        54    RICHARDSON    TRAVIS Z.       MALE      BS
        55    RODRIGUEZ     ROMUALDO R      MALE      BS
        56    SALAZAR       YOLANDA         FEMALE    AA
        57    SAVAGE        WILLIAM D.      MALE
        58    SCHMIDT       PENNY           FEMALE    HIGH SC
        59    SCHOLL        MADISON A.      MALE      MS
        60    SCHOLL        MADISON A.      MALE      BS
        61    SEATON        GARY            MALE
        62    SHROPSHIRE    LELAND G.       MALE      BA
        63    SLYE          LEONARD R.      MALE      HIGH SC
        64    SMITH         JERRY LEE       MALE      MA
        65    SMITH         JERRY LEE       MALE      BA
        66    SMITH         GARLAND P.      MALE      AA
        67    SMITH         JANET F.        FEMALE    BA
        68    THROCKMORT    STEWART Q.      MALE      BS
        69    THROCKMORT    STEWART Q.      MALE      MS
        70    VAN HOTTEN    GWENDOLYN       FEMALE    BA
        71    WAGGONNER     MERRILEE D      FEMALE    AA
        72    WATERHOUSE    CLIFTON P.      MALE
        73    WATERHOUSE    CLIFTON P.      MALE
        74    WILLIAMSON    JANICE L.       FEMALE    BA
        75    WILLIAMSON    JANICE L.       FEMALE    AA


VLIB.EMPPHON View Descriptor

The VLIB.EMPPHON view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
  create vlib.empphon.view;
    select lastname firstnme phone;
    subset "ob lastname,firstnme";
    s2kpw=demo mode=s;
    list view;
run;
The VLIB.EMPPHON view descriptor accesses the data shown in Data Accessed by VLIB.EMPPHON.

Data Accessed by VLIB.EMPPHON
                   Data Accessed by VLIB.EMPPHON                          1
 
           OBS    LASTNAME      FIRSTNME       PHONE
 
             1    AMEER         DAVID          545 XT495
             2    BROOKS        RUBEN R.       581 XT347
             3    BROWN         VIRGINA P.     218 XT258
             4    CHAN          TAI            292 XT331
             5    GARRETT       OLAN M.        212 XT208
             6    GIBSON        GEORGE J.      327 XT703
             7    GOODSON       ALAN F.        323 XT512
             8    JUAREZ        ARMANDO        506 XT987
             9    LITTLEJOHN    FANNIE         219 XT653
            10    RICHARDSON    TRAVIS Z.      243 XT325
            11    RODRIGUEZ     ROMUALDO R     243 XT874
            12    SCHOLL        MADISON A.     318 XT419
            13    SHROPSHIRE    LELAND G.      327 XT616
            14    SMITH         JERRY LEE      327 XT169
            15    VAN HOTTEN    GWENDOLYN      212 XT311
            16    WAGGONNER     MERRILEE D     244 XT914
            17    WILLIAMSON    JANICE L.      218 XT802


VLIB.EMPPOS View Descriptor

The VLIB.EMPPOS view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
 create vlib.emppos.view;
    select lastname firstnme position departme
      manager;
    subset "order by lastname";
    list all;
run;
  
The VLIB.EMPPOS view descriptor accesses the data shown in Data Accessed by VLIB.EMPPOS.

Data Accessed by VLIB.EMPPOS
                         Data Accessed by VLIB.EMPPOS                      1
 
   OBS  LASTNAME    FIRSTNME      POSITION          DEPARTME        MANAGER
 
     1                            PROGRAMMER        INFORMATION SY    MYJ
     2  AMEER       DAVID         SR SALES REPRESE  MARKETING         VPB
     3  AMEER       DAVID         JR SALES REPRESE  MARKETING         VPB
     4  BOWMAN      HUGH E.       EXECUTIVE VICE-P  CORPORATION       CPW
     5  BROOKS      RUBEN R.      JR SALES REPRESE  MARKETING         MAS
     6  BROWN       VIRGINA P.    MANAGER WESTERN   MARKETING         OMG
     7  CAHILL      JACOB         MANAGER SYSTEMS   INFORMATION SY    JBM
     8  CANADY      FRANK A.      MANAGER PERSONNE  ADMINISTRATION    PRK
     9  CHAN        TAI           SR SALES REPRESE  MARKETING         TZR
    10  COLLINS     LILLIAN       MAIL CLERK        ADMINISTRATION    SQT
    11  FAULKNER    CARRIE ANN    SECRETARY         CORPORATION       JBM
    12  FERNANDEZ   SOPHIA        STANDARDS & PROC  INFORMATION SY    JLH
    13  FREEMAN     LEOPOLD       SR SYSTEMS PROGR  INFORMATION SY    JLH
    14  GARCIA      FRANCISCO     JR PROGRAMMER/AN  INFORMATION SY    MYJ
    15  GARRETT     OLAN M.       SR SALES REPRESE  MARKETING         VPB
    16  GARRETT     OLAN M.       MANAGER OF SALES  MARKETING         HEB
    17  GARRETT     OLAN M.       VICE-PRESIDENT M  CORPORATION       HEB
    18  GIBSON      MOLLY I.      TECHNICAL WRITER  INFORMATION SY    JC
    19  GIBSON      GEORGE J.     INSTRUCTOR        MARKETING         GVH
    20  GOODSON     ALAN F.       SR SALES REPRESE  MARKETING         TZR
    21  HERNANDEZ   JESSE L.      MANAGER DATA BAS  INFORMATION SY    JBM
    22  JOHNSON     BRADFORD      JR SYSTEMS PROGR  INFORMATION SY    JFS
    23  JONES       RITA M.       MANAGER ACCOUNTI  ADMINISTRATION    PRK
    24  JONES       MICHAEL Y.    SR SYSTEMS ANALY  INFORMATION SY    JC
    25  JUAREZ      ARMANDO       SR SALES REPRESE  MARKETING         VPB
    26  JUAREZ      ARMANDO       JR SALES REPRESE  MARKETING         VPB
    27  KAATZ       FREDDIE       SUPPLY CLERK      ADMINISTRATION    SQT
    28  KNAPP       PATRICE R.    VICE-PRESIDENT A  CORPORATION       HEB
    29  KNIGHT      ALTHEA        SECRETARY         CORPORATION       OMG
    30  LITTLEJOHN  FANNIE        SECRETARY         MARKETING         VPB
    31  MILLSAP     JOEL B.       VICE-PRESIDENT I  CORPORATION       HEB
    32  MUELLER     PATSY         SECRETARY         CORPORATION       PRK
    33  NATHANIEL   DARRYL        SECRETARY         CORPORATION       HEB
    34  POLANSKI    IVAN L.       MANAGER SYSTEMS   INFORMATION SY    JBM
    35  QUINTERO    PEDRO         OPERATIONS SUPER  INFORMATION SY    ILP
    36  REDFOX      RICHARD B.    SYSTEMS ANALYST   INFORMATION SY    JC
    37  REED        KENNETH D.    COMPUTER LIBRARI  INFORMATION SY    PQ
    38  REID        DAVID G.      PROGRAMMER        INFORMATION SY    MYJ
    39  REID        DAVID G.      ASSISTANT PROGRA  INFORMATION SY    MYJ
    40  RICHARDSON  TRAVIS Z.     MANAGER EASTERN   MARKETING         OMG
    41  RODRIGUEZ   ROMUALDO R.   PR & ADVERTISING  MARKETING         GVH
    42  SALAZAR     YOLANDA       ADMINISTRATIVE A  CORPORATION       CPW
    43  SALAZAR     YOLANDA       SECRETARY         CORPORATION       CPW
    44  SAVAGE      WILLIAM D.    COMPUTER OPERATO  INFORMATION SY    PQ
    45  SCHMIDT     PENNY         SECRETARY         ADMINISTRATION    FAC
    46  SCHOLL      MADISON A.    JR SALES REPRESE  MARKETING         VPB
    47  SCHOLL      MADISON A.    SR SALES REPRESE  MARKETING         VPB
    48  SEATON      GARY          COMPUTER OPERATO  INFORMATION SY    PQ
    49  SHROPSHIRE  LELAND G.     JR SALES REPRESE  MARKETING         TZR
    50  SLYE        LEONARD R.    GENERAL MAINTENA  ADMINISTRATION    SQT
    51  SMITH       JANET F.      SR SYSTEMS PROGR  INFORMATION SY    ILP
    52  SMITH       JERRY LEE     JR SALES REPRESE  MARKETING         AFG
    53  SMITH       GARLAND P.    BOOKKEEPER        ADMINISTRATION    RMJ
    54  THROCKMORT  STEWART Q.    OFFICE SUPERVISO  ADMINISTRATION    FAC
    55  VAN HOTTEN  GWENDOLYN     MANAGER PUBLIC R  MARKETING         OMG
    56  WAGGONNER   MERRILEE D.   SECRETARY         MARKETING         TZR
    57  WATERHOUSE  CLIFTON P.    PRESIDENT         CORPORATION
    58  WILLIAMSON  JANICE L.     INSTRUCTOR        MARKETING         GVH


VLIB.EMPSKIL View Descriptor

The VLIB.EMPSKIL view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
   create vlib.empskil.view;
      select c2 c3 c201 c203;
      subset "ob skilltyp";
      s2kpw=demo mode=multi;
      list view;
run;
The VLIB.EMPSKIL view descriptor accesses the data shown in Data Accessed by VLIB.EMPSKIL.

Data Accessed by VLIB.EMPSKIL
                   Data Accessed by VLIB.EMPSKIL                          1
 
   OBS    LASTNAME      FIRSTNME         SKILLTYP           YEARS
 
     1                                                          .
     2    AMEER         DAVID            PASCAL                 3
     3    BOWMAN        HUGH E.          DP SYSTEMS A          11
     4    BOWMAN        HUGH E.          RUSSIAN               15
     5    BOWMAN        HUGH E.          TEACHING               7
     6    BOWMAN        HUGH E.          PUBLIC RELAT          13
     7    BROOKS        RUBEN R.         PASCAL                 4
     8    BROOKS        RUBEN R.         PUBLIC RELAT           1
     9    BROWN         VIRGINA P.       SYSTEMS PROG           2
    10    BROWN         VIRGINA P.       PUBLIC RELAT           8
    11    BROWN         VIRGINA P.       ASSEMBLER              3
    12    BROWN         VIRGINA P.       FRENCH                11
    13    CAHILL        JACOB            TECHNICAL WR          10
    14    CAHILL        JACOB            ASSEMBLER             11
    15    CAHILL        JACOB            COBOL                 11
    16    CAHILL        JACOB            SYSTEMS PROG          16
    17    CANADY        FRANK A.         ACCOUNTING            15
    18    CANADY        FRANK A.         COBOL                  4
    19    CANADY        FRANK A.         TYPING                20
    20    CHAN          TAI              SYSTEMS PROG           6
    21    CHAN          TAI              CHINESE                8
    22    COLLINS       LILLIAN          TYPING                 2
    23    COLLINS       LILLIAN          SHORTHAND              1
    24    FAULKNER      CARRIE ANN       GRAPHICS               1
    25    FAULKNER      CARRIE ANN       SHORTHAND              5
    26    FAULKNER      CARRIE ANN       TYPING                 6
    27    FERNANDEZ     SOPHIA           SYSTEMS PROG           6
    28    FERNANDEZ     SOPHIA           DATA BASE AD           3
    29    FERNANDEZ     SOPHIA           SYSTEMS ANAL          12
    30    FERNANDEZ     SOPHIA           PL/1                   2
    31    FERNANDEZ     SOPHIA           PASCAL                 1
    32    FERNANDEZ     SOPHIA           COBOL                  4
    33    FERNANDEZ     SOPHIA           FORTRAN                5
    34    FERNANDEZ     SOPHIA           ASSEMBLER              8
    35    FREEMAN       LEOPOLD          COBOL                 20
    36    FREEMAN       LEOPOLD          JAPANESE               3
    37    FREEMAN       LEOPOLD          SYSTEMS PROG          20
    38    FREEMAN       LEOPOLD          DATA BASE AD           6
    39    FREEMAN       LEOPOLD          ASSEMBLER             20
    40    GARCIA        FRANCISCO        COBOL                  3
    41    GARCIA        FRANCISCO        PASCAL                 3
    42    GARCIA        FRANCISCO        FORTRAN                3
    43    GARRETT       OLAN M.          PUBLIC SPEAK          20
    44    GARRETT       OLAN M.          PUBLIC RELAT           8
    45    GARRETT       OLAN M.          WRITING               13
    46    GARRETT       OLAN M.          FINANCIAL AU           7
    47    GIBSON        MOLLY I.         GRAPHICS               3
    48    GIBSON        MOLLY I.         CARTOON ART            1
    49    GIBSON        GEORGE J.        PUBLIC SPEAK          15
    50    GIBSON        GEORGE J.        TEACHING              10
    51    GIBSON        GEORGE J.        SYSTEMS ANAL           8
    52    GOODSON       ALAN F.          PASCAL                 1
    53    HERNANDEZ     JESSE L.         ASSEMBLER             24
    54    HERNANDEZ     JESSE L.         SYSTEMS PROG          25
    55    HERNANDEZ     JESSE L.         SYSTEMS ANAL          17
    56    HERNANDEZ     JESSE L.         DATA BASE AD          10
    57    HERNANDEZ     JESSE L.         FORTRAN               19
    58    HERNANDEZ     JESSE L.         SPANISH               46
    59    JOHNSON       BRADFORD         SYSTEMS PROG           3
    60    JONES         MICHAEL Y.       PL/1                  10
    61    JONES         MICHAEL Y.       ASSEMBLER             17
    62    JONES         MICHAEL Y.       COBOL                 21
    63    JONES         MICHAEL Y.       SYSTEMS PROG          11
    64    JONES         MICHAEL Y.       PASCAL                 3
    65    JONES         MICHAEL Y.       GERMAN                 7
    66    JONES         MICHAEL Y.       TECHNICAL WR           4
    67    JONES         RITA M.                                 .
    68    JUAREZ        ARMANDO          ASSEMBLER              7
    69    KAATZ         FREDDIE                                 .
    70    KNAPP         PATRICE R.       CPA                   14
    71    KNAPP         PATRICE R.       WRITING                3
    72    KNIGHT        ALTHEA           GERMAN                 3
    73    KNIGHT        ALTHEA           ACCOUNTING             2
    74    KNIGHT        ALTHEA           SHORTHAND              8
    75    KNIGHT        ALTHEA           TYPING                 8
    76    KNIGHT        ALTHEA           ETS OPERATOR           1
    77    LITTLEJOHN    FANNIE           SHORTHAND              4
    78    LITTLEJOHN    FANNIE           GRAPHICS               3
    79    LITTLEJOHN    FANNIE           TYPING                 4
    80    MILLSAP       JOEL B.          SYSTEMS ANAL          17
    81    MILLSAP       JOEL B.          HEBREW                 4
    82    MILLSAP       JOEL B.          SYSTEMS PROG          15
    83    MILLSAP       JOEL B.          FORTRAN               13
    84    MILLSAP       JOEL B.          ASSEMBLER             14
    85    MUELLER       PATSY            TYPING                 6
    86    MUELLER       PATSY            SHORTHAND              5
    87    MUELLER       PATSY            ACCOUNTING             5
    88    NATHANIEL     DARRYL           ACCOUNTING             9
    89    NATHANIEL     DARRYL           TYPING                 9
    90    NATHANIEL     DARRYL           SHORTHAND              7
    91    NATHANIEL     DARRYL           PUBLIC RELAT           3
    92    POLANSKI      IVAN L.          RUSSIAN                3
    93    POLANSKI      IVAN L.          ASSEMBLER              7
    94    POLANSKI      IVAN L.          OPERATIONS R          10
    95    POLANSKI      IVAN L.          SYSTEMS PROG          10
    96    QUINTERO      PEDRO            OPERATIONS R           4
    97    QUINTERO      PEDRO            SYSTEMS PROG           5
    98    QUINTERO      PEDRO            ASSEMBLER              3
    99    REDFOX        RICHARD B.       SYSTEMS PROG          10
   100    REDFOX        RICHARD B.       ASSEMBLER             15
   101    REDFOX        RICHARD B.       SYSTEMS ANAL          12
   102    REDFOX        RICHARD B.       FORTRAN                9
   103    REED          KENNETH D.       LIBRARY SCIE           1
   104    REID          DAVID G.         FORTRAN                1
   105    REID          DAVID G.         PL/1                   5
   106    REID          DAVID G.         COBOL                  1
   107    RICHARDSON    TRAVIS Z.        JAPANESE               7
   108    RODRIGUEZ     ROMUALDO R       GRAPHICS              20
   109    RODRIGUEZ     ROMUALDO R       VISUAL DESIG          22
   110    SALAZAR       YOLANDA          SHORTHAND             10
   111    SALAZAR       YOLANDA          ACCOUNTING             4
   112    SALAZAR       YOLANDA          TYPING                13
   113    SAVAGE        WILLIAM D.       COBOL                  4
   114    SCHMIDT       PENNY            SHORTHAND             12
   115    SCHMIDT       PENNY            TYPING                23
   116    SCHMIDT       PENNY            ETS OPERATOR           3
   117    SCHOLL        MADISON A.       SYSTEMS ANAL           9
   118    SCHOLL        MADISON A.       FORTRAN                7
   119    SEATON        GARY                                    .
   120    SHROPSHIRE    LELAND G.        PUBLIC SPEAK           6
   121    SLYE          LEONARD R.       PRINT SHOP             0
   122    SMITH         JERRY LEE        SYSTEMS DESI           3
   123    SMITH         JANET F.         SYSTEMS PROG           8
   124    SMITH         JANET F.         ASSEMBLER              7
   125    SMITH         JANET F.         COBOL                  4
   126    SMITH         GARLAND P.                              .
   127    THROCKMORT    STEWART Q.                              .
   128    VAN HOTTEN    GWENDOLYN        TYPING                12
   129    VAN HOTTEN    GWENDOLYN        GRAPHICS               8
   130    VAN HOTTEN    GWENDOLYN        TECHNICAL WR           4
   131    VAN HOTTEN    GWENDOLYN        SHORTHAND              1
   132    VAN HOTTEN    GWENDOLYN        PUBLIC SPEAK           9
   133    WAGGONNER     MERRILEE D       TYPING                19
   134    WAGGONNER     MERRILEE D       SHORTHAND             15
   135    WATERHOUSE    CLIFTON P.       COBOL                 10
   136    WATERHOUSE    CLIFTON P.       FRENCH                21
   137    WATERHOUSE    CLIFTON P.       PUBLIC RELAT          19
   138    WATERHOUSE    CLIFTON P.       SYSTEMS ANAL          21
   139    WATERHOUSE    CLIFTON P.       PUBLIC SPEAK          12
   140    WATERHOUSE    CLIFTON P.       ACCOUNTING            12
   141    WATERHOUSE    CLIFTON P.       ASSEMBLER              4
   142    WILLIAMSON    JANICE L.        COBOL                  2
   143    WILLIAMSON    JANICE L.        ASSEMBLER              1
   144    WILLIAMSON    JANICE L.        COBOL                  4
   145    WILLIAMSON    JANICE L.        TECHNICAL WR           2
   146    WILLIAMSON    JANICE L.        TEACHING               1


VLIB.EMPVAC View Descriptor

The VLIB.EMPVAC view descriptor was created as follows:

proc access dbms=s2k ad=mylib.employe;
  create vlib.empvac.view;
    select lastname firstnme accruedv departme;
    subset "ob lastname,firstnme";
    s2kpw=demo mode=s;
    list view;
run;
The VLIB.EMPVAC view descriptor accesses the data shown in Data Accessed by VLIB.EMPVAC.

Data Accessed by VLIB.EMPVAC
                    Data Accessed by VLIB.EMPVAC                           1
 
  OBS    LASTNAME      FIRSTNME        ACCRUEDV    DEPARTME
 
    1                                              INFORMATION SY
    2    AMEER         DAVID              56.00    MARKETING
    3    AMEER         DAVID              56.00    MARKETING
    4    BOWMAN        HUGH E.            40.00    CORPORATION
    5    BROOKS        RUBEN R.           80.00    MARKETING
    6    BROWN         VIRGINA P.         48.00    MARKETING
    7    CAHILL        JACOB              60.00    INFORMATION SY
    8    CANADY        FRANK A.            8.00    ADMINISTRATION
    9    CHAN          TAI                40.00    MARKETING
   10    COLLINS       LILLIAN            80.00    ADMINISTRATION
   11    FAULKNER      CARRIE ANN         48.00    CORPORATION
   12    FERNANDEZ     SOPHIA             96.00    INFORMATION SY
   13    FREEMAN       LEOPOLD              .      INFORMATION SY
   14    GARCIA        FRANCISCO          80.00    INFORMATION SY
   15    GARRETT       OLAN M.            80.00    MARKETING
   16    GARRETT       OLAN M.            80.00    CORPORATION
   17    GARRETT       OLAN M.            80.00    MARKETING
   18    GIBSON        GEORGE J.          80.00    MARKETING
   19    GIBSON        MOLLY I.           40.00    INFORMATION SY
   20    GOODSON       ALAN F.            48.00    MARKETING
   21    HERNANDEZ     JESSE L.           56.00    INFORMATION SY
   22    JOHNSON       BRADFORD           40.00    INFORMATION SY
   23    JONES         RITA M.            24.00    ADMINISTRATION
   24    JONES         MICHAEL Y.         80.00    INFORMATION SY
   25    JUAREZ        ARMANDO            48.00    MARKETING
   26    JUAREZ        ARMANDO            48.00    MARKETING
   27    KAATZ         FREDDIE            80.00    ADMINISTRATION
   28    KNAPP         PATRICE R.          8.00    CORPORATION
   29    KNIGHT        ALTHEA              0.00    CORPORATION
   30    LITTLEJOHN    FANNIE              8.00    MARKETING
   31    MILLSAP       JOEL B.            24.00    CORPORATION
   32    MUELLER       PATSY              40.00    CORPORATION
   33    NATHANIEL     DARRYL             40.00    CORPORATION
   34    POLANSKI      IVAN L.            56.00    INFORMATION SY
   35    QUINTERO      PEDRO              32.00    INFORMATION SY
   36    REDFOX        RICHARD B.         48.00    INFORMATION SY
   37    REED          KENNETH D.         64.00    INFORMATION SY
   38    REID          DAVID G.           80.00    INFORMATION SY
   39    REID          DAVID G.           80.00    INFORMATION SY
   40    RICHARDSON    TRAVIS Z.          88.00    MARKETING
   41    RODRIGUEZ     ROMUALDO R         32.00    MARKETING
   42    SALAZAR       YOLANDA            80.00    CORPORATION
   43    SALAZAR       YOLANDA            80.00    CORPORATION
   44    SAVAGE        WILLIAM D.         80.00    INFORMATION SY
   45    SCHMIDT       PENNY              80.00    ADMINISTRATION
   46    SCHOLL        MADISON A.         40.00    MARKETING
   47    SCHOLL        MADISON A.         40.00    MARKETING
   48    SEATON        GARY               80.00    INFORMATION SY
   49    SHROPSHIRE    LELAND G.          32.00    MARKETING
   50    SLYE          LEONARD R.          0.00    ADMINISTRATION
   51    SMITH         JANET F.           16.00    INFORMATION SY
   52    SMITH         JERRY LEE           0.00    MARKETING
   53    SMITH         GARLAND P.          8.00    ADMINISTRATION
   54    THROCKMORT    STEWART Q.         64.00    ADMINISTRATION
   55    VAN HOTTEN    GWENDOLYN           0.00    MARKETING
   56    WAGGONNER     MERRILEE D         56.00    MARKETING
   57    WATERHOUSE    CLIFTON P.          8.00    CORPORATION
   58    WILLIAMSON    JANICE L.          40.00    MARKETING


Chapter Contents

Previous

Next

Top of Page

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