* This SPSS program reads ASCII format (text format) 2021 SADC MS data and creates a formatted
and labeled SPSS data file that you can analyze in SPSS.

* Change the file location specifications from 'c:\SADC2021' to the location where you
downloaded, unzipped, and stored the 2021 SADC MS ASCII data file before you run this syntax;

* Change 'xxxxxxx' in the 'data list' statement and the 'save' and 'get' statements at the
end of this syntax file to 'district', 'state_a_m', or 'state_n_z' depending on which
file you are analyzing.

DATA LIST FILE='c:\SADC2021\SADC_MS_2021_xxxxxxx.dat'/
sitecode 1-5 (A)
sitename 6-55 (A)
sitetype 56-105 (A)
sitetypenum 106-113
year 114-121
survyear 122-129
weight 130-139
stratum 140-147
PSU 148-155
record 156-163
age 164-166
sex 167-174
grade 175-177
race4 178-180
race7 181-183
q6 184-184 (A)
q7 185-185 (A)
q8 186-186 (A)
q9 187-187 (A)
q10 188-188 (A)
q11 189-189 (A)
q12 190-190 (A)
q13 191-191 (A)
q14 192-192 (A)
q15 193-193 (A)
q16 194-194 (A)
q17 195-195 (A)
q18 196-196 (A)
q19 197-197 (A)
q20 198-198 (A)
q21 199-199 (A)
q22 200-200 (A)
q23 201-201 (A)
q24 202-202 (A)
q25 203-203 (A)
q26 204-204 (A)
q27 205-205 (A)
q28 206-206 (A)
q29 207-207 (A)
q30 208-208 (A)
q31 209-209 (A)
q32 210-210 (A)
q33 211-211 (A)
q34 212-212 (A)
q35 213-213 (A)
q36 214-214 (A)
q37 215-215 (A)
q38 216-216 (A)
q39 217-217 (A)
q40 218-218 (A)
q41 219-219 (A)
q42 220-220 (A)
q43 221-221 (A)
q44 222-222 (A)
q45 223-223 (A)
q46 224-224 (A)
qn6 225-227
qn7 228-230
qn8 231-233
qn9 234-236
qn10 237-239
qn11 240-242
qn12 243-245
qn13 246-248
qn14 249-251
qn15 252-254
qn16 255-257
qn17 258-260
qn18 261-263
qn19 264-266
qn20 267-269
qn21 270-272
qn22 273-275
qn23 276-278
qn24 279-281
qn25 282-284
qn26 285-287
qn27 288-290
qn28 291-293
qn29 294-296
qn30 297-299
qn31 300-302
qn32 303-305
qn33 306-308
qn34 309-311
qn35 312-314
qn36 315-317
qn37 318-320
qn38 321-323
qn39 324-326
qn40 327-329
qn41 330-332
qn42 333-335
qn43 336-338
qn44 339-341
qn45 342-344
qn46 345-347
qnfrcig 348-350
qndaycig 351-353
qnfrevp 354-356
qndayevp 357-359
qnfrskl 360-362
qndayskl 363-365
qnfrcgr 366-368
qndaycgr 369-371
qntb2 372-374
qntb3 375-377
qntb4 378-380
qntb5 381-383
qnbk7day 384-386
qnpa0day 387-389
qnpa7day 390-392
qndlype 393-395.
EXECUTE.

VARIABLE LABELS
sitecode "Site code"
sitename "Site name"
sitetype "Site type"
sitetypenum "1=District, 2=State"
year "4-digit Year of survey"
survyear "1=1995...14=2021"
weight "Overall Analysis Weight"
stratum "Sampling Strata"
PSU "Primary Sampling Unit"
record "Record ID"
age "1= <=10...7=16+ years old"
sex "1=Female, 2=Male"
grade "1=6th...3=8th grade"
race4 "4-level race variable"
race7 "7-level race variable"
Q6="Bicycle helmet use"
Q7="Rollerblading helmet use"
Q8="Seat belt use"
Q9="Riding with a drinking driver"
Q10="Physical fighting "
Q11="Saw physical violence in neighborhood"
Q12="Bullying at school"
Q13="Electronic Bullying"
Q14="Suicide consideration"
Q15="Suicide plan"
Q16="Attempted suicide"
Q17="Ever cigarette use"
Q18="Initiation of cigarette smoking"
Q19="Current cigarette use"
Q20="Smoked >10 cigarettes"
Q21="Electronic vapor product use"
Q22="Current electronic vapor product use"
Q23="Current smokeless tobacco use"
Q24="Current cigar use"
Q25="Ever alcohol use"
Q26="Initiation of alcohol use"
Q27="Ever marijuana use"
Q28="Initiation of marijuana use"
Q29="Ever prescription pain medicine use"
Q30="Ever cocaine use"
Q31="Ever inhalant use"
Q32="Ever sexual intercourse"
Q33="Sex before 11 years"
Q34="Number of sex partners"
Q35="Condom use"
Q36="Perception of weight"
Q37="Weight loss"
Q38="Breakfast eating"
Q39="Physical activity >= 5 days"
Q40="Screen time"
Q41="PE attendance"
Q42="Sports team participation"
Q43="Concussion"
Q44="Current mental health"
Q45="Hours of sleep on school night"
Q46="Homelessness"
QN6="Rarely or never wore a bicycle helmet"
QN7="Rarely or never wore a helmet when rollerblading or skateboarding"
QN8="Did not always wear a seat belt"
QN9="Ever rode with a driver who had been drinking alcohol"
QN10="Were ever in a physical fight"
QN11="Ever saw someone get physically attacked, beaten, stabbed, or shot in their neighborhood"
QN12="Were ever bullied on school property"
QN13="Were ever electronically bullied"
QN14="Ever seriously thought about killing themselves"
QN15="Ever made a plan about how they would kill themselves"
QN16="Ever tried to kill themselves"
QN17="Ever tried cigarette smoking"
QN18="Tried cigarette smoking for the first time before age 11 years"
QN19="Currently smoked cigarettes"
QN20="Smoked more than 10 cigarettes per day"
QN21="Ever used an electronic vapor product"
QN22="Currently used an electronic vapor product"
QN23="Currently used smokeless tobacco"
QN24="Currently smoked cigars"
QN25="Ever drank alcohol"
QN26="Drank alcohol for the first time before age 11 years "
QN27="Ever used marijuana"
QN28="Tried marijuana for the first time before age 11 years "
QN29="Ever took prescription pain medicine without a doctor's prescription or differently than how a doctor told them to use it"
QN30="Ever used cocaine"
QN31="Ever used inhalants"
QN32="Ever had sexual intercourse"
QN33="Had sexual intercourse for the first time before age 11 years"
QN34="Ever had sexual intercourse with three or more persons"
QN35="Used a condom during last sexual intercourse"
QN36="Described themselves as slightly or very overweight"
QN37="Were trying to lose weight"
QN38="Did not eat breakfast"
QN39="Were physically active at least 60 minutes per day on 5 or more days"
QN40="Spent 3 or more hours per day on screen time"
QN41="Attended physical education classes (PE) on 1 or more days"
QN42="Played on at least one sports team"
QN43="Had a concussion from playing a sport or being physically active "
QN44="Reported that their mental health was most of the time or always not good"
QN45="Got 8 or more hours of sleep"
QN46="Usually did not sleep in their parent's or guardian's home"
qnfrcig "Currently smoked cigarettes frequently"
qndaycig "Currently smoked cigarettes daily"
qnfrevp "Currently used electronic vapor products frequently"
qndayevp "Currently used electronic vapor products daily"
qnfrskl "Currently used smokeless tobacco frequently"
qndayskl "Currently used smokeless tobacco daily"
qnfrcgr "Currently smoked cigars frequently"
qndaycgr "Currently smoked cigars daily"
qntb2 "Currently smoked cigarettes or cigars"
qntb3 "Currently smoked cigarettes or cigars or used smokeless tobacco"
qntb4 "Currently smoked cigarettes or cigars or used smokeless tobacco or electronic vapor products"
qntb5 "Currently smoked cigarettes or used electronic vapor products"
qnbk7day "Ate breakfast on all 7 days"
qnpa0day "Did not participate in at least 60 minutes of physical activity on at least 1 day"
qnpa7day "Were physically active at least 60 minutes per day on all 7 days"
qndlype "Attended physical education classes on all 5 days".

VALUE LABELS
sitecode
"AB" "Albuquerque, NM" 
"AK" "Alaska"
"AL" "Alabama"
"AR" "Arkansas"
"AZB" "Arizona"
"CA" "California"
"CC" "Clark County, NV"
"CE" "Cleveland, OH"
"CH" "Chicago, IL"
"CM" "Charlotte-Mecklenburg County, NC"
"CO" "Colorado"
"CT" "Connecticut"
"DA" "Dallas, TX"
"DE" "Delaware"
"DU" "Duval County, FL"
"EA" "Eaton Consortium, MI"
"FL" "Florida"
"FT" "Broward County, FL"
"FW" "Fort Worth, TX"
"GA" "Georgia"
"GE" "Genesee Consortium, MI"
"GS" "Gaston County, NC"
"HI" "Hawaii"
"HL" "Hillsborough County, FL"
"HO" "Houston, TX"
"IA" "Iowa"
"ID" "Idaho"
"IL" "Illinois"
"IN" "Indiana"
"KS" "Kansas"
"KY" "Kentucky"
"LA" "Louisiana"
"LO" "Los Angeles, CA"
"MD" "Maryland"
"ME" "Maine"
"MI" "Michigan"
"ML" "Milwaukee, WI"
"MM" "Miami-Dade County, FL"
"MO" "Missouri"
"MS" "Mississippi"
"MT" "Montana"
"NC" "North Carolina"
"ND" "North Dakota"
"NE" "Nebraska"
"NH" "New Hampshire"
"NJ" "New Jersey"
"NM" "New Mexico"
"NO" "New Orleans, LA"
"NV" "Nevada"
"NW" "Newark, NJ"
"NY" "New York"
"NYC" "New York City, NY"
"NYG" "Borough of Bronx, NY"
"NYH" "Borough of Brooklyn, NY"
"NYI" "Borough of Manhattan, NY"
"NYJ" "Borough of Queens, NY"
"NYK" "Borough of Staten Island, NY"
"OA" "Oakland, CA"
"OK" "Oklahoma"
"OL" "Orange County, FL"
"PA" "Pennsylvania"
"PB" "Palm Beach County, FL"
"PH" "Philadelphia, PA"
"PO" "Portland, OR"
"PS" "Pasco County, FL"
"RI" "Rhode Island"
"SA" "San Diego, CA"
"SB" "San Bernardino, CA"
"SC" "South Carolina"
"SD" "South Dakota"
"SE" "Seattle, WA"
"SF" "San Francisco, CA"
"SP" "Spartanburg County, SC"
"ST" "Shelby County, TN"
"TN" "Tennessee"
"TX" "Texas"
"UT" "Utah"
"VA" "Virginia"
"VT" "Vermont"
"WI" "Wisconsin"
"WV" "West Virginia"
"WY" "Wyoming"
"XX" "United States"
/
AGE
1 "10 years old or younger"
2 "11 years old"
3 "12 years old"
4 "13 years old"
5 "14 years old"
6 "15 years old"
7 "16 years old or older"
/
SEX
1 "Female"
2 "Male"
/
GRADE
1 "6th grade"
2 "7th grade"
3 "8th grade"
4 "Ungraded or other grade"
/
RACE4
1 "White"
2 "Black or African American"
3 "Hispanic/Latino"
4 "All other races"
/
RACE7
1 "Am Indian / Alaska Native"
2 "Asian"
3 "Black or African American"
4 "Hispanic/Latino"
5 "Native Hawaiian/other PI"
6 "White"
7 "Multiple - Non-Hispanic"
/
Q6
1 "Do not ride a bicycle"
2 "Never wear a helmet"
3 "Rarely wear a helmet"
4 "Sometimes wear a helmet"
5 "Most of the time wear a helmet"
6 "Always wear a helmet"
/
Q7
1 "Do not rollerblade/skateboard"
2 "Never wear a helmet"
3 "Rarely wear a helmet"
4 "Sometimes wear a helmet"
5 "Most of the time wear a helmet"
6 "Always wear a helmet"
/
Q8
1 "Never"
2 "Rarely"
3 "Sometimes"
4 "Most of the time"
5 "Always"
/
Q9
1 "Yes"
2 "No"
3 "Not sure"
/
Q10
1 "Yes"
2 "No"
/
Q11
1 "Yes"
2 "No"
/
Q12
1 "Yes"
2 "No"
/
Q13
1 "Yes"
2 "No"
/
Q14
1 "Yes"
2 "No"
/
Q15
1 "Yes"
2 "No"
/
Q16
1 "Yes"
2 "No"
/
Q17
1 "Yes"
2 "No"
/
Q18
1 "Never tried cigarette smoking"
2 "8 years old or younger"
3 "9 years old"
4 "10 years old"
5 "11 years old"
6 "12 years old"
7 "13 years old or older"
/
Q19
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"
/
Q20
1 "Did not smoke cigarettes"
2 "Less than 1 cigarette"
3 "1 cigarette"
4 "2 to 5 cigarettes"
5 "6 to 10 cigarettes"
6 "11 to 20 cigarettes"
7 "More than 20 cigarettes"
/
Q21
1 "Yes"
2 "No"
/
Q22
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"
/
Q23
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"
/
Q24
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"
/
Q25
1 "Yes"
2 "No"
/
Q26
1 "Never drank alcohol"
2 "8 years old or younger"
3 "9 years old"
4 "10 years old"
5 "11 years old"
6 "12 years old"
7 "13 years old or older"
/
Q27
1 "Yes"
2 "No"
/
Q28
1 "Never tried marijuana"
2 "8 years old or younger"
3 "9 years old"
4 "10 years old"
5 "11 years old"
6 "12 years old"
7 "13 years old or older"
/
Q29
1 "Yes"
2 "No"
/
Q30
1 "Yes"
2 "No"
/
Q31
1 "Yes"
2 "No"
/
Q32
1 "Yes"
2 "No"
/
Q33
1 "Never had sex"
2 "8 years old or younger"
3 "9 years old"
4 "10 years old"
5 "11 years old"
6 "12 years old"
7 "13 years old or older"
/
Q34
1 "Never had sex"
2 "1 person"
3 "2 people"
4 "3 people"
5 "4 people"
6 "5 people"
7 "6 or more people"
/
Q35
1 "Never had sex"
2 "Yes"
3 "No"
/
Q36
1 "Very underweight"
2 "Slightly underweight"
3 "About the right weight"
4 "Slightly overweight"
5 "Very overweight"
/
Q37
1 "Lose weight"
2 "Gain weight"
3 "Stay the same weight"
4 "Not trying to do anything"
/
Q38
1 "0 days"
2 "1 day"
3 "2 days"
4 "3 days"
5 "4 days"
6 "5 days"
7 "6 days"
8 "7 days"
/
Q39
1 "0 days"
2 "1 day"
3 "2 days"
4 "3 days"
5 "4 days"
6 "5 days"
7 "6 days"
8 "7 days"
/
Q40
1 "Less than 1 hour per day"
2 "1 hour per day"
3 "2 hours per day"
4 "3 hours per day"
5 "4 hours per day"
6 "5 or more hours per day"
/
Q41
1 "0 days"
2 "1 day"
3 "2 days"
4 "3 days"
5 "4 days"
6 "5 days"
/
Q42
1 "0 teams"
2 "1 team"
3 "2 teams"
4 "3 or more teams"
/
Q43
1 "0 times"
2 "1 time"
3 "2 times"
4 "3 times"
5 "4 or more times"
/
Q44
1 "Never"
2 "Rarely"
3 "Sometimes"
4 "Most of the time"
5 "Always"
/
Q45
1 "4 or less hours"
2 "5 hours"
3 "6 hours"
4 "7 hours"
5 "8 hours"
6 "9 hours"
7 "10 or more hours"
/
Q46
1 "Home of parent or gaurdian"
2 "Home of other people"
3 "Shelter or emergency housing"
4 "Motel or hotel"
5 "Public place"
6 "No usual place"
7 "Somewhere else"
/.

MISSING VALUES
sitecode ("     ")
sitename ("                                                  ")
sitetype ("                                                  ")
sitetypenum ("        ")
year ("        ")
survyear ("        ")
weight ("          ")
stratum ("        ")
PSU ("        ")
record ("        ")
age ("   ")
sex ("        ")
grade ("   ")
race4 ("   ")
race7 ("   ")
q6 (" ")
q7 (" ")
q8 (" ")
q9 (" ")
q10 (" ")
q11 (" ")
q12 (" ")
q13 (" ")
q14 (" ")
q15 (" ")
q16 (" ")
q17 (" ")
q18 (" ")
q19 (" ")
q20 (" ")
q21 (" ")
q22 (" ")
q23 (" ")
q24 (" ")
q25 (" ")
q26 (" ")
q27 (" ")
q28 (" ")
q29 (" ")
q30 (" ")
q31 (" ")
q32 (" ")
q33 (" ")
q34 (" ")
q35 (" ")
q36 (" ")
q37 (" ")
q38 (" ")
q39 (" ")
q40 (" ")
q41 (" ")
q42 (" ")
q43 (" ")
q44 (" ")
q45 (" ")
q46 (" ")
qn6 ("   ")
qn7 ("   ")
qn8 ("   ")
qn9 ("   ")
qn10 ("   ")
qn11 ("   ")
qn12 ("   ")
qn13 ("   ")
qn14 ("   ")
qn15 ("   ")
qn16 ("   ")
qn17 ("   ")
qn18 ("   ")
qn19 ("   ")
qn20 ("   ")
qn21 ("   ")
qn22 ("   ")
qn23 ("   ")
qn24 ("   ")
qn25 ("   ")
qn26 ("   ")
qn27 ("   ")
qn28 ("   ")
qn29 ("   ")
qn30 ("   ")
qn31 ("   ")
qn32 ("   ")
qn33 ("   ")
qn34 ("   ")
qn35 ("   ")
qn36 ("   ")
qn37 ("   ")
qn38 ("   ")
qn39 ("   ")
qn40 ("   ")
qn41 ("   ")
qn42 ("   ")
qn43 ("   ")
qn44 ("   ")
qn45 ("   ")
qn46 ("   ")
qnfrcig ("   ")
qndaycig ("   ")
qnfrevp ("   ")
qndayevp ("   ")
qnfrskl ("   ")
qndayskl ("   ")
qnfrcgr ("   ")
qndaycgr ("   ")
qntb2 ("   ")
qntb3 ("   ")
qntb4 ("   ")
qntb5 ("   ")
qnbk7day ("   ")
qnpa0day ("   ")
qnpa7day ("   ")
qndlype ("   ")."
EXECUTE.

SAVE OUTFILE "C:\sadc2021\sadc2021_ms_xxxxxxx.sav"/
/COMPRESSED.
EXECUTE.

GET FILE="C:\sadc2021\sadc2021_ms_xxxxxxx.sav"/.