Raw Data and DATA Steps |
This data set (table) is updated in Updating Data in a PROC SQL Table and 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 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 1132 F FA1 22413 30MAY72 22OCT93 1845 M BCK 25996 20NOV59 22MAR80 1556 M PT1 71349 22JUN64 11DEC91 1413 M FA2 27435 16SEP65 02JAN90 1123 F TA1 28407 31OCT72 05DEC92 1907 M TA2 33329 15NOV60 06JUL87 1436 F TA2 34475 11JUN64 12MAR87 1385 M ME3 43900 16JAN62 01APR86 1432 F ME2 35327 03NOV61 10FEB85 1111 M NA1 40586 14JUL73 31OCT92 1116 F FA1 22862 28SEP69 21MAR91 1352 M NA2 53798 02DEC60 16OCT86 1555 F FA2 27499 16MAR68 04JUL92 1038 F TA1 26533 09NOV69 23NOV91 1420 M ME3 43071 19FEB65 22JUL87 1561 M TA2 34514 30NOV63 07OCT87 1434 F FA2 28622 11JUL62 28OCT90 1414 M FA1 23644 24MAR72 12APR92 1112 M TA1 26905 29NOV64 07DEC92 1390 M FA2 27761 19FEB65 23JUN91 1332 M NA1 42178 17SEP70 04JUN91 1890 M PT2 91908 20JUL51 25NOV79 1429 F TA1 27939 28FEB60 07AUG92 1107 M PT2 89977 09JUN54 10FEB79 1908 F TA2 32995 10DEC69 23APR90 1830 F PT2 84471 27MAY57 29JAN83 1882 M ME3 41538 10JUL57 21NOV78 1050 M ME2 35167 14JUL63 24AUG86 1425 F FA1 23979 28DEC71 28FEB93 1928 M PT2 89858 16SEP54 13JUL90 1480 F TA3 39583 03SEP57 25MAR81 1100 M BCK 25004 01DEC60 07MAY88 1995 F ME1 28810 24AUG73 19SEP93 1135 F FA2 27321 20SEP60 31MAR90 1415 M FA2 28278 09MAR58 12FEB88 1076 M PT1 66558 14OCT55 03OCT91 1426 F TA2 32991 05DEC66 25JUN90 1564 F SCP 18833 12APR62 01JUL92 1221 F FA2 27896 22SEP67 04OCT91 1133 M TA1 27701 13JUL66 12FEB92 1435 F TA3 38808 12MAY59 08FEB80 1418 M ME1 28005 29MAR57 06JAN92 1017 M TA3 40858 28DEC57 16OCT81 1443 F NA1 42274 17NOV68 29AUG91 1131 F TA2 32575 26DEC71 19APR91 1427 F TA2 34046 31OCT70 30JAN90 1036 F TA3 39392 19MAY65 23OCT84 1130 F FA1 23916 16MAY71 05JUN92 1127 F TA2 33011 09NOV64 07DEC86 1433 F FA3 32982 08JUL66 17JAN87 1431 F FA3 33230 09JUN64 05APR88 1122 F FA2 27956 01MAY63 27NOV88 1105 M ME2 34805 01MAR62 13AUG90 ;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.