******************************************************************* * Stata "do-file" file with labels and missing data specifications * Created by ddltox on Mar 09, 2009 (Mon 12:02 PM PDT) * DDL source file: "ocas91/ocas91.ddl". * * Note that the data dictionary is given at the end of this file. * Put the dictionary into a separate file (by editing this file). * Then specify below the name of the dictionary file. * * DDL file gives the following dataset description: * Records per case: 1 * Record length: 98 ******************************************************************* label data "ORANGE COUNTY SURVEYS" #delimit ; label define Q1 1 "SINGLE FAMILY" 2 "ATTACHED" 3 "APARTMENT" 4 "MOBILE" 5 "OTHER" 9 "REFUSE" ; label define Q2 1 "0-2 YRS" 2 "3-5 YRS" 3 "6-10 YRS" 4 "11-20 YRS" 5 "21+ YRS" 9 "REFUSE" ; label define Q3 1 "0-2 YRS" 2 "3-5 YRS" 3 "6-10 YRS" 4 "11-20 YRS" 5 "21+ YRS" 9 "REFUSE" ; label define Q4 1 "OWN" 2 "RENT" 9 "DK, REFUSE" ; label define Q5 1 "UNDER $500" 2 "$501-$750" 3 "$751-$1,000" 4 "$1,001-$1,500" 5 "$1,501+" 9 "NA, REFUSE" ; label define Q6 1 "NOTHING" 2 "$1-$500" 3 "$501-$750" 4 "$751-$1,000" 5 "$1,001-$1,500" 6 "$1,501-$2,000" 7 "$2,001+" 9 "NA, REFUSE" ; label define Q7 1 "BETTER OFF" 2 "WORSE OFF" 3 "SAME" 9 "DK, REFUSE" ; label define Q8 1 "BETTER OFF" 2 "WORSE OFF" 3 "SAME" 8 "DK" 9 "REFUSE" ; label define Q9 1 "GOOD TIMES" 2 "BAD TIMES" 8 "DK" 9 "REFUSE" ; label define Q10 1 "GOOD TIMES" 2 "DEPRESSION" 8 "DK" 9 "REFUSE" ; label define Q11 1 "GOOD TIME" 2 "BAD TIME" 8 "NEITHER, DK" 9 "REFUSE" ; label define Q12 1 "VERY WELL" 2 "SOMEWHAT WELL" 3 "SOMEWHAT BADLY" 4 "VERY BADLY" 9 "DK, REFUSE" ; label define Q13 1 "GROWTH" 2 "TRAFFIC" 3 "HOUSING" 4 "CRIME" 5 "SCHOOLS" 6 "IMMIGRATION" 7 "OTHER" 9 "DK, REFUSE" ; label define Q14 1 "HEALTH CARE" 2 "CHILD CARE" 3 "RACE RELATIONS" 4 "HOMELESS" 5 "DRUG ABUSE" 6 "AIDS" 7 "OTHER" 9 "DK, REFUSE" ; label define Q15 1 "BETTER PLACE" 2 "WORSE PLACE" 3 "NO CHANGE" 9 "DK, REFUSE" ; label define Q16 1 "GROWING RAPIDLY" 2 "GROWING SLOWLY" 3 "STAYING SAME" 4 "LOSING POP" 8 "DK" 9 "REFUSE" ; label define Q17 1 "TOO STRICT" 2 "ABOUT RIGHT" 3 "NOT STRICT ENOUGH" 9 "DK,REFUSE" ; label define Q18 1 "SATISFACTORY" 2 "MORE LANES ONLY" 3 "NEW FREEWAYS" 9 "DK, REFUSE" ; label define Q19 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q20 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q21 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q22 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q23 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q24 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q25 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q26 1 "HIGH PRIORITY" 2 "MEDIUM PRIORITY" 3 "LOW PRIORITY" 8 "DK" 9 "REFUSE" ; label define Q27 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q28 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q29 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q30 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q31 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q32 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q33 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q34 1 "VERY SATISFIED" 2 "SOMEWHAT SAT" 3 "SOMEWHAT DISSAT" 4 "VERY DISSAT" 8 "DK" 9 "REFUSE" ; label define Q35 1 "VERY SATISFIED" 2 "SOMEWHAT SAT" 3 "SOMEWHAT DISSAT" 4 "VERY DISSAT" 8 "DK" 9 "REFUSE" ; label define Q36 1 "VERY SATISFIED" 2 "SOMEWHAT SAT" 3 "SOMEWHAT DISSAT" 4 "VERY DISSAT" 8 "DK, NA" 9 "REFUSE" ; label define Q37 1 "VERY SATISFIED" 2 "SOMEWHAT SAT" 3 "SOMEWHAT DISSAT" 4 "VERY DISSAT" 8 "DK" 9 "REFUSE" ; label define Q38 1 "VERY HAPPY" 2 "PRETTY HAPPY" 3 "NOT TOO HAPPY" 9 "DK, REFUSE" ; label define Q39 1 "MOST OF THE TIME" 2 "SOME OF THE TIME" 3 "HARDLY EVER" 4 "NEVER" 9 "DK, REFUSE" ; label define Q40 1 "MOST OF THE TIME" 2 "SOME OF THE TIME" 3 "HARDLY EVER" 4 "NEVER" 9 "DK, REFUSE" ; label define Q41 1 "MOST OF THE TIME" 2 "SOME OF THE TIME" 3 "HARDLY EVER" 4 "NEVER" 9 "DK, REFUSE" ; label define Q42 1 "MOST OF THE TIME" 2 "SOME OF THE TIME" 3 "HARDLY EVER" 4 "NEVER" 9 "DK, REFUSE" ; label define Q43 1 "FREQUENTLY" 2 "OCCASIONALLY" 3 "RARELY" 4 "NEVER" 8 "DK" 9 "REFUSE" ; label define Q44 1 "VERY SERIOUS" 2 "SOMEWHAT SERIOUS" 3 "NOT TOO SERIOUS" 8 "DK" 9 "REFUSE" ; label define Q45 1 "VERY FAMILIAR" 2 "SOMEWHAT FAMILIAR" 3 "NOT FAMILIAR" 8 "DK" 9 "REFUSE" ; label define Q46 1 "VERY FAVORABLE" 2 "SOMEWHAT FAVORABLE" 3 "SOMEWHAT UNFAVORABLE" 4 "VERY UNFAVORABLE" 8 "DK" 9 "REFUSE" ; label define Q47 1 "STRONGLY FAVOR" 2 "SOMEWHAT FAVOR" 3 "SOMEWHAT OPPOSE" 4 "STRONGLY OPPOSE" 8 "DK" 9 "REFUSE" ; label define Q48 1 "STRONGLY FAVOR" 2 "SOMEWHAT FAVOR" 3 "SOMEWHAT OPPOSE" 4 "STRONGLY OPPOSE" 8 "DK" 9 "REFUSE" ; label define Q49 1 "STRONGLY FAVOR" 2 "SOMEWHAT FAVOR" 3 "SOMEWHAT OPPOSE" 4 "STRONGLY OPPOSE" 8 "DK" 9 "REFUSE" ; label define Q50 1 "CARPOOL" 2 "PUBLIC TRANSIT" 3 "DRIVE ALONE" 8 "DK" 9 "REFUSE" ; label define Q51 1 "CARPOOL" 2 "PUBLIC TRANSIT" 3 "DRIVE ALONE" 8 "DK" 9 "REFUSE" ; label define Q52 1 "MUCH MORE LIKELY" 2 "SOMEWHAT MORE LIKELY" 3 "NO DIFFERENCE" 4 "SOMEWHAT LESS LIKELY" 5 "MUCH LESS LIKELY" 8 "DK" 9 "REFUSE" ; label define Q53 1 "MUCH MORE LIKELY" 2 "SOMEWHAT MORE LIKELY" 3 "NO DIFFERENCE" 4 "SOMEWHAT LESS LIKELY" 5 "MUCH LESS LIKELY" 8 "DK" 9 "REFUSE" ; label define Q76 1 "NOTHING" 2 "$1-$100" 3 "$101-$250" 4 "$251-$500" 5 "$501-$999" 6 "$1000+" 9 "DK, REFUSE" ; label define Q77 1 "FULL-TIME" 2 "PART-TIME" 3 "NOT EMPLOYED" 9 "REFUSE" ; label define Q78 1 "NORTH" 2 "WEST" 3 "CENTRAL" 4 "SOUTH" 5 "LA COUNTY" 8 "OTHER" 9 "NA, REFUSE" ; label define Q79 1 "DRIVE ALONE" 2 "CARPOOL" 3 "VANPOOL" 4 "PUBLIC TRANSIT" 5 "OTHER" 9 "NA, REFUSE" ; label define Q80 1 "LESS THAN 10 MIN" 2 "10-20 MIN" 3 "21-30 MIN" 4 "31-60 MIN" 5 "1 HOUR +" 9 "NA, REFUSE" ; label define Q81 1 "NO PROBLEM" 2 "SLIGHT PROBLEM" 3 "GREAT PROBLEM" 9 "NA, REFUSE" ; label define Q82 1 "18-34" 2 "35-54" 3 "55+" 9 "REFUSE" ; label define Q83 1 "< H.S." 2 "H.S. GRAD" 3 "SOME COLLEGE" 4 "COLLEGE GRAD" 5 "POST GRAD" 9 "REFUSE" ; label define Q84 1 "1" 2 "2" 3 "3" 4 "4" 5 "5" 6 "6" 7 "7" 8 "8+" 9 "REFUSE" ; label define Q85 0 "NONE" 1 "ONE" 2 "TWO" 3 "THREE OR MORE" 9 "REFUSE" ; label define Q86 1 "NORTH" 2 "WEST" 3 "CENTRAL" 4 "SOUTH" ; label define Q87 1 "UNDER $25,000" 2 "$25,000-$35,999" 3 "$36,000-$50,000" 4 "$50,001-$65,999" 5 "$66,000-$79,999" 6 "$80,000-$110,000" 7 "$110,001+" 9 "DK, REFUSE" ; label define Q88 1 "VERY LIBERAL" 2 "SOMEWHAT LIBERAL" 3 "MIDDLE OF ROAD" 4 "SOMEWHAT CONSERV" 5 "VERY CONSERV" 9 "REFUSE" ; label define Q89 1 "DEMOCRAT" 2 "REPUBLICAN" 3 "INDEP/OTHER" 4 "NOT REGISTERED" 9 "REFUSE" ; label define Q90 1 "DANNEMEYER" 2 "SEYMOUR" 3 "OTHER" 8 "DK" 9 "NA" ; label define Q91 1 "CAMPBELL" 2 "HERSCHENSOHN" 3 "OTHER" 8 "DK" 9 "NA" ; label define Q92 1 "DAVIS" 2 "FEINSTEIN" 3 "OTHER" 8 "DK" 9 "NA" ; label define Q93 1 "BOXER" 2 "LEVINE" 3 "MCCARTHY" 4 "OTHER" 8 "DK" 9 "NA" ; label define Q94 1 "MALE" 2 "FEMALE" ; label define YEAR 1991 "YEAR OF SURVEY" ; #delimit cr ******************************************************************* infile using X * Replace 'X' with the name of the dictionary file. * * The contents of the dictionary are given at the end of this file. * Put the dictionary into a separate file (by editing this file). * Then specify here the name of the dictionary file. ******************************************************************* * The md, min and max specifications were translated * into the following "REPLACE...IF" statements: replace Q1 = . if (Q1 == 9) replace Q2 = . if (Q2 == 9) replace Q3 = . if (Q3 == 9) replace Q4 = . if (Q4 == 9) replace Q5 = . if (Q5 == 9) replace Q6 = . if (Q6 == 9) replace Q7 = . if (Q7 == 9) replace Q8 = . if (Q8 == 9) replace Q9 = . if (Q9 == 9) replace Q10 = . if (Q10 == 9) replace Q11 = . if (Q11 == 9) replace Q12 = . if (Q12 == 9) replace Q13 = . if (Q13 == 9) replace Q14 = . if (Q14 == 9) replace Q15 = . if (Q15 == 9) replace Q16 = . if (Q16 == 9) replace Q17 = . if (Q17 == 9) replace Q18 = . if (Q18 == 9) replace Q19 = . if (Q19 == 9) replace Q20 = . if (Q20 == 9) replace Q21 = . if (Q21 == 9) replace Q22 = . if (Q22 == 9) replace Q23 = . if (Q23 == 9) replace Q24 = . if (Q24 == 9) replace Q25 = . if (Q25 == 9) replace Q26 = . if (Q26 == 9) replace Q27 = . if (Q27 == 9) replace Q28 = . if (Q28 == 9) replace Q29 = . if (Q29 == 9) replace Q30 = . if (Q30 == 9) replace Q31 = . if (Q31 == 9) replace Q32 = . if (Q32 == 9) replace Q33 = . if (Q33 == 9) replace Q34 = . if (Q34 == 9) replace Q35 = . if (Q35 == 9) replace Q36 = . if (Q36 == 9) replace Q37 = . if (Q37 == 9) replace Q38 = . if (Q38 == 9) replace Q39 = . if (Q39 == 9) replace Q40 = . if (Q40 == 9) replace Q41 = . if (Q41 == 9) replace Q42 = . if (Q42 == 9) replace Q43 = . if (Q43 == 9) replace Q44 = . if (Q44 == 9) replace Q45 = . if (Q45 == 9) replace Q46 = . if (Q46 == 9) replace Q47 = . if (Q47 == 9) replace Q48 = . if (Q48 == 9) replace Q49 = . if (Q49 == 9) replace Q50 = . if (Q50 == 9) replace Q51 = . if (Q51 == 9) replace Q52 = . if (Q52 == 9) replace Q53 = . if (Q53 == 9) replace Q76 = . if (Q76 == 9) replace Q77 = . if (Q77 == 9) replace Q78 = . if (Q78 == 9) replace Q79 = . if (Q79 == 9) replace Q80 = . if (Q80 == 9) replace Q81 = . if (Q81 == 9) replace Q82 = . if (Q82 == 9) replace Q83 = . if (Q83 == 9) replace Q84 = . if (Q84 == 9) replace Q85 = . if (Q85 == 9) replace Q87 = . if (Q87 == 9) replace Q88 = . if (Q88 == 9) replace Q89 = . if (Q89 == 9) replace Q90 = . if (Q90 == 9) replace Q91 = . if (Q91 == 9) replace Q92 = . if (Q92 == 9) replace Q93 = . if (Q93 == 9) dictionary using Y { ***************************************************************** * Replace 'Y' with the name of the data file. * The default suffix is '.raw'. * * Put this dictionary into a separate file (with the suffix .dct). * (The first line of the dictionary file must contain the * 'dictionary' command.) * * Then edit the name of that dictionary file into the 'do-file' * portion of the STATA definitions. ******************************************************************* * Records per case: _lines(1) _line(1) _column(1) int CASEID %4f "CASE ID" _column(5) int Q1 :Q1 %1f "TYPE OF CURRENT RESIDENCE" _column(6) int Q2 :Q2 %1f "HOW LONG LIVE IN OC" _column(7) int Q3 :Q3 %1f "HOW LONG LIVE AT CURRENT RESIDENCE" _column(8) int Q4 :Q4 %1f "OWN/RENT PRESENT RESIDENCE" _column(9) int Q5 :Q5 %1f "MONTHLY RENTAL PAYMENT" _column(10) int Q6 :Q6 %1f "MONTHLY MORTGAGE PAYMENT" _column(11) int Q7 :Q7 %1f "BETTER OFF/WORSE OFF/SAME LAST YEAR" _column(12) int Q8 :Q8 %1f "BETTER OFF/WORSE OFF/SAME NEXT YEAR" _column(13) int Q9 :Q9 %1f "NAT'L BUSINESS CONDS NEXT 12 MO" _column(14) int Q10 :Q10 %1f "NAT'L CONDS NEXT 5 YEARS" _column(15) int Q11 :Q11 %1f "GD/BAD TIME TO BUY MAJ HSEHOLD ITEMS" _column(16) int Q12 :Q12 %1f "QUALITY OF LIFE IN OC" _column(17) int Q13 :Q13 %1f "MOST SERIOUS PUBLIC POLICY PROBLEM" _column(18) int Q14 :Q14 %1f "MOST SERIOUS SOCIAL PROBLEM" _column(19) int Q15 :Q15 %1f "OC IN FUTURE" _column(20) int Q16 :Q16 %1f "POP GROWTH IN CITY PAST FEW YRS" _column(21) int Q17 :Q17 %1f "CURRENT GROWTH REGS IN CITY" _column(22) int Q18 :Q18 %1f "FEELING ABOUT FREEWAYS IN OC" _column(23) int Q19 :Q19 %1f "WHAT PRIORITY: BUILDING NEW FWYS" _column(24) int Q20 :Q20 %1f "WHAT PRIORITY: WIDENING EXISTING FWYS" _column(25) int Q21 :Q21 %1f "WHAT PRIORITY: IMPROVING LOCAL STREETS" _column(26) int Q22 :Q22 %1f "WHAT PRIORITY: IMPROVING BUS SERVICE" _column(27) int Q23 :Q23 %1f "WHAT PRIORITY: BUILDING LOCAL RAIL SYST" _column(28) int Q24 :Q24 %1f "WHAT PRIORITY: EXPANDING LA-SDIEGO RAIL" _column(29) int Q25 :Q25 %1f "WHAT PRIORITY: SYNCH. TRAFFIC SIGNALS" _column(30) int Q26 :Q26 %1f "WHAT PRIORITY: EXPRESS BUS IN FWY LANE" _column(31) int Q27 :Q27 %1f "NOTICED IMPROVEMENTS SINCE MEASURE M" _column(32) int Q28 :Q28 %1f "THINK MEAS M FUNDS BEING SPENT WISELY" _column(33) int Q29 :Q29 %1f "RATE ROAD MAINTENANCE" _column(34) int Q30 :Q30 %1f "RATE PUBLIC SCHOOL SYSTEM" _column(35) int Q31 :Q31 %1f "RATE POLICE PROTECTION" _column(36) int Q32 :Q32 %1f "RATE PARKS AND REC FACILITIES" _column(37) int Q33 :Q33 %1f "RATE CITY GOVERNMENT" _column(38) int Q34 :Q34 %1f "HOW SATISFIED WITH HOUSING" _column(39) int Q35 :Q35 %1f "HOW SATISFIED WITH NEIGHBORHOOD" _column(40) int Q36 :Q36 %1f "HOW SATISFIED WITH JOB" _column(41) int Q37 :Q37 %1f "HOW SATISFIED WITH FINANCES" _column(42) int Q38 :Q38 %1f "HOW THINGS ARE THESE DAYS" _column(43) int Q39 :Q39 %1f "HOW OFTEN BUY EMISSION CONTROL GAS" _column(44) int Q40 :Q40 %1f "HOW OFTEN BUY RECYCLED PRODUCTS" _column(45) int Q41 :Q41 %1f "HOW OFTEN RECYCLE PAPERS, GLASS CANS" _column(46) int Q42 :Q42 %1f "HOW OFTEN CONSERVE WATER AT HOME" _column(47) int Q43 :Q43 %1f "HOW OFTEN HEARD ABOUT ENV PROBLEMS" _column(48) int Q44 :Q44 %1f "HOW SERIOUS A THREAT ARE ENV PROBS" _column(49) int Q45 :Q45 %1f "HOW FAMILIAR WITH AQMP" _column(50) int Q46 :Q46 %1f "OPINION OF REGIONAL AIR QUAL AGENCY" _column(51) int Q47 :Q47 %1f "CHARGING SOLO DRIVERS TO PARK" _column(52) int Q48 :Q48 %1f "CHARGING SOLO DRIVERS CONGESTION FEE" _column(53) int Q49 :Q49 %1f "CHARGING SOLO DRIVERS SMOG FEE" _column(54) int Q50 :Q50 %1f "IF EMPLOYER OFFERED $50" _column(55) int Q51 :Q51 %1f "WHAT WOULD MOST PEOPLE DO W/ $50" _column(56) int Q52 :Q52 %1f "IF HEARD MOST PEOPLE WD DRIVE ALONE" _column(57) int Q53 :Q53 %1f "WHAT WOULD MOST PEOPLE DO IF HEARD" _column(58) int Q76 :Q76 %1f "$ GAVE TO ALL CHARITIES LAST YR" _column(59) int Q77 :Q77 %1f "WORK STATUS" _column(60) int Q78 :Q78 %2f "WORKPLACE" _column(62) int Q79 :Q79 %1f "HOW COMMUTE TO WORK" _column(63) int Q80 :Q80 %1f "TIME FROM HOME TO WORK" _column(64) int Q81 :Q81 %1f "HOW MUCH PROBLEM TRAFFIC" _column(65) int Q82 :Q82 %1f "AGE" _column(66) int Q83 :Q83 %1f "EDUCATION" _column(67) int Q84 :Q84 %1f "NUMBER OF PERSONS IN HOUSEHOLD" _column(68) int Q85 :Q85 %1f "NUMBER OF CHILDREN IN HHOLD" _column(69) int Q86 :Q86 %2f "RESIDENCE" _column(71) int Q87 :Q87 %1f "ANNUAL HOUSEHOLD INCOME" _column(72) int Q88 :Q88 %1f "CONSIDER YOURSELF POLITICALLY:" _column(73) int Q89 :Q89 %1f "PARTY" _column(74) int Q90 :Q90 %1f "DANNEMEYER/SEYMOUR CHOICE" _column(75) int Q91 :Q91 %1f "CAMPBELL/HERSCHENSOHN CHOICE" _column(76) int Q92 :Q92 %1f "DAVIS/FEINSTEIN CHOICE" _column(77) int Q93 :Q93 %1f "BOXER/LEVINE/MCCARTHY CHOICE" _column(78) int Q94 :Q94 %1f "SEX" _column(79) double WEIGHT %8.2f "WEIGHT" _column(87) double WT %8.2f "WT" _column(95) int YEAR :YEAR %4f "YEAR OF SURVEY" }