Proc Format; value edu 1 = "High School" 2 = "Bachelor Degree" 3 = "Master Degree" 4 = "Doctoral"; Run; Data Customer; Infile Datalines dlm = ","; Length CustID $8. First Last $20. Gender $6. DOB 8. Postal $6. Edu 8. Occup $30. Income 8. Status $10.; Informat DOB DOS yymmdd10.; Format DOB DOS yymmdd10. Edu Edu.; Input CustID $ First $ Last $ Gender $ DOB Postal $ Edu Occup $ Income Status $ NumKids Spend DOS; Datalines; 80050123,Watson,Walls,Female,1999-01-23,M7V5D8,3,Tax inspector,92000,Single,0,2009,2015-01-01 80050124,Adkins,Dunn,Female,1969-03-01,N8G4F8,3,Publican,111000,Married,1,5272.6,2015-01-01 80050125,Cuevas,Gonzalez,Female,1981-10-01,K6E5E2,3,Crown prosecutor,90000,Divorced,0,5100.4,2015-01-01 80050126,Benson,Henderson,Female,1997-02-14,N2Y7L6,1,Shop assistant,71000,Married,2,1533.4,2015-01-01 80050127,Cuevas,Atkins,Male,1971-11-13,L7Q3H4,2,Minister,69000,Single,0,5502.2,2015-01-01 80050128,Arias,Estes,Male,1978-01-02,N3R3A4,1,Photographer,85000,Single,0,5953.2,2015-01-01 80050129,Hodges,Hatfield,Female,1980-06-07,K7W4Z2,2,Undertaker,54000,Single,0,1139.8,2015-01-01 80050130,Trevino,Liu,Male,1992-01-15,K3S2C4,2,Producer,62000,Married,2,3854,2015-01-01 80050131,Bowman,Rowe,Female,2000-11-03,N7R2D1,1,Pathologist,77000,Single,0,4411.6,2015-01-01 80050132,Delacruz,Reid,Male,1995-12-27,K4M3V1,1,Designer,35000,Married,0,2591.2,2015-01-01 80050133,Farrell,Randolph,Male,1970-02-01,M3O7X3,1,Stockbroker,65000,Married,0,5051.2,2015-01-01 80050134,Gilbert,Carpenter,Male,1984-02-29,N6B1D8,2,Engineer,68000,Single,0,2082.8,2015-01-01 80050135,Mathews,Petersen,Male,1979-08-19,N6R4W4,4,Caretaker,47000,Single,0,3788.4,2015-01-01 80050136,Rocha,Macdonald,Male,1985-12-18,L7D3G1,2,Conservationist,86000,Single,0,2943.8,2015-01-01 80050137,Golden,Evans,Female,1981-05-18,N3I2L1,3,Sailor,44000,Divorced,0,3419.4,2015-01-01 80050138,Calderon,Edwards,Female,1981-11-28,L1D2H5,2,Porter,52000,Single,0,1804,2015-01-01 80050139,Hines,Quinn,Male,1987-06-18,K2T5Y5,3,Surveyor,85000,Single,0,5756.4,2015-01-01 80050140,Valdez,Christian,Male,1983-10-27,L8L3A6,3,Professor,94000,Married,3,6445.2,2015-01-01 80050141,Austin,Bell,Female,1970-11-18,M2D2C2,3,Astrologer,81000,Divorced,3,5945,2015-01-01 80050142,Andersen,Strong,Male,1988-04-05,K2O4N7,1,Priest,81000,Married,0,1057.8,2015-01-01 80050143,Alexander,Butler,Male,1989-07-01,M8V1M7,3,Clerical assistant,95000,Divorced,1,5116.8,2015-01-01 80050144,Stewart,Hill,Female,1990-02-08,M8G4Q7,2,Producer,42000,Single,0,2189.4,2015-01-01 80050145,Hood,Allen,Male,1978-08-04,K8T5C8,4,Antique dealer,113000,Married,2,2255,2015-01-01 80050146,Miranda,Dickerson,Female,1990-07-07,K2R5A6,2,Song writer,91000,Single,0,2107.4,2015-01-01 80050147,Madden,Maddox,Female,1978-01-23,M3P8R5,1,Astrologer,70000,Single,0,3640.8,2015-01-01 80050148,Case,Carey,Male,1977-11-21,K3G4J3,3,Aromatherapist,58000,Single,0,4444.4,2015-01-01 80050149,Mcknight,Hebert,Male,1989-08-18,N6C4I6,3,Printer,89000,Single,0,5330,2015-01-01 80050150,Cain,Byrd,Male,1985-11-04,M4T5T8,2,Tattooist,103000,Single,0,5740,2015-01-01 80050151,Villarreal,Fisher,Female,1996-06-22,L4A4H4,4,Foster parent,79000,Divorced,1,5715.4,2015-01-01 80050152,Blackwell,Murillo,Male,1978-05-10,M4V3B5,3,Clerical assistant,86000,Single,0,4559.2,2015-01-01 80050153,Stewart,Ayers,Male,1972-06-02,L2V1M5,4,Dancer,52000,Single,0,6068,2015-01-01 80050154,Tucker,Galvan,Female,1996-03-11,K6C3G7,2,Builder,53000,Divorced,2,565.8,2015-01-01 80050155,Cantrell,Underwood,Female,1985-01-30,K3F1M7,1,Surgeon,97000,Single,0,1336.6,2015-01-01 80050156,Skinner,Collier,Male,1984-09-20,N7X5P8,1,Kennel worker,75000,Married,3,3968.8,2015-01-01 80050157,Shannon,Rose,Male,1989-04-21,M8K4C5,3,Inventor,111000,Single,0,1090.6,2015-01-01 80050158,Campbell,Hancock,Male,1981-03-28,N2F1W8,2,Baker,35000,Single,0,2681.4,2015-01-01 80050159,Freeman,Alvarado,Female,1990-10-17,K4N3A1,2,Sculptor,41000,Single,0,1902.4,2015-01-01 80050160,Blackwell,Estes,Male,1970-05-19,N5E6W3,1,Management consultant,83000,Divorced,2,4132.8,2015-01-01 80050161,Boyer,Hale,Male,2000-11-18,K8L2A4,4,Chef,37000,Single,0,5830.2,2015-01-01 80050162,Mathis,Fernandez,Female,1986-07-20,N6V1V4,1,Magistrate,92000,Single,0,1033.2,2015-01-01 80050163,Stokes,Carter,Female,1997-05-02,K8Q4S2,2,Interior designer,63000,Married,0,6092.6,2015-01-01 80050164,Travis,Kline,Male,1997-05-06,L6C8X7,2,Miner,77000,Married,2,4362.4,2015-01-01 80050165,Baird,Huerta,Male,1985-05-25,K6T6N2,4,Delivery driver,39000,Married,1,3329.2,2015-01-01 80050166,Martin,Mcgee,Male,2000-06-09,M3N4W2,2,Childminder,34000,Married,2,770.8,2015-01-01 80050167,Leon,Travis,Female,1992-07-12,N4Y8H4,2,Bank manager,48000,Single,0,3362,2015-01-01 80050168,Larson,Prince,Female,2000-11-10,N1H4G7,1,Grave digger,57000,Married,2,787.2,2015-01-01 80050169,Rios,Garcia,Female,1981-08-07,L8R1R7,4,Park ranger,62000,Married,0,5789.2,2015-01-01 80050170,Garner,Hodges,Female,1970-09-27,L2E4Z8,2,Crane driver,107000,Single,0,3772,2015-01-01 80050171,Harrell,Madden,Male,1990-09-14,M8V1M4,3,Television presenter,47000,Divorced,3,5854.8,2015-01-01 80050172,Hamilton,Koch,Female,1996-11-05,L7N2H1,2,Computer analyst,73000,Married,1,2492.8,2015-01-01 80050173,Knapp,Cox,Male,1976-10-13,K2R6C3,1,Croupier,33000,Married,2,1418.6,2015-01-01 80050174,Strickland,Novak,Female,1968-06-10,N6L3C5,4,Horticulturalist,104000,Married,2,4452.6,2015-01-01 80050175,Griffith,Williamson,Female,1982-08-24,N2O5I6,1,Osteopath,35000,Married,0,6412.4,2015-01-01 80050176,Randall,Huerta,Female,1989-05-08,M3N7P5,4,Housekeeper,88000,Married,2,2271.4,2015-01-01 80050177,Pace,Burton,Male,1988-08-04,N6J5P5,1,Miner,41000,Divorced,3,6076.2,2015-01-01 80050178,Davenport,Villa,Female,1982-04-16,K3P4R7,4,Student,76000,Married,3,590.4,2015-01-01 80050179,Benitez,Barton,Male,1977-05-22,L8O8V7,3,Firefighter,90000,Single,0,2189.4,2015-01-01 80050180,Sexton,Houston,Male,1976-06-22,L6R8X5,4,Caretaker,94000,Divorced,2,4149.2,2015-01-01 80050181,Wu,Hoffman,Female,1992-10-18,L1M4Q7,2,Lecturer,66000,Single,0,3944.2,2015-01-01 80050182,Atkins,Arellano,Female,1989-05-28,L3O8X5,4,Lighthouse keeper,45000,Married,0,2361.6,2015-01-01 80050183,Spencer,Dixon,Male,2000-06-26,M5S7Z2,1,Herbalist,89000,Married,3,3107.8,2015-01-01 80050184,Montes,Mayer,Male,1978-01-20,K3M3E3,2,Property developer,94000,Single,0,4239.4,2015-01-01 80050185,Atkins,Warner,Female,1996-06-15,K4H3C8,3,Flower arranger,63000,Single,0,4846.2,2015-01-01 80050186,Fisher,Hoover,Female,1983-01-23,M4U6S2,3,Fork-lift driver,106000,Divorced,0,2189.4,2015-01-01 80050187,Odom,Francis,Female,1976-06-02,K5P8M8,4,Magician,42000,Single,0,5764.6,2015-01-01 80050188,Gilbert,Eaton,Male,1991-09-15,L7G7D8,2,Dental hygienist,77000,Married,1,4034.4,2015-01-01 80050189,Garrett,Knight,Male,1981-11-26,M7N4P7,3,Footballer,51000,Single,0,2492.8,2015-01-01 80050190,Gates,Wilcox,Male,1975-03-14,K7N4O2,1,Advertising executive,82000,Single,0,5305.4,2015-01-01 80050191,Chase,Murray,Male,1977-04-30,M5E1V7,4,Home-worker,53000,Married,2,508.4,2015-01-01 80050192,Crane,Lozano,Male,2001-06-29,M4R6T8,3,Author,70000,Married,0,5207,2015-01-01 80050193,Marquez,Estes,Male,1971-06-23,L2P1G7,3,Chiropractor,51000,Single,0,6199.2,2015-01-01 80050194,Martin,Becker,Female,1998-12-13,K5A5A1,2,Paramedic,59000,Single,0,3640.8,2015-01-01 80050195,Baxter,Reilly,Male,1994-03-13,K3U1T1,2,Events organiser,103000,Married,3,5789.2,2015-01-01 80050196,Padilla,Dunn,Female,1981-05-09,N8P8Y6,1,Pathologist,84000,Single,0,5444.8,2015-01-01 80050197,Meadows,Rojas,Male,1999-05-15,K1Y8M2,2,Cabin crew,77000,Single,0,729.8,2015-01-01 80050198,Roth,Forbes,Female,1976-09-18,L6W1C3,3,Dancer,41000,Single,0,1271,2015-01-01 80050199,Bridges,Randall,Female,1988-02-04,L3C2C3,1,Dental nurse,53000,Married,2,3427.6,2015-01-01 80050200,Spencer,Banks,Female,1990-05-17,K7M2V3,4,Cashier,69000,Single,0,1984.4,2015-01-01 80050201,Dodson,Gilbert,Male,1974-09-01,M4A4A5,2,Economist,90000,Single,0,1910.6,2015-01-01 80050202,Buchanan,Barry,Male,1982-07-04,K6X8V8,3,Machinist,98000,Married,2,3025.8,2015-01-01 80050203,Irwin,Bowers,Female,1975-09-27,M1R7B6,4,Librarian,77000,Single,0,3075,2015-01-01 80050204,Cox,Friedman,Female,1997-07-07,K5V4L3,4,Literary agent,87000,Single,0,811.8,2015-01-01 80050205,Hodges,Travis,Female,1983-09-22,L2R6C1,2,Clairvoyant,75000,Single,0,5305.4,2015-01-01 80050206,Simpson,Eaton,Female,1974-12-02,K8H5P2,1,Racing driver,31000,Divorced,0,2730.6,2015-01-01 80050207,Vasquez,Hanson,Female,1984-07-08,N5N8V1,2,Osteopath,28000,Married,3,5330,2015-01-01 80050208,Owens,Maldonado,Male,1995-01-09,K1O4J8,2,Computer programmer,34000,Married,2,3214.4,2015-01-01 80050209,Mcintyre,Houston,Male,1975-01-03,N5O2O1,2,Career criminal,77000,Single,0,2476.4,2015-01-01 80050210,Ortiz,Haas,Female,1992-03-07,M7T3J2,2,Fairground worker,64000,Married,2,1795.8,2015-01-01 80050211,David,Tanner,Male,1986-09-14,K5K2H7,1,Gas fitter,100000,Single,0,721.6,2015-01-01 80050212,Branch,Francis,Female,1998-05-15,K1G6D4,2,Administrator,82000,Married,3,4772.4,2015-01-01 80050213,Faulkner,Daugherty,Female,1986-09-25,N4B2J7,2,Social worker,84000,Single,0,3952.4,2015-01-01 80050214,Contreras,Crosby,Female,1976-05-10,K8K6U7,3,Accountant,37000,Single,0,1131.6,2015-01-01 80050215,Ayers,Horton,Female,1987-06-11,K4W3H1,1,Make-up artist,65000,Divorced,1,5674.4,2015-01-01 80050216,Clark,Bell,Male,1977-08-01,N7Z2Y8,3,Television presenter,56000,Divorced,1,1312,2015-01-01 80050217,Arroyo,Sharp,Female,1974-08-21,N3J7Z7,1,Crane driver,91000,Single,0,4715,2015-01-01 80050218,Ray,Valentine,Male,1970-10-31,N7O7V5,2,Shop assistant,47000,Married,2,4083.6,2015-01-01 80050219,Rivas,Peters,Female,1978-03-15,L4N7K4,1,Managing director,39000,Single,0,4034.4,2015-01-01 80050220,Ray,Ponce,Female,1972-11-16,K8F2A2,2,Gas fitter,35000,Married,1,4829.8,2015-01-01 80050221,Carroll,Duffy,Male,1985-03-20,N2X8A1,2,Baggage handler,54000,Single,0,4231.2,2015-01-01 80050222,Browning,Skinner,Male,1976-08-24,N1Q7H5,2,Car wash attendant,39000,Married,3,1771.2,2015-01-01 ; Run;