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;
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. 19MAY52proc 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;
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
(continued)
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 AAproc 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;
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 XT802proc access dbms=s2k ad=mylib.employe;
create vlib.emppos.view;
select lastname firstnme position departme
manager;
subset "order by lastname";
s2kpw=demo mode=s;
list all;
run;
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
(continued)
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 GVHproc 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;
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
(continued)
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
(continued)
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 1proc 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;
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
(continued)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