/***/
/*  This SAS program reads ASCII format (text format) 2021 SADC data and creates a      */
/*  formatted and labeled SAS dataset.                                                  */
/*                                                                                      */
/*  Change the file location specifications from 'c:\SADC2021' to the location where    */
/*  you downloaded, unzipped, and stored the YRBS ASCII data file and the format        */
/*  library before you run this program.  Change the location specification in three    */
/*  places - in the 'filename'  statement and in the two 'libname' statements at the    */
/*  top of the program.                                                                 */
/*                                                                                      */
/*  Change "xxxxxxx" in the 'filename' statement and the 'data' statement to            */
/*  'district', 'state_a_m', or 'state_n_z' depending on which file you are analyzing.  */
/*                                                                                      */
/*  Note: Run '2021 SADC MS SAS Formats Program.sas' BEFORE you run                     */
/*  '2021 SADC MS SAS Input Program.sas' to create the 2021SADC MS dataset.             */
/***/
 
filename datain '\\Cdc.gov\project\NCCD_SERB_SURV\YRBS\SADC MS Dataset 2021\Programs\Files for checking before posting\sadc_ms_2021_state_a_m.dat';
/*filename datain '\\Cdc.gov\project\NCCD_SERB_SURV\YRBS\SADC MS Dataset 2021\Programs\Files for checking before posting\sadc_ms_2021_state_n_z.dat';*/
/*filename datain '\\Cdc.gov\project\NCCD_SERB_SURV\YRBS\SADC MS Dataset 2021\Programs\Files for checking before posting\sadc_ms_2021_district.dat';*/

libname dataout '\\cdc.gov\project\NCCD_SERB_SURV\YRBS\SADC MS Dataset 2021\Programs\Files for checking before posting\ICF';
libname library '\\cdc.gov\project\NCCD_SERB_SURV\YRBS\SADC MS Dataset 2021\Programs\Files for checking before posting\ICF';
data dataout.sadc_ms_2021_state_a_m;
/*data dataout.sadc_ms_2021_state_n_z;*/
/*data dataout.sadc_ms_2021_district;*/
infile datain lrecl=900;
input
sitecode $ 1-5
sitename $ 6-55
sitetype $ 56-105
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
q7 $ 185-185
q8 $ 186-186
q9 $ 187-187
q10 $ 188-188
q11 $ 189-189
q12 $ 190-190
q13 $ 191-191
q14 $ 192-192
q15 $ 193-193
q16 $ 194-194
q17 $ 195-195
q18 $ 196-196
q19 $ 197-197
q20 $ 198-198
q21 $ 199-199
q22 $ 200-200
q23 $ 201-201
q24 $ 202-202
q25 $ 203-203
q26 $ 204-204
q27 $ 205-205
q28 $ 206-206
q29 $ 207-207
q30 $ 208-208
q31 $ 209-209
q32 $ 210-210
q33 $ 211-211
q34 $ 212-212
q35 $ 213-213
q36 $ 214-214
q37 $ 215-215
q38 $ 216-216
q39 $ 217-217
q40 $ 218-218
q41 $ 219-219
q42 $ 220-220
q43 $ 221-221
q44 $ 222-222
q45 $ 223-223
q46 $ 224-224
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
;
 
//
/*   Assign formats to SAS variables    */
//
;
format
sitecode $SITE.
weight 10.4
age AGE.
sex SEX.
grade GRADE.
race4 RACE4S.
race7 RACE7S.
q6 $M6S.
q7 $M7S.
q8 $M8S.
q9 $M9S.
q10 $M10S.
q11 $M11S.
q12 $M12S.
q13 $M13S.
q14 $M14S.
q15 $M15S.
q16 $M16S.
q17 $M17S.
q18 $M18S.
q19 $M19S.
q20 $M20S.
q21 $M21S.
q22 $M22S.
q23 $M23S.
q24 $M24S.
q25 $M25S.
q26 $M26S.
q27 $M27S.
q28 $M28S.
q29 $M29S.
q30 $M30S.
q31 $M31S.
q32 $M32S.
q33 $M33S.
q34 $M34S.
q35 $M35S.
q36 $M36S.
q37 $M37S.
q38 $M38S.
q39 $M39S.
q40 $M40S.
q41 $M41S.
q42 $M42S.
q43 $M43S.
q44 $M44S.
q45 $M45S.
q46 $M46S.
;
 
//
/*   Assign labels to SAS variables    */
//
;
label
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"
;
run;