* This SPSS program reads ASCII format (text format) 2023 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:\SADC2023' to the location where you
downloaded, unzipped, and stored the 2023 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:\SADC2023\SADC_MS_2023_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)
q47 225-225 (A)
q48 226-226 (A)
qn6 227-229
qn7 230-232
qn8 233-235
qn9 236-238
qn10 239-241
qn11 242-244
qn12 245-247
qn13 248-250
qn14 251-253
qn15 254-256
qn16 257-259
qn17 260-262
qn18 263-265
qn19 266-268
qn20 269-271
qn21 272-274
qn22 275-277
qn23 278-280
qn24 281-283
qn25 284-286
qn26 287-289
qn27 290-292
qn28 293-295
qn29 296-298
qn30 299-301
qn31 302-304
qn32 305-307
qn33 308-310
qn34 311-313
qn35 314-316
qn36 317-319
qn37 320-322
qn38 323-325
qn39 326-328
qn40 329-331
qn41 332-334
qn42 335-337
qn43 338-340
qn44 341-343
qn45 344-346
qn46 347-349
qn47 350-352
qn48 353-355
qnfrcig 356-358
qndaycig 359-361
qnfrevp 362-364
qndayevp 365-367
qnfrskl 368-370
qndayskl 371-373
qnfrcgr 374-376
qndaycgr 377-379
qntb2 380-382
qntb3 383-385
qntb4 386-388
qntb5 389-391
qnbk7day 392-394
qnpa0day 395-397
qnpa7day 398-400
qndlype 401-403.
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   15=2023"
weight "Overall Analysis Weight"
stratum "Analysis stratum"
PSU "Analysis primary sampling unit"
record "Record ID"
age "1= <=10...7=16+ years old"
sex "1=Female, 2=Male"
grade "1=6th...3=8th"
race4 "4-level race variable"
race7 "7 level race for Youth Online"
q6 "Bicycle helmet use"
q7 "Rollerblading helmet use"
q8 "Seat belt use"
q9 "Riding with a drinking driver"
q10 "Physical fighting"
q11 "Seen someone get physically attacked"
q12 "Treated badly because of race or ethnicity"
q13 "Bullying at school"
q14 "Electronic Bullying"
q15 "Suicide consideration"
q16 "Suicide plan"
q17 "Attempted suicide"
q18 "Ever cigarette use"
q19 "Initiation of cigarette smoking"
q20 "Current cigarette use"
q21 "Smoked >10 cigarettes"
q22 "Electronic vapor product use"
q23 "Current electronic vapor product use"
q24 "Current smokeless tobacco use"
q25 "Current cigar use"
q26 "Ever alcohol use"
q27 "Initiation of alcohol use"
q28 "Ever marijuana use"
q29 "Initiation of marijuana use"
q30 "Ever prescription pain medicine use"
q31 "Ever cocaine use"
q32 "Ever inhalant use"
q33 "Ever sexual intercourse"
q34 "Sex before 11 years"
q35 "Number of sex partners"
q36 "Condom use"
q37 "Perception of weight"
q38 "Weight loss"
q39 "Breakfast eating"
q40 "Physical activity >= 5 days"
q41 "PE attendance"
q42 "Sports team participation"
q43 "Concussion"
q44 "Social media"
q45 "Current mental health"
q46 "Sleep"
q47 "Unstable housing"
q48 "Grades in school"
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 "Felt that they were ever treated badly or unfairly in school because of their race or etnicity"
qn13 "Were ever bullied on school property"
qn14 "Were ever electronically bullied"
qn15 "Ever seriously thought about killing themselves"
qn16 "Ever made a plan about how they would kill themselves"
qn17 "Smoked a cigarette for the first time before age 11 years"
qn18 "Ever smoked a cigarette"
qn19 "Smoked a cigarette before age 11 years"
qn20 "Currently smoked cigarettes"
qn21 "Smoked more than 10 cigarettes per day"
qn22 "Ever used an electronic vapor product"
qn23 "Currently used an electronic vapor product"
qn24 "Currently used smokeless tobacco"
qn25 "Currently smoked cigars"
qn26 "Ever drank alcohol"
qn27 "Drank alcohol for the first time before age 11 years"
qn28 "Ever used marijuana"
qn29 "Tried marijuana for the first time before age 11 years"
qn30 "Ever took prescription pain medicine without a doctor's prescription or differently than how a doctor told them to use it"
qn31 "Ever used cocaine"
qn32 "Ever used inhalants"
qn33 "Ever had sexual intercourse"
qn34 "Had sexual intercourse for the first time before age 11 years"
qn35 "Ever had sexual intercourse with three or more persons"
qn36 "Used a condom during last sexual intercourse"
qn37 "Described themselves as slightly or very overweight"
qn38 "Were trying to lose weight"
qn39 "Did not eat breakfast"
qn40 "Were physically active at least 60 minutes per day on 5 or more days"
qn41 "Attended physical education (PE) classes 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 "Used social media several times a day"
qn45 "Reported that their mental health was most of the time or always not good"
qn46 "Get 8 or more hours of sleep"
qn47 "Experienced unstable housing"
qn48 "Described their grades in school as mostly A's or B's"
qnfrcig "Currently smoked cigarettes frequently"
qndaycig "Currently smoked cigarettes daily"
qnfrevp "Currently smoked 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 (PE) 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"
"MA" "Massachusetts"
"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"
"NYA" "New York (Excluding NYC)"
"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 "Never"
2 "Rarely"
3 "Sometimes"
4 "Most of the time"
5 "Always"
/
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 "Yes"
2 "No"
/
Q19
1 "Never smoked a cigarette"
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"
/
Q20
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"
/
Q21
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"
/
Q22
1 "Yes"
2 "No"
/
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 "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"
/
Q26
1 "Yes"
2 "No"
/
Q27
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"
/
Q28
1 "Yes"
2 "No"
/
Q29
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"
/
Q30
1 "Yes"
2 "No"
/
Q31
1 "Yes"
2 "No"
/
Q32
1 "Yes"
2 "No"
/
Q33
1 "Yes"
2 "No"
/
Q34
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"
/
Q35
1 "Never had sex"
2 "1 person"
3 "2 people"
4 "3 people"
5 "4 people"
6 "5 people"
7 "6 or more people"
/
Q36
1 "Never had sex"
2 "Yes"
3 "No"
/
Q37
1 "Very underweight"
2 "Slightly underweight"
3 "About the right weight"
4 "Slightly overweight"
5 "Very overweight"
/
Q38
1 "Lose weight"
2 "Gain weight"
3 "Stay the same weight"
4 "Not trying to do anything"
/
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 "0 days"
2 "1 day"
3 "2 days"
4 "3 days"
5 "4 days"
6 "5 days"
7 "6 days"
8 "7 days"
/
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 "I do not use social media"
2 "A few times a month"
3 "About once a week"
4 "A few times a week"
5 "About once a day"
6 "Several times a day"
7 "About once an hour"
8 "More than once an hour"
/
Q45
1 "Never"
2 "Rarely"
3 "Sometimes"
4 "Most of the time"
5 "Always"
/
Q46
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"
/
Q47
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"
/
Q48
1 "Mostly A's"
2 "Mostly B's"
3 "Mostly C's"
4 "Mostly D's"
5 "Mostly F's"
6 "None of these grades"
7 "Not sure"
/.

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 (" ")
q47 (" ")
q48 (" ")
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 ("   ")
qn47 ("   ")
qn48 ("   ")
qnfrcig ("   ")
qndaycig ("   ")
qnfrevp ("   ")
qndayevp ("   ")
qnfrskl ("   ")
qndayskl ("   ")
qnfrcgr ("   ")
qndaycgr ("   ")
qntb2 ("   ")
qntb3 ("   ")
qntb4 ("   ")
qntb5 ("   ")
qnbk7day ("   ")
qnpa0day ("   ")
qnpa7day ("   ")
qndlype ("   ")."
EXECUTE.

SAVE OUTFILE "C:\sadc2023\sadc2023_ms_xxxxxxx.sav"/
/COMPRESSED.
EXECUTE.

GET FILE="C:\sadc2023\sadc2023_ms_xxxxxxx.sav"/.