SAS 9.4 Output Delivery System, 4th Edition

quit;

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

Creating the Employee_Data Data Set 1083

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

1084 Appendix 2 • Example Programs