ST 445 -- Summer 2013

HOMEWORK #3 -- Due Thursday, 06 June 2013

In the file 'Child4.dat' are names, addresses, and telephone numbers of 
most of the child care centers in North Carolina (total ~ 8000).  Each 
center takes six records in the file.  The first record is the eight 
digit license number; the second record is the name; the third is the 
street address; the fourth record is the town, state (NC), and zip code 
in columns 31-35.  In the fifth record is the telephone number in the 
form (xxx) xxx-xxxx where the first field is the area code.  The sixth 
record gives what class of center (e.g. 'Five Star') and what type of 
license.  On this last record, we only need to read in the class, which 
is the first field in that record.  Most of the values of class are 
'One' to 'Five' while other values include 'Temporary' and a statute 
designation. (These data are from Fall 2011.)

(a) Write a SAS program to read in this information, where each center 
corresponds to an observation with (at least) variables for the license 
number, zip code, area code, and class of center (character variable).  

(b) How many centers are in this file?  (I've deleted some with goofy
information.)

(c) The only area codes in the state are 828, 704/980 (Charlotte has
two), 336, 919, 910, and 252.  How many telephone numbers appear to be 
erroneous?

(d) Recode the area codes in such a way that you combine the 704 and 
980 codes together and then create a frequency table of the area code 
(only correct ones) (so just 6).  

(e) Create a variable 'STARS' that converts the character variable of 
class to a numeric variable, so that 'One' becomes the number 1, 'Two' 
becomes 2, ..., 'Five' becomes 5, and any other value converts to 
missing.

(f) Create a chart of area codes where the variable displayed is the 
mean number of 'STARS.'

(g) Create a frequency table of 'STARS' and the zipcode prefix composed 
of just the first 3 digits.

FOR ALL EXERCISES: Hand in (paper) (1) The answers to any questions 
asked. (2) Your program * With at least as many comments as you have 
toes! * (3) Your output