/*CREATE FORMATS FOR VARIABLES- BASED ON CODEBOOK NAMES*/

proc format;
 
value Q1N /*how old are you?*/
 1= '12 years old or younger' 
 2= '13 years old'
 3= '14 years old'
 4= '15 years old'
 5= '16 years old'
 6= '17 years old'
 7= '18 years old or older';

value Q2N /*what is your sex?*/
 1= 'Female'
 2= 'Male';

value Q3N /*what grade?*/
 1= '9th grade'
 2= '10th grade'
 3= '11th grade'
 4= '12th grade'
 5= 'Ungraded or other grade';

value yesno /*Q4, Q21-25; Q28, Q34, Q57, Q58, Q68, Q71, Q93, Q99 */
 1= 'Yes'
 2= 'No';

value Q8N /*bike helmet*/
 1= 'I did not ride a bicycle during the past 12 months'
 2= 'Never wore a helmet'
 3= 'Rarely wore a helmet'
 4= 'Sometimes wore a helmet'
 5= 'Most of the time wore a helmet'
 6= 'Always wore a helmet';

value Q9N /*seat belt*/
 1= 'Never'
 2= 'Rarely'
 3= 'Sometimes'
 4= 'Most of the time'
 5= 'Always';

value times6q/*Q11: drunk driving, Q19:injured fight; Q26: attmpt */
 1= '0 times'
 2= '1 time'
 3= '2 or 3 times'
 4= '4 or 5 times'
 5= '6 or more times';

value days5q /*Q12:carry weapon, Q13: carry gun, Q14: weapon in school, Q15: feel unsafe*/
 1= '0 days'
 2= '1 day'
 3= '2 or 3 days'
 4= '4 or 5 days'
 5= '6 or more days';

value times12q /*Q16:threats at school, Q17:damage,Q18: fight, Q20: fight school */
 1= '0 times'
 2= '1 time'
 3= '2 or 3 times'
 4= '4 or 5 times'
 5= '6 or 7 times'
 6= '8 or 9 times'
 7= '10 or 11 times'
 8= '12 or more times';

value Q27N /*treated for sx attmpt*/
 1= 'I did not attempt suicide during the past 12 months'
 2= 'Yes'
 3= 'No';

value Q29N /*age smoke*/
 1= 'I have never smoked a whole cigarette'
 2= '8 years old or younger'
 3= '9 or 10 years old'
 4= '11 or 12 years old'
 5= '13 or 14 years old'
 6= '15 or 16 years old'
 7= '17 years old or older';

value days30q /*Q30, Q33, Q36, Q38, Q41, Q44*/
 1= '0 days'
 2= '1 or 2 days'
 3= '3 to 5 days'
 4= '6 to 9 days'
 5= '10 to 19 days'
 6= '20 to 29 days'
 7= 'All 30 days';

value Q31N /*cigs per day*/
 1= 'I did not smoke cigarettes during the past 30 days'
 2= 'Less than 1 cigarette per day'
 3= '1 cigarette per day'
 4= '2 to 5 cigarettes per day'
 5= '6 to 10 cigarettes per day'
 6= '11 to 20 cigarettes per day'
 7= 'More than 20 cigarettes per day';

value Q35N /*quit smoke*/
 1= 'I did not smoke during the past 12months'
 2= 'Yes'
 3= 'No';

value Q40N /*age drink*/
 1= 'I have never had a drink of alcohol other than a few sips'
 2= '8 years old or younger'
 3= '9 or 10 years old'
 4= '11 or 12 years old'
 5= '13 or 14 years old'
 6= '15 or 16 years old'
 7= '17 years old or older';

value days20q /*Q42*/
 1= '0 days'
 2= '1 day'
 3= '2 days'
 4= '3 to 5 days'
 5= '6 to 9 days'
 6= '10 to 19 days'
 7= '20 or more days';

value Q43N /*get alcohol*/
 1= 'I did not drink alcohol during the past 30 days'
 2= 'I bought it in a store such as a liquor store, convenience store, supermarket, discount store, or gas station'
 3= 'I bought it at a restaurant, bar, or club'
 4= 'I bought it at a public event such as a concert or sporting event'
 5= 'I gave someone else money to buy it for me'
 6= 'Someone gave it to me'
 7= 'I took it from a store or family member'
 8= 'I got it some other way';

value times100q /*Q45*/
 1= '0 times'
 2= '1 or 2 times'
 3= '3 to 9 times'
 4= '10 to 19 times'
 5= '20 to 39 times'
 6= '40 to 99 times'
 7= '100 or more times';

value Q46N /*age pot*/
 1= 'I have never tried marijuana'
 2= '8 years old or younger'
 3= '9 or 10 years old'
 4= '11 or 12 years old'
 5= '13 or 14 years old'
 6= '15 or 16 years old'
 7= '17 years old or older';

value times40q /*Q47, Q48, Q49, Q52, Q53, Q54, Q55 */
 1= '0 times'
 2= '1 or 2 times'
 3= '3 to 9 times'
 4= '10 to 19 times'
 5= '20 to 39 times'
 6= '40 or more times';

value times2q /*Q56*/
 1= '0 times'
 2= '1 time'
 3= '2 or more times';

value Q59N /*age at sex*/
 1= 'I have never had sexual intercourse'
 2= '11 years old or younger'
 3= '12 years old'
 4= '13 years old'
 5= '14 years old'
 6= '15 years old'
 7= '16 years old'
 8= '17 years old or older';

value Q60N /*sex partners lifetime*/
 1= 'I have never had sexual intercourse'
 2= '1 person'
 3= '2 people'
 4= '3 people'
 5= '4 people'
 6= '5 people'
 7= '6 or more people';

value Q61N /*sex partners 3 months*/
 1= 'I have never had sexual intercourse'
 2= 'I have had sexual intercourse, but not during the past 3 months'
 3= '1 person'
 4= '2 people'
 5= '3 people'
 6= '4 people'
 7= '5 people'
 8= '6 or more people';

value yesnosi /*Q62, Q63*/
 1= 'I have never had sexual intercourse'
 2= 'Yes'
 3= 'No';

value Q64N /*birth control*/
 1= 'I have never had sexual intercourse'
 2= 'No method was used to prevent pregnancy'
 3= 'Birth control pills'
 4= 'Condoms'
 5= 'Depo-Provera (injectable birth control)'
 6= 'Withdrawal'
 7= 'Some other method'
 8= 'Not sure';

value Q65N /*describe weight*/
 1= 'Very underweight'
 2= 'Slightly underweight'
 3= 'About the right weight'
 4= 'Slightly overweight'
 5= 'Very overweight';

value Q66N /*plans for weight*/
 1= 'Lose weight'
 2= 'Gain weight'
 3= 'Stay the same weight'
 4= 'I am not trying to do anything about my weight';

value Q72N /*fruit juice*/
 1= 'I did not drink 100% fruit juice during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q73N /*fruits*/
 1= 'I did not eat fruit during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q78N /*soda*/
 1= 'I did not drink soda or pop during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q79N /*milk*/
 1= 'I did not drink milk during the past 7 days'
 2= '1 to 3 glasses during the past 7 days'
 3= '4 to 6 glasses during the past 7 days'
 4= '1 glass per day'
 5= '2 glasses per day'
 6= '3 glasses per day'
 7= '4 or more glasses per day';

value days7q /*Q80,*/
 1= '0 days'
 2= '1 day'
 3= '2 days'
 4= '3 days'
 5= '4 days'
 6= '5 days'
 7= '6 days'
 8= '7 days';

value Q81N /*tv*/
 1= 'I do not watch TV on an average school day'
 2= 'Less than 1 hour per day'
 3= '1 hour per day'
 4= '2 hours per day'
 5= '3 hours per day'
 6= '4 hours per day'
 7= '5 or more hours per day';

value Q82N /*video*/
 1= 'I do not play video or computer games or use a computer for something that is not school work'
 2= 'Less than 1 hour per day'
 3= '1 hour per day'
 4= '2 hours per day'
 5= '3 hours per day'
 6= '4 hours per day'
 7= '5 or more hours per day';

value Q83N /*days in PE*/
 1= '0 days'
 2= '1 day'
 3= '2 days'
 4= '3 days'
 5= '4 days'
 6= '5 days';

value Q84N /*sports teams*/
 1= '0 teams'
 2= '1 team'
 3= '2 teams'
 4= '3 or more teams';

value yesnons /*Q85, Q86, Q109*/
 1= 'Yes'
 2= 'No'
 3= 'Not sure';

value Q88N /*yrs US*/
 1= 'Less than one year'
 2= '1 to 3 years'
 3= '4 to 6 years'
 4= '7 or more years';

value boro /*borough, Q89*/
 1= 'Bronx'
 2= 'Brooklyn'
 3= 'Manhattan'
 4= 'Queens'
 5= 'Staten Island';

value Q90N /*english at home*/
 1= 'Never'
 2= 'Rarely'
 3= 'Sometimes'
 4= 'Most of the time'
 5= 'Always';

value Q91N /*usual cig buy*/
 1= 'I did not smoke cigarettes during the past 30 days'
 2= 'I bought them in a store such as a convenience store, supermarket, or gas station'
 3= 'I bought them on the Internet'
 4= 'I bummed them'
 5= 'Someone gave them to me or bought them for me'
 6= 'I stole them'
 7= 'I got them some other way';

value Q92N /*who got cig from*/
 1= 'I did not bum, steal, or get cigarettes from anyone during the past 30 days'
 2= '17 years old or younger'
 3= '18 to 20 years old'
 4= '21 years old or older';

value Q94N /*times sex*/
 1= '0 times'
 2= '1 to 3 times'
 3= '4 to 7 times'
 4= '8 or more times';

value Q95N /*age of sex partner*/
 1= 'I have never had sexual intercourse'
 2= '12 years old or younger'
 3= '13 to 14 years old'
 4= '15 to 17 years old'
 5= '18 to 20 years old'
 6= '21 to 24 years old'
 7= '25 years old or older'
 8= 'Not sure';

value Q96N /*gender of sex partner*/
 1= 'I have never had sexual contact'
 2= 'Females'
 3= 'Males'
 4= 'Females and males';

value Q97N /*sexual identity*/
 1= 'Heterosexual or straight'
 2= 'Gay or lesbian'
 3= 'Bisexual'
 4= 'Not sure';

value Q98N /*num preg*/
 1= '0 times'
 2= '1 time'
 3= '2 or more times'
 4= 'Not sure';

value Q100N /*ate vegetables*/
 1= 'I did not eat vegetables during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q101N /*ate french fries*/
 1= 'I did not eat french fries, fried potatoes, or potato chips during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q102N /*drank soda*/
 1= 'I did not drink other sweetened drinks during the past 7 days'
 2= '1 to 3 times during the past 7 days'
 3= '4 to 6 times during the past 7 days'
 4= '1 time per day'
 5= '2 times per day'
 6= '3 times per day'
 7= '4 or more times per day';

value Q103N /*drink milk*/
 1= 'I do not drink milk'
 2= 'Whole milk'
 3= '2% milk or reduced fat milk'
 4= '1% milk or low-fat milk'
 5= 'Skim milk or non-fat milk'
 6= 'Soy milk'
 7= 'Not sure';

value Q104N /*bike or walk to school*/
 1= '0 days'
 2= '1 day'
 3= '2 days'
 4= '3 days'
 5= '4 days'
 6= '5 or more days';

value Q105N /*mode to school*/
 1= 'I do not regularly walk or bike to school or walk or bike to public transportation to get to school'
 2= 'I mostly walk to school'
 3= 'I mostly bike to school'
 4= 'I mostly walk to public transportation to get to school'
 5= 'I mostly bike to public transportation to get to school';

value Q106N /*travel time to school*/
 1= 'I do not walk or bike to school'
 2= '10 minutes or less'
 3= '11 to 20 minutes'
 4= '21 to 30 minutes'
 5= '31 to 59 minutes'
 6= '60 minutes or more';

value Q107N /*exercise in PE class*/
 1= 'I do not take PE'
 2= 'Less than 10 minutes'
 3= '10 to 20 minutes'
 4= '21 to 30 minutes'
 5= '31 to 40 minutes'
 6= '41 to 50 minutes'
 7= '51 to 60 minutes'
 8= 'More than 60 minutes';

value Q108N /*last checkup*/
 1= 'During the past year'
 2= '1 to 2 years ago'
 3= 'More than 2 years ago'
 4= 'Not sure';

value Q110N /*asthma episode*/
 1= 'I have never had asthma'
 2= 'Yes'
 3= 'No'
 4= 'Not sure';

value Q111N /*support scale*/
 1= 'Strongly agree'
 2= 'Agree'
 3= 'Not sure'
 4= 'Disagree'
 5= 'Strongly disagree';

value $race8q /*raceeth in 8 categories*/
 '1'= 'Am Indian / Alaska Native'
 '2'= 'Asian'
 '3'= 'Black or African American'
 '4'= 'Native Hawaiian/other PI'
 '5'= 'White'
 '6'= 'Hispanic/Latino'
 '7'= 'Multiple - Hispanic'
 '8'= 'Multiple - non-Hispanic';

value race5r /*race in BES and comparable categories with Epi Query*/
 1= 'White'
 2= 'Black'
 3= 'Hispanic'
 4= 'Asian'
 5= 'Other (Am Ind, Native Hawaiian/other PI and multiple)';

value dpho
 1='Bronx DPHO'
 2='Brooklyn DPHO'
 3='East & Central Harlem DPHO'
 4='Non-DPHO';
run;