Smith
. To access the rows that you
want, PROC SQL begins with the first row and reads through all rows
in the table, selecting the rows that satisfy the condition that is
expressed in the WHERE clause.
DateOfBirth
|
DateOfHire
|
EmpID
|
Gender
|
JobCode
|
Salary
|
---|---|---|---|---|---|
16SEP1958
|
07JUN1985
|
1919
|
M
|
TA2
|
$48,126
|
19OCT1962
|
12AUG1988
|
1653
|
F
|
ME2
|
$49,151
|
08NOV1965
|
19OCT1988
|
1400
|
M
|
ME1
|
$41,677
|
04SEP1963
|
01AUG1988
|
1350
|
F
|
FA3
|
$46,040
|
19DEC1948
|
21NOV1983
|
1401
|
M
|
TA3
|
$54,351
|
29APR1952
|
11JUN1978
|
1499
|
M
|
ME3
|
$60,235
|
09JUN1960
|
04OCT1988
|
1101
|
M
|
SCP
|
$26,212
|
03APR1959
|
14FEB1979
|
1333
|
M
|
PT2
|
$124,048
|