******************************************************************* * Stata "do-file" file with labels and missing data specifications * Created by ddltox on May 22, 2009 (Fri 01:34 PM PDT) * DDL source file: "ocas96/ocas96.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: 77 ******************************************************************* label data "ORANGE COUNTY ANNUAL SURVEY 1996" #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 "OWN" 2 "RENT" 9 "DK, REFUSE" ; label define Q4 1 "UNDER $500" 2 "$501-$750" 3 "$751-$1,000" 4 "$1,001-$1,500" 5 "$1,501+" 9 "NA, REFUSE" ; label define Q5 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 Q6 1 "BETTER OFF" 2 "WORSE OFF" 3 "SAME" 9 "DK, REFUSE" ; label define Q7 1 "BETTER OFF" 2 "WORSE OFF" 3 "SAME" 8 "DK" 9 "REFUSE" ; label define Q8 1 "GOOD TIMES" 2 "BAD TIMES" 8 "DK" 9 "REFUSE" ; label define Q9 1 "GOOD TIMES" 2 "DEPRESSION" 8 "DK" 9 "REFUSE" ; label define Q10 1 "GOOD TIME" 2 "BAD TIME" 8 "NEITHER, DK" 9 "REFUSE" ; label define Q11 1 "MORE THAN ENOUGH" 2 "JUST ENOUGH" 3 "NOT ENOUGH" 8 "DK" 9 "REFUSE" ; label define Q12 1 "VERY OFTEN" 2 "FAIRLY OFTEN" 3 "NOT TOO OFTEN" 4 "NEVER" 8 "DK" 9 "REFUSE" ; label define Q13 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q14 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q15 1 "VERY WELL" 2 "SOMEWHAT WELL" 3 "SOMEWHAT BADLY" 4 "VERY BADLY" 9 "DK, REFUSE" ; label define Q16 1 "GROWTH" 2 "TRAFFIC" 3 "HOUSING" 4 "CRIME" 5 "SCHOOLS" 6 "IMMIGRATION" 7 "ECONOMY" 8 "FINANCIAL CRISIS" 9 "DK, REFUSE" ; label define Q17 1 "HEALTH CARE" 2 "CHILD CARE" 3 "RACE RELATIONS" 4 "HOMELESS" 5 "DRUG ABUSE" 6 "AIDS" 7 "OTHER" 9 "DK, REFUSE" ; label define Q18 1 "BETTER PLACE" 2 "WORSE PLACE" 3 "NO CHANGE" 9 "DK, REFUSE" ; label define Q19 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q20 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q21 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q22 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q23 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q24 1 "FOR TAX HIKE" 2 "AGAINST TAX HIKE" 8 "DK" 9 "REFUSE" ; label define Q25 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 5 "NOT IN CITY" 8 "DK" 9 "REFUSE" ; label define Q26 1 "A LOT" 2 "SOME" 3 "VERY LITTLE" 4 "NONE" 5 "NOT IN CITY" 8 "DK" 9 "REFUSE" ; label define Q27 1 "WASTE A LOT" 2 "WASTE SOME" 3 "WASTE LITTLE" 4 "WASTE NONE" 5 "NOT IN CITY" 8 "DK" 9 "REFUSE" ; label define Q28 1 "EXCELLENT" 2 "GOOD" 3 "FAIR" 4 "POOR" 8 "DK" 9 "REFUSE" ; label define Q29 1 "A LOT" 2 "SOME" 3 "VERY LITTLE" 4 "NONE" 8 "DK" 9 "REFUSE" ; label define Q30 1 "WASTE A LOT" 2 "WASTE SOME" 3 "WASTE LITTLE" 4 "WASTE NONE" 8 "DK" 9 "REFUSE" ; label define Q31 1 "SATISFACTORY" 2 "MORE LANES ONLY" 3 "NEW FREEWAYS" 9 "DK, REFUSE" ; label define Q32 1 "VERY SATISFIED" 2 "SOMEWHAT SATISFIED" 3 "NOT SATISFIED" 8 "DK" 9 "REFUSE" ; label define Q33 1 "FULL-TIME" 2 "PART-TIME" 3 "NOT EMPLOYED" 9 "REFUSE" ; label define Q34 1 "NO PROBLEM" 2 "SOME PROBLEM" 3 "GREAT PROBLEM" 9 "NA" ; label define Q35 1 "VERY FAVORABLE" 2 "SOMEWHAT FAVORABLE" 3 "SOMEWHAT UNFAV" 4 "VERY UNFAVORABLE" 8 "DK" 9 "REFUSE" ; label define Q36 1 "VERY FAVORABLE" 2 "SOMEWHAT FAVORABLE" 3 "SOMEWHAT UNFAV" 4 "VERY UNFAVORABLE" 8 "DK" 9 "REFUSE" ; label define Q37 1 "VERY FAVORABLE" 2 "SOMEWHAT FAVORABLE" 3 "SOMEWHAT UNFAV" 4 "VERY UNFAVORABLE" 8 "DK" 9 "REFUSE" ; label define Q38 1 "VERY FAVORABLE" 2 "SOMEWHAT FAVORABLE" 3 "SOMEWHAT UNFAV" 4 "VERY UNFAVORABLE" 8 "DK" 9 "REFUSE" ; label define Q39 1 "NOTHING" 2 "$1-$100" 3 "$101-$250" 4 "$251-$500" 5 "$501-$999" 6 "$1000+" 8 "DK" 9 "DK, REFUSE" ; label define Q40 1 "VERY OFTEN" 2 "SOMETIMES" 3 "RARELY" 4 "NEVER" 8 "DK" 9 "REFUSE" ; label define Q41 1 "GREAT DEAL" 2 "SOME" 3 "NOT MUCH" 4 "NONE" 5 "DEPENDS" 8 "DK" 9 "REFUSE" ; label define Q42 1 "GREAT DEAL" 2 "SOME" 3 "NOT MUCH" 4 "NONE" 5 "DEPENDS" 8 "DK" 9 "REFUSE" ; label define Q43 1 "YES, 1" 2 "YES, 2+" 3 "NO" 8 "DK" 9 "REFUSE" ; label define Q44 1 "YES, 1" 2 "YES, 2+" 3 "NO" 8 "DK" 9 "REFUSE" ; label define Q45 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q46 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q47 1 "NEWSPAPERS" 2 "TV" 3 "RADIO" 4 "MAGAZINES" 5 "TALKING TO PEOPLE" 6 "INTERNET" 7 "OTHER" 8 "DK" 9 "REFUSE" ; label define Q48 1 "NEWSPAPERS" 2 "TV" 3 "RADIO" 4 "MAGAZINES" 5 "TALKING TO PEOPLE" 6 "INTERNET" 7 "OTHER" 8 "DK" 9 "REFUSE" ; label define Q49 1 "VERY CLOSELY" 2 "SOMEWHAT CLOSELY" 3 "NOT VERY CLOSELY" 4 "NOT AT ALL" 8 "DK" 9 "REFUSE" ; label define Q50 1 "VERY CLOSELY" 2 "SOMEWHAT CLOSELY" 3 "NOT VERY CLOSELY" 4 "NOT AT ALL" 8 "DK" 9 "REFUSE" ; label define Q51 1 "VERY CLOSELY" 2 "SOMEWHAT CLOSELY" 3 "NOT VERY CLOSELY" 4 "NOT AT ALL" 8 "DK" 9 "REFUSE" ; label define Q52 1 "VERY IMPORTANT" 2 "SOMEWHAT IMPORTANT" 3 "NOT IMPORTANT" 8 "DK" 9 "REFUSE" ; label define Q53 1 "DEMOCRAT BIAS" 2 "REPUBLICAN BIAS" 3 "NO BIAS" 8 "DK" 9 "REFUSE" ; label define Q54 1 "DEMOCRAT" 2 "REPUBLICAN" 3 "INDEP/OTHER" 4 "NOT REGD" 9 "REFUSE" ; label define Q55 1 "CLINTON/GORE" 2 "DOLE/KEMP" 3 "PEROT/" 4 "OTHER" 8 "DK" 9 "REFUSE" ; label define Q56 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q57 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q58 1 "VERY LIBERAL" 2 "SOMEWHAT LIBERAL" 3 "MIDDLE OF ROAD" 4 "SOMEWHAT CONSERV" 5 "VERY CONSERV" 9 "REFUSE" ; label define Q59 0 "NEVER" 1 "1X" 2 "2X" 3 "3X" 4 "4X+" 8 "DK" 9 "REFUSE" ; label define Q90 1 "18-34" 2 "35-54" 3 "55+" 9 "REFUSE" ; label define Q91 1 "< H.S." 2 "H.S. GRAD" 3 "SOME COLLEGE" 4 "COLLEGE GRAD" 5 "POST GRAD" 9 "REFUSE" ; label define Q92 1 "YES" 2 "NO" 8 "DK" 9 "REFUSE" ; label define Q93 1 "NORTH" 2 "WEST" 3 "CENTRAL" 4 "SOUTH" 5 "OUTSIDE OC" 9 "NO ANS" ; label define Q94 1 "UNDER $36,000" 2 "$36,000-$50,000" 3 "$50,001-$79,999" 4 "$80,000+" 9 "DK, REFUSE" ; label define Q95 1 "ASIAN" 2 "BLACK" 3 "HISPANIC" 4 "CAUCASIAN" 5 "OTHER" 9 "REFUSE" ; label define Q96 1 "MALE" 2 "FEMALE" ; label define LANG 1 "ENGLISH" 2 "SPANISH" ; label define YEAR 1996 "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 Q54 = . if (Q54 == 9) replace Q55 = . if (Q55 == 9) replace Q56 = . if (Q56 == 9) replace Q57 = . if (Q57 == 9) replace Q58 = . if (Q58 == 9) replace Q59 = . if (Q59 == 9) replace Q90 = . if (Q90 == 9) replace Q91 = . if (Q91 == 9) replace Q92 = . if (Q92 == 9) replace Q94 = . if (Q94 == 9) replace Q95 = . if (Q95 == 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 "RESPONDENT ID" _column(5) int Q1 :Q1 %1f "RESIDENCE TYPE" _column(6) int Q2 :Q2 %1f "YEARS OF RESIDENCE (range)" _column(7) int Q3 :Q3 %1f "OWN PRESENT RESIDENCE" _column(8) int Q4 :Q4 %1f "MONTHLY RENT (range)" _column(9) int Q5 :Q5 %1f "MONTHLY MORTGAGE (range)" _column(10) int Q6 :Q6 %1f "FINANCIALLY BETTER OFF THAN LAST YEAR?" _column(11) int Q7 :Q7 %1f "BETTER OFF NEXT YEAR?" _column(12) int Q8 :Q8 %1f "U.S. BUSINESS CONDS NEXT 12 MONTHS" _column(13) int Q9 :Q9 %1f "U.S. BUSINESS CONDITIONS NEXT 5 YEARS" _column(14) int Q10 :Q10 %1f "MAJOR HOUSEHOLD PURCHASES" _column(15) int Q11 :Q11 %1f "INCOME ENOUGH?" _column(16) int Q12 :Q12 %1f "HOW OFTEN WORRY ABOUT MONEY" _column(17) int Q13 :Q13 %1f "ORANGE COUNTY ECONOMY" _column(18) int Q14 :Q14 %1f "INVESTING IN HOMES IN ORANGE COUNTY" _column(19) int Q15 :Q15 %1f "QUALITY OF LIFE?" _column(20) int Q16 :Q16 %2f "MOST SERIOUS PUBLIC POLICY ISSUE" _column(22) int Q17 :Q17 %1f "MOST SERIOUS HEALTH AND SOCIAL ISSUE" _column(23) int Q18 :Q18 %1f "ORANGE COUNTY A BETTER PLACE TO LIVE?" _column(24) int Q19 :Q19 %1f "RATE POLICE PROTECTION" _column(25) int Q20 :Q20 %1f "RATE RECREATIONAL FACILITIES" _column(26) int Q21 :Q21 %1f "RATE STREETS AND ROADS" _column(27) int Q22 :Q22 %1f "RATE PUBLIC LIBRARIES" _column(28) int Q23 :Q23 %1f "RATE PUBLIC SCHOOLS" _column(29) int Q24 :Q24 %1f "RAISE TAXES FOR LOCAL SCHOOLS" _column(30) int Q25 :Q25 %1f "CITY GOVERNMENT PERFORMANCE" _column(31) int Q26 :Q26 %1f "CITY'S ATTENTION PAID TO PEOPLE" _column(32) int Q27 :Q27 %1f "CITY WASTING TAXES?" _column(33) int Q28 :Q28 %1f "COUNTY GOVERNMENT PERFORMANCE" _column(34) int Q29 :Q29 %1f "COUNTY'S ATTENTION PAID TO PEOPLE" _column(35) int Q30 :Q30 %1f "COUNTY WASTING TAXES?" _column(36) int Q31 :Q31 %1f "SATISFIED WITH LOCAL FREEWAYS?" _column(37) int Q32 :Q32 %1f "SATISFIED WITH USE OF MEASURE M FUNDS" _column(38) int Q33 :Q33 %1f "WORK STATUS" _column(39) int Q34 :Q34 %1f "TRAFFIC CONGESTION DURING COMMUTE" _column(40) int Q35 :Q35 %1f "DONATING TO RELIGOUS GROUPS" _column(41) int Q36 :Q36 %1f "DONATING TO PROGRAMS FOR NEEDY" _column(42) int Q37 :Q37 %1f "DONATING TO MEDICAL CAUSES" _column(43) int Q38 :Q38 %1f "DONATING TO THE ARTS" _column(44) int Q39 :Q39 %1f "MONEY GIVEN TO CHARITIES LAST YEAR" _column(45) int Q40 :Q40 %1f "HOW OFTEN CHARITIES ASK YOU FOR MONEY" _column(46) int Q41 :Q41 %1f "ORANGE COUNTY CHARITIES SPENDING WISELY?" _column(47) int Q42 :Q42 %1f "ORANGE COUNTY CHARITIES PRODUCE RESULTS?" _column(48) int Q43 :Q43 %1f "VOLUNTEER WORK IN PAST 12 MONTHS?" _column(49) int Q44 :Q44 %1f "READ NEWSPAPER REGULARLY" _column(50) int Q45 :Q45 %1f "WATCH T.V. NEWS REGULARLY" _column(51) int Q46 :Q46 %1f "LISTEN TO RADIO NEWS REGULARLY" _column(52) int Q47 :Q47 %1f "PRIMARY NEWS SOURCE" _column(53) int Q48 :Q48 %1f "PRIMARY NEWS SOURCE FOR ORANGE COUNTY" _column(54) int Q49 :Q49 %1f "FOLLOW COMMUNITY EVENTS?" _column(55) int Q50 :Q50 %1f "FOLLOW LOCAL GOVERNMENT NEWS?" _column(56) int Q51 :Q51 %1f "FOLLOW WASHINGTON NEWS?" _column(57) int Q52 :Q52 %1f "OBLIGATION TO KEEP INFORMED?" _column(58) int Q53 :Q53 %1f "PRESIDENTIAL NEWS COVERAGE BIAS" _column(59) int Q54 :Q54 %1f "PARTY REGISTRATION" _column(60) int Q55 :Q55 %1f "PRESIDENTIAL VOTE" _column(61) int Q56 :Q56 %1f "VOTE ON PROPOSITION 209" _column(62) int Q57 :Q57 %1f "VOTE ON MEASURE A" _column(63) int Q58 :Q58 %1f "CONSIDER YOURSELF POLITICALLY" _column(64) int Q59 :Q59 %1f "VOTED PAST 4 YEARS" _column(65) int Q90 :Q90 %1f "AGE (range)" _column(66) int Q91 :Q91 %1f "LAST GRADE OF SCHOOL COMPLETED" _column(67) int Q92 :Q92 %1f "HAVE KIDS IN PUBLIC SCHOOLS?" _column(68) int Q93 :Q93 %2f "CITY" _column(70) int Q94 :Q94 %1f "ANNUAL HOUSEHOLD INCOME (range)" _column(71) int Q95 :Q95 %1f "RACE AND ETHNICITY" _column(72) int Q96 :Q96 %1f "GENDER (sex)" _column(73) int LANG :LANG %1f "LANGUAGE OF INTERVIEW" _column(74) int YEAR :YEAR %4f "YEAR OF SURVEY" }