Appendix 1: Example Programs

Creating the Employee_data Data Set

 options source pagesize=60 linesize=80 nodate;  data employee_data;     input IdNumber $ 1-4 LastName $ 9-19 FirstName $ 20-29           City $ 30-42 State $ 43-44 /           Gender $ 1 JobCode $ 9-11 Salary 20-29 @30 Birth date9.           @43 Hired date9. HomePhone $ 54-65;     format birth hired date9.;              datalines;  1919    Adams      Gerald    Stamford     CT  M       TA2        34376     15SEP48      07JUN75    203/781-1255  1653    Alexander  Susan     Bridgeport   CT  F       ME2        35108     18OCT52      12AUG78    203/675-7715  1400    Apple      Troy      New York     NY  M       ME1        29769     08NOV55      19OCT78    212/586-0808  1350    Arthur     Barbara   New York     NY  F       FA3        32886     03SEP53      01AUG78    718/383-1549  1401    Avery      Jerry     Paterson     NJ M       TA3        38822     16DEC38      20NOV73    201/732-8787 1499    Barefoot   Joseph    Princeton    NJ M       ME3        43025     29APR42      10JUN68    201/812-5665 1101    Baucom     Walter    New York     NY M       SCP        18723     09JUN50      04OCT78    212/586-8060 1333    Blair      Justin    Stamford     CT M       PT2        88606     02APR49      13FEB69    203/781-1777 1402    Blalock    Ralph     New York     NY M       TA2        32615     20JAN51      05DEC78    718/384-2849 1479    Bostic     Marie     New York     NY F       TA3        38785     25DEC56      08OCT77    718/384-8816 1403    Bowden     Earl      Bridgeport   CT M       ME1        28072     31JAN57      24DEC79    203/675-3434 1739    Boyce      Jonathan  New York     NY M       PT1        66517     28DEC52      30JAN79    212/587-1247 1658    Bradley    Jeremy    New York     NY M       SCP        17943     11APR55      03MAR80    212/587-3622 1428    Brady      Christine Stamford     CT F       PT1        68767     07APR58      19NOV79    203/781-1212 1782    Brown      Jason     Stamford     CT M       ME2        35345     07DEC58      25FEB80    203/781-0019 1244    Bryant     Leonard   New York     NY M       ME2        36925     03SEP51      20JAN76    718/383-3334 1383    Burnette   Thomas    New York     NY M       BCK        25823     28JAN56      23OCT80    718/384-3569 1574    Cahill     Marshall  New York     NY M       FA2        28572     30APR48      23DEC80    718/383-2338 1789    Caraway    Davis     New York     NY M       SCP        18326     28JAN45      14APR66    212/587-9000 1404    Carter     Donald    New York     NY M       PT2        91376     27FEB41      04JAN68    718/384-2946 1437    Carter     Dorothy   Bridgeport   CT F       A3         33104     23SEP48      03SEP72    203/675-4117 1639    Carter     Karen     Stamford     CT F       A3         40260     29JUN45      31JAN72    203/781-8839 1269    Caston     Franklin  Stamford     CT M       NA1        41690     06MAY60      01DEC80    203/781-3335 1065    Chapman    Neil      New York     NY M       ME2        35090     29JAN32      10JAN75    718/384-5618 1876    Chin       Jack      New York     NY M       TA3        39675     23MAY46      30APR73    212/588-5634 1037    Chow       Jane      Stamford     CT F       TA1        28558     13APR52      16SEP80    203/781-8868 1129    Cook       Brenda    New York     NY F       ME2        34929     11DEC49      20AUG79    718/383-2313 1988    Cooper     Anthony   New York     NY M       FA3        32217     03DEC47      21SEP72    212/587-1228 1405    Davidson   Jason     Paterson     NJ M       SCP        18056     08MAR54      29JAN80    201/732-2323 1430    Dean       Sandra    Bridgeport   CT F       TA2        32925     03MAR50      30APR75    203/675-1647 1983    Dean       Sharon    New York     NY F       FA3        33419     03MAR50      30APR75    718/384-1647 1134    Delgado    Maria     Stamford     CT F       TA2        33462     08MAR57      24DEC76    203/781-1528 1118    Dennis     Roger     New York     NY M       PT3        111379    19JAN32      21DEC68    718/383-1122 1438    Donaldson  Karen     Stamford     CT F       TA3        39223     18MAR53      21NOV75    203/781-2229 1125    Dunlap     Donna     New York     NY F       FA2        28888     11NOV56      14DEC75    718/383-2094 1475    Eaton      Alicia    New York     NY F       FA2        27787     18DEC49      16JUL78    718/383-2828 1117    Edgerton   Joshua    New York     NY M       TA3        39771     08JUN51      16AUG80    212/588-1239 1935    Fernandez  Katrina   Bridgeport   CT F       NA2        51081     31MAR42      19OCT69    203/675-2962 1124    Fields     Diana     White Plains NY F       FA1        23177     13JUL46      04OCT78    914/455-2998 1422    Fletcher   Marie     Princeton    NJ F       FA1        22454     07JUN52      09APR79    201/812-0902 1616    Flowers    Annette   New York     NY F       TA2        34137     04MAR58      07JUN81    718/384-3329 1406    Foster     Gerald    Bridgeport   CT M       ME2        35185     11MAR49      20FEB75    203/675-6363 1120    Garcia     Jack      New York     NY M       ME1        28619     14SEP60      10OCT81    718/384-4930 1094    Gomez      Alan      Bridgeport   CT M       FA1        22268     05APR58      20APR79    203/675-7181 1389    Gordon     Levi      New York     NY M       BCK        25028     18JUL47      21AUG78    718/384-9326 1905    Graham     Alvin     New York     NY M       PT1        65111     19APR60      01JUN80    212/586-8815 1407    Grant      Daniel    Mt. Vernon   NY M       PT1        68096     26MAR57      21MAR78    914/468-1616 1114    Green      Janice    New York     NY F       TA2        32928     21SEP57      30JUN75    212/588-1092 ;