O'Reilly logo

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Proclib.Payroll2
data proclib.payroll2;
input idnum $4. +3 gender $1. +4 jobcode $3. +9 salary 5.
+2 birth date7. +2 hired date7.;
informat birth date7. hired date7.;
format birth date7. hired date7.;
datalines;
1639 F TA3 42260 26JUN57 28JAN84
1065 M ME3 38090 26JAN44 07JAN87
1561 M TA3 36514 30NOV63 07OCT87
1221 F FA3 29896 22SEP67 04OCT91
1447 F FA1 22123 07AUG72 29OCT92
1998 M SCP 23100 10SEP70 02NOV92
1036 F TA3 42465 19MAY65 23OCT84
1106 M PT3 94039 06NOV57 16AUG84
1129 F ME3 36758 08DEC61 17AUG91
1350 F FA3 36098 31AUG65 29JUL90
1369 M TA3 36598 28DEC61 13MAR87
1076 M PT1 69742 14OCT55 03OCT91
;
Proclib.Schedule2
data proclib.schedule2;
input flight $3. +5 date date7. +2 dest $3. +3 idnum $4.;
format date date7.;
informat date date7.;
datalines;
132 01MAR94 BOS 1118
132 01MAR94 BOS 1402
219 02MAR94 PAR 1616
219 02MAR94 PAR 1478
622 03MAR94 LON 1430
622 03MAR94 LON 1882
271 04MAR94 NYC 1430
271 04MAR94 NYC 1118
579 05MAR94 RDU 1126
579 05MAR94 RDU 1106
;
Proclib.Staff
data proclib.staff;
input idnum $4. +3 lname $15. +2 fname $15. +2 city $15. +2
448 Appendix 4 Data Sets for Examples in SQL Procedure Reference
state $2. +5 hphone $12.;
datalines;
1919 ADAMS GERALD STAMFORD CT 203/781-1255
1653 ALIBRANDI MARIA BRIDGEPORT CT 203/675-7715
1400 ALHERTANI ABDULLAH NEW YORK NY 212/586-0808
1350 ALVAREZ MERCEDES NEW YORK NY 718/383-1549
1401 ALVAREZ CARLOS PATERSON NJ 201/732-8787
1499 BAREFOOT JOSEPH PRINCETON NJ 201/812-5665
1101 BAUCOM WALTER NEW YORK NY 212/586-8060
1333 BANADYGA JUSTIN STAMFORD CT 203/781-1777
1402 BLALOCK RALPH NEW YORK NY 718/384-2849
1479 BALLETTI MARIE NEW YORK NY 718/384-8816
1403 BOWDEN EARL BRIDGEPORT CT 203/675-3434
1739 BRANCACCIO JOSEPH NEW YORK NY 212/587-1247
1658 BREUHAUS JEREMY NEW YORK NY 212/587-3622
1428 BRADY CHRISTINE STAMFORD CT 203/781-1212
1782 BREWCZAK JAKOB STAMFORD CT 203/781-0019
1244 BUCCI ANTHONY NEW YORK NY 718/383-3334
1383 BURNETTE THOMAS NEW YORK NY 718/384-3569
1574 CAHILL MARSHALL NEW YORK NY 718/383-2338
1789 CARAWAY DAVIS NEW YORK NY 212/587-9000
1404 COHEN LEE NEW YORK NY 718/384-2946
1437 CARTER DOROTHY BRIDGEPORT CT 203/675-4117
1639 CARTER-COHEN KAREN STAMFORD CT 203/781-8839
1269 CASTON FRANKLIN STAMFORD CT 203/781-3335
1065 COPAS FREDERICO NEW YORK NY 718/384-5618
1876 CHIN JACK NEW YORK NY 212/588-5634
1037 CHOW JANE STAMFORD CT 203/781-8868
1129 COUNIHAN BRENDA NEW YORK NY 718/383-2313
1988 COOPER ANTHONY NEW YORK NY 212/587-1228
1405 DACKO JASON PATERSON NJ 201/732-2323
1430 DABROWSKI SANDRA BRIDGEPORT CT 203/675-1647
1983 DEAN SHARON NEW YORK NY 718/384-1647
1134 DELGADO MARIA STAMFORD CT 203/781-1528
1118 DENNIS ROGER NEW YORK NY 718/383-1122
1438 DABBOUSSI KAMILLA STAMFORD CT 203/781-2229
1125 DUNLAP DONNA NEW YORK NY 718/383-2094
1475 ELGES MARGARETE NEW YORK NY 718/383-2828
1117 EDGERTON JOSHUA NEW YORK NY 212/588-1239
1935 FERNANDEZ KATRINA BRIDGEPORT CT 203/675-2962
1124 FIELDS DIANA WHITE PLAINS NY 914/455-2998
1422 FUJIHARA KYOKO PRINCETON NJ 201/812-0902
1616 FUENTAS CARLA NEW YORK NY 718/384-3329
1406 FOSTER GERALD BRIDGEPORT CT 203/675-6363
1120 GARCIA JACK NEW YORK NY 718/384-4930
1094 GOMEZ ALAN BRIDGEPORT CT 203/675-7181
1389 GOLDSTEIN LEVI NEW YORK NY 718/384-9326
1905 GRAHAM ALVIN NEW YORK NY 212/586-8815
1407 GREGORSKI DANIEL MT. VERNON NY 914/468-1616
1114 GREENWALD JANICE NEW YORK NY 212/588-1092
1410 HARRIS CHARLES STAMFORD CT 203/781-0937
1439 HASENHAUER CHRISTINA BRIDGEPORT CT 203/675-4987
1409 HAVELKA RAYMOND STAMFORD CT 203/781-9697
1408 HENDERSON WILLIAM PRINCETON NJ 201/812-4789
1121 HERNANDEZ ROBERTO NEW YORK NY 718/384-3313
1991 HOWARD GRETCHEN BRIDGEPORT CT 203/675-0007
Proclib.Staff 449

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required