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

title 'PROCLIB.PAYLIST2 Table';
select * from proclib.paylist2;
Proclib.Payroll
This data set is updated in “Example 3: Updating Data in a PROC SQL Table” on page
273. Its updated data is used in subsequent examples.
data proclib.payroll;
input IdNumber $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;
1919 M TA2 34376 12SEP60 04JUN87
1653 F ME2 35108 15OCT64 09AUG90
1400 M ME1 29769 05NOV67 16OCT90
1350 F FA3 32886 31AUG65 29JUL90
1401 M TA3 38822 13DEC50 17NOV85
1499 M ME3 43025 26APR54 07JUN80
1101 M SCP 18723 06JUN62 01OCT90
1333 M PT2 88606 30MAR61 10FEB81
1402 M TA2 32615 17JAN63 02DEC90
1479 F TA3 38785 22DEC68 05OCT89
1403 M ME1 28072 28JAN69 21DEC91
1739 M PT1 66517 25DEC64 27JAN91
1658 M SCP 17943 08APR67 29FEB92
1428 F PT1 68767 04APR60 16NOV91
1782 M ME2 35345 04DEC70 22FEB92
1244 M ME2 36925 31AUG63 17JAN88
1383 M BCK 25823 25JAN68 20OCT92
1574 M FA2 28572 27APR60 20DEC92
1789 M SCP 18326 25JAN57 11APR78
1404 M PT2 91376 24FEB53 01JAN80
1437 F FA3 33104 20SEP60 31AUG84
1639 F TA3 40260 26JUN57 28JAN84
1269 M NA1 41690 03MAY72 28NOV92
1065 M ME2 35090 26JAN44 07JAN87
1876 M TA3 39675 20MAY58 27APR85
1037 F TA1 28558 10APR64 13SEP92
1129 F ME2 34929 08DEC61 17AUG91
1988 M FA3 32217 30NOV59 18SEP84
1405 M SCP 18056 05MAR66 26JAN92
1430 F TA2 32925 28FEB62 27APR87
1983 F FA3 33419 28FEB62 27APR87
1134 F TA2 33462 05MAR69 21DEC88
1118 M PT3 111379 16JAN44 18DEC80
1438 F TA3 39223 15MAR65 18NOV87
1125 F FA2 28888 08NOV68 11DEC87
1475 F FA2 27787 15DEC61 13JUL90
1117 M TA3 39771 05JUN63 13AUG92
1935 F NA2 51081 28MAR54 16OCT81
1124 F FA1 23177 10JUL58 01OCT90
Proclib.Payroll 445
1422 F FA1 22454 04JUN64 06APR91
1616 F TA2 34137 01MAR70 04JUN93
1406 M ME2 35185 08MAR61 17FEB87
1120 M ME1 28619 11SEP72 07OCT93
1094 M FA1 22268 02APR70 17APR91
1389 M BCK 25028 15JUL59 18AUG90
1905 M PT1 65111 16APR72 29MAY92
1407 M PT1 68096 23MAR69 18MAR90
1114 F TA2 32928 18SEP69 27JUN87
1410 M PT2 84685 03MAY67 07NOV86
1439 F PT1 70736 06MAR64 10SEP90
1409 M ME3 41551 19APR50 22OCT81
1408 M TA2 34138 29MAR60 14OCT87
1121 M ME1 29112 26SEP71 07DEC91
1991 F TA1 27645 07MAY72 12DEC92
1102 M TA2 34542 01OCT59 15APR91
1356 M ME2 36869 26SEP57 22FEB83
1545 M PT1 66130 12AUG59 29MAY90
1292 F ME2 36691 28OCT64 02JUL89
1440 F ME2 35757 27SEP62 09APR91
1368 M FA2 27808 11JUN61 03NOV84
1369 M TA2 33705 28DEC61 13MAR87
1411 M FA2 27265 27MAY61 01DEC89
1113 F FA1 22367 15JAN68 17OCT91
1704 M BCK 25465 30AUG66 28JUN87
1900 M ME2 35105 25MAY62 27OCT87
1126 F TA3 40899 28MAY63 21NOV80
1677 M BCK 26007 05NOV63 27MAR89
1441 F FA2 27158 19NOV69 23MAR91
1421 M TA2 33155 08JAN59 28FEB90
1119 M TA1 26924 20JUN62 06SEP88
1834 M BCK 26896 08FEB72 02JUL92
1777 M PT3 109630 23SEP51 21JUN81
1663 M BCK 26452 11JAN67 11AUG91
1106 M PT2 89632 06NOV57 16AUG84
1103 F FA1 23738 16FEB68 23JUL92
1477 M FA2 28566 21MAR64 07MAR88
1476 F TA2 34803 30MAY66 17MAR87
1379 M ME3 42264 08AUG61 10JUN84
1104 M SCP 17946 25APR63 10JUN91
1009 M TA1 28880 02MAR59 26MAR92
1412 M ME1 27799 18JUN56 05DEC91
1115 F FA3 32699 22AUG60 29FEB80
1128 F TA2 32777 23MAY65 20OCT90
1442 F PT2 84536 05SEP66 12APR88
1417 M NA2 52270 27JUN64 07MAR89
1478 M PT2 84203 09AUG59 24OCT90
1673 M BCK 25477 27FEB70 15JUL91
1839 F NA1 43433 29NOV70 03JUL93
1347 M TA3 40079 21SEP67 06SEP84
1423 F ME2 35773 14MAY68 19AUG90
1200 F ME1 27816 10JAN71 14AUG92
1970 F FA1 22615 25SEP64 12MAR91
1521 M ME3 41526 12APR63 13JUL88
1354 F SCP 18335 29MAY71 16JUN92
1424 F FA2 28978 04AUG69 11DEC89
446 Appendix 4 Data Sets for Examples in SQL Procedure Reference

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