Coding Project (3 hours)
(Sample)

A client of yours sent you a data set that contains the customer information from a loyalty card program.

The data set contains tons of information that your client can explore.

However, the data set must be cleaned up before the analysis can be done.

Your boss is currently on vacation, and your client needs this done by tomorrow. 

It is the perfect time to show your boss's boss you can totally step up and do the job.


Task 1

Run the code in the yellow box below to get the CUSTOMER data set on SAS Studio. 

[Note: the code are fairly long. You must click the yellow box to "select all" text, and paste it on the Coding Area before you run it.]

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;

You can also download the code from the text file below:

coding_exercise_samples.txt
File Size:	10 kb
File Type:	txt

Download File

---

---

Note: the data set above contains only 100 observations. 

The complete data set (2000 observations) is only available to our members.

​Sign up now.

---

The CUSTOMER data set contains the following 13 variables:

• CUSTID: Customer ID
• FIRST: First Name
• LAST: Last Name
• GENDER: Gender
• DOB: Date of Birth
• POSTAL: Postal Code (Canada)
• EDU: Level of Education
• OCCUP: Occupation
• INCOME: Income
• STATUS: Marital Status
• NUMKIDS: Number of Kids
• SPEND: Spending in the year past
• DOS: Date of Study

Check the followings after you create the CUSTOMER data set on SAS Studio:

1. There are 2000 observations in the data set
2. All 13 variables are captured in the CUSTOMER data set

You do not need to submit the answer for Task 1. This is just to ensure you have the complete data set for Task 2. 

Task 2