/***/
/*  This SAS program reads ASCII format (text format) 2023 SADC data and creates a      */
/*  formatted and labeled SAS dataset.                                                  */
/*                                                                                      */
/*  Change the file location specifications from 'c:\sadc2023' 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            */
/*  'national', 'district', 'state_a_d', 'state_e_h', 'state_i_l', 'state_m',           */
/*  'state_n_p','state_q_t', or 'state_u_z' depending on which file you are analyzing.  */
/*                                                                                      */
/*  Note: Run '2023 SADC SAS Formats Program.sas' BEFORE you run                        */
/*  '2023 SADC SAS Input Program.sas' to create the 2023SADC dataset.                   */
/***/
 
filename datain 'c:\sadc2023\sadc_2023_xxxxxxx.dat';
libname dataout 'c:\sadc2023';
libname library 'c:\sadc2023';
data dataout.sadc_2023_xxxxxxx;
infile datain lrecl=900;
input
sitecode $ 1-5
sitename $ 6-55
sitetype $ 56-105
sitetypenum 106-113
year 114-121
survyear 122-124
weight 125-134
stratum 135-142
PSU 143-150
record 151-158
age 159-161
sex 162-164
grade 165-167
race4 168-170
race7 171-173
stheight 174-181
stweight 182-189
bmi 190-197
bmipct 198-205
qnobese 206-208
qnowt 209-211
q65 $ 212-212
q64 $ 213-213
q63 $ 214-214
sexid 215-222
sexid2 223-230
sexpart 231-238
sexpart2 239-246
transg 247-254
sextrans 255-262
q8 $ 263-263
q9 $ 264-264
q10 $ 265-265
q11 $ 266-266
q12 $ 267-267
q13 $ 268-268
q14 $ 269-269
q15 $ 270-270
q16 $ 271-271
q17 $ 272-272
q18 $ 273-273
q19 $ 274-274
q20 $ 275-275
q21 $ 276-276
q22 $ 277-277
q23 $ 278-278
q24 $ 279-279
q25 $ 280-280
q26 $ 281-281
q27 $ 282-282
q28 $ 283-283
q29 $ 284-284
q30 $ 285-285
q31 $ 286-286
q32 $ 287-287
q33 $ 288-288
q34 $ 289-289
q35 $ 290-290
q36 $ 291-291
q37 $ 292-292
q38 $ 293-293
q39 $ 294-294
q40 $ 295-295
q41 $ 296-296
q42 $ 297-297
q43 $ 298-298
q44 $ 299-299
q45 $ 300-300
q46 $ 301-301
q47 $ 302-302
q48 $ 303-303
q49 $ 304-304
q50 $ 305-305
q51 $ 306-306
q52 $ 307-307
q53 $ 308-308
q54 $ 309-309
q55 $ 310-310
q56 $ 311-311
q57 $ 312-312
q58 $ 313-313
q59 $ 314-314
q60 $ 315-315
q61 $ 316-316
q62 $ 317-317
q66 $ 318-318
q67 $ 319-319
q68 $ 320-320
q69 $ 321-321
q70 $ 322-322
q71 $ 323-323
q72 $ 324-324
q73 $ 325-325
q74 $ 326-326
q75 $ 327-327
q76 $ 328-328
q77 $ 329-329
q78 $ 330-330
q79 $ 331-331
q80 $ 332-332
q81 $ 333-333
q82 $ 334-334
q83 $ 335-335
q84 $ 336-336
q85 $ 337-337
q86 $ 338-338
q87 $ 339-339
qn8 340-342
qn9 343-345
qn10 346-348
qn11 349-351
qn12 352-354
qn13 355-357
qn14 358-360
qn15 361-363
qn16 364-366
qn17 367-369
qn18 370-372
qn19 373-375
qn20 376-378
qn21 379-381
qn22 382-384
qn23 385-387
qn24 388-390
qn25 391-393
qn26 394-396
qn27 397-399
qn28 400-402
qn29 403-405
qn30 406-408
qn31 409-411
qn32 412-414
qn33 415-417
qn34 418-420
qn35 421-423
qn36 424-426
qn37 427-429
qn38 430-432
qn39 433-435
qn40 436-438
qn41 439-441
qn42 442-444
qn43 445-447
qn44 448-450
qn45 451-453
qn46 454-456
qn47 457-459
qn48 460-462
qn49 463-465
qn50 466-468
qn51 469-471
qn52 472-474
qn53 475-477
qn54 478-480
qn55 481-483
qn56 484-486
qn57 487-489
qn58 490-492
qn59 493-495
qn60 496-498
qn61 499-501
qn62 502-504
qn66 505-507
qn67 508-510
qn68 511-513
qn69 514-516
qn70 517-519
qn71 520-522
qn72 523-525
qn73 526-528
qn74 529-531
qn75 532-534
qn76 535-537
qn77 538-540
qn78 541-543
qn79 544-546
qn80 547-549
qn81 550-552
qn82 553-555
qn83 556-558
qn84 559-561
qn85 562-564
qn86 565-567
qn87 568-570
qnfrcig 571-573
qndaycig 574-576
qnfrevp 577-579
qndayevp 580-582
qnfrskl 583-585
qndayskl 586-588
qnfrcgr 589-591
qndaycgr 592-594
qntb2 595-597
qntb3 598-600
qntb4 601-603
qntb5 604-606
qniudimp 607-609
qnothhpl 610-612
qnbcnone 613-615
qnfr0 616-618
qnfr1 619-621
qnfr2 622-624
qnveg0 625-627
qnveg1 628-630
qnveg2 631-633
qnveg3 634-636
qnsoda1 637-639
qnsoda2 640-642
qnbk7day 643-645
qnpa0day 646-648
qnpa7day 649-651
qndlype 652-654
qnnodnt 655-657
qbasicneedsace $ 658-658
qclose2people $ 659-659
qconsentsexcont $ 660-660
qcurrentopioid $ 661-661
qemoabuseace $ 662-662
qhallucdrug $ 663-663
qincarparentace $ 664-664
qintviolenceace $ 665-665
qlivedwabuseace $ 666-666
qlivedwillace $ 667-667
qmusclestrength $ 668-668
qparentalmonitoring $ 669-669
qphyabuseace $ 670-670
qphyviolenceace $ 671-671
qsexabuseace $ 672-672
qsportsdrink $ 673-673
qsunburn $ 674-674
qtalkadultace $ 675-675
qtalkfriendace $ 676-676
qtransgender $ 677-677
qtreatbadlyace $ 678-678
qunfairlyace $ 679-679
qunfairlydisc $ 680-680
qverbalabuseace $ 681-681
qwater $ 682-682
qnbasicneedsace 683-685
qnclose2people 686-688
qnconsentsexcont 689-691
qncurrentopioid 692-694
qnemoabuseace 695-697
qnhallucdrug 698-700
qnillict 701-703
qnincarparentace 704-706
qnintviolenceace 707-709
qnlivedwabuseace 710-712
qnlivedwillace 713-715
qnmusclestrength 716-718
qnparentalmonitoring 719-721
qnphyabuseace 722-724
qnphyviolenceace 725-727
qnsexabuseace 728-730
qnsportsdrink 731-733
qnspdrk1 734-736
qnspdrk2 737-739
qnsunburn 740-742
qntalkadultace 743-745
qntalkfriendace 746-748
qntransgender 749-751
qntreatbadlyace 752-754
qnunfairlyace 755-757
qnunfairlydisc 758-760
qnverbalabuseace 761-763
qnwater 764-766
qnwater1 767-769
qnwater2 770-772
qnwater3 773-775
;
 
//
/*   Assign formats to SAS variables    */
//
;
format
sitecode $SITE.
age AGE.
sex SEX.
grade GRADE.
race4 RACE.
race7 RACE7S.
q65 $H65S.
q64 $H64S.
q63 $H63S.
sexid SEXID.
sexid2 SEXIDB.
sexpart SEXPART.
sexpart2 SEXPARTB.
transg TRANS.
sextrans SGI.
q8 $H8S.
q9 $H9S.
q10 $H10S.
q11 $H11S.
q12 $H12S.
q13 $H13S.
q14 $H14S.
q15 $H15S.
q16 $H16S.
q17 $H17S.
q18 $H18S.
q19 $H19S.
q20 $H20S.
q21 $H21S.
q22 $H22S.
q23 $H23S.
q24 $H24S.
q25 $H25S.
q26 $H26S.
q27 $H27S.
q28 $H28S.
q29 $H29S.
q30 $H30S.
q31 $H31S.
q32 $H32S.
q33 $H33S.
q34 $H34S.
q35 $H35S.
q36 $H36S.
q37 $H37S.
q38 $H38S.
q39 $H39S.
q40 $H40S.
q41 $H41S.
q42 $H42S.
q43 $H43S.
q44 $H44S.
q45 $H45S.
q46 $H46S.
q47 $H47S.
q48 $H48S.
q49 $H49S.
q50 $H50S.
q51 $H51S.
q52 $H52S.
q53 $H53S.
q54 $H54S.
q55 $H55S.
q56 $H56S.
q57 $H57S.
q58 $H58S.
q59 $H59S.
q60 $H60S.
q61 $H61S.
q62 $H62S.
q66 $H66S.
q67 $H67S.
q68 $H68S.
q69 $H69S.
q70 $H70S.
q71 $H71S.
q72 $H72S.
q73 $H73S.
q74 $H74S.
q75 $H75S.
q76 $H76S.
q77 $H77S.
q78 $H78S.
q79 $H79S.
q80 $H80S.
q81 $H81S.
q82 $H82S.
q83 $H83S.
q84 $H84S.
q85 $H85S.
q86 $H86S.
q87 $H87S.
qbasicneedsace $ACE2F.
qclose2people $CLPL.
qconsentsexcont $SEXCON.
qcurrentopioid $CURROPI.
qemoabuseace $ACE2F.
qhallucdrug $LSD.
qincarparentace $ACE1F.
qintviolenceace $ACE2F.
qlivedwabuseace $ACE1F.
qlivedwillace $ACE1F.
qmusclestrength $MUSCLE.
qparentalmonitoring $ACE2F.
qphyabuseace $ACE2F.
qphyviolenceace $ACE3F.
qsexabuseace $ACE1F.
qsportsdrink $SPRTDRNK.
qsunburn $SUNBURN.
qtalkadultace $ACE2F.
qtalkfriendace $ACE2F.
qtransgender $TRNS.
qtreatbadlyace $ACE2F.
qunfairlyace $ACE2F.
qunfairlydisc $DISPLI.
qverbalabuseace $ACE3F.
qwater $WATER.
;
 
//
/*   Assign labels to SAS variables    */
//
;
label
sitecode="Site code"
sitename="Site name"
sitetype="Site type"
sitetypenum="1=District, 2=State, 3=National"
year="4-digit Year of survey"
survyear="1=1991...17=2023"
weight="Analysis weight"
stratum="Analysis stratum"
PSU="Analysis primary sampling unit"
record="Record ID"
age="1= <=12...7=18+ years old"
sex="1=female, 2=male"
grade="1=9th...4=12th grade"
race4="4-level race variable"
race7="7-level race variable"
stheight="Height in meters"
stweight="Weight in kilograms"
bmi="Body Mass Index"
bmipct="BMI percentile"
qnobese="Had obesity"
qnowt="Were overweight"
q65="Transgender"
q64="Sexual identity"
q63="Sex of sexual contacts"
sexid="Sexual identity"
sexid2="Collapsed sexual identity"
sexpart="Sex of sex contact(s)"
sexpart2="Collapsed sex of sex contact(s)"
transg="Transgender for YOL"
sextrans="Sexual and Gender Identity for YOL"
q8="Seat belt use"
q9="Riding with a drinking driver"
q10="Drinking and driving"
q11="Texting and driving"
q12="Weapon carrying at school"
q13="Gun carrying"
q14="Safety concerns at school"
q15="Threatened at school"
q16="Physical fighting"
q17="Physical fighting at school"
q18="Saw physical violence in neighborhood"
q19="Forced sexual intercourse"
q20="Sexual violence"
q21="Sexual dating violence"
q22="Physical dating violence"
q23="Treated badly because of race or ethnicity"
q24="Bullying at school"
q25="Electronic bullying"
q26="Sad or hopeless"
q27="Considered suicide"
q28="Made a suicide plan"
q29="Attempted suicide"
q30="Injurious suicide attempt"
q31="Ever cigarette use"
q32="Initiation of cigarette smoking"
q33="Current cigarette use"
q34="Smoked > 10 cigarettes"
q35="Electronic vapor product use"
q36="Current electronic vapor use"
q37="EVP from store"
q38="Current smokeless tobacco use"
q39="Current cigar use"
q40="All tobacco product cessation"
q41="Initiation of alcohol use"
q42="Current alcohol use"
q43="Current binge drinking"
q44="Largest number of drinks"
q45="Source of alcohol"
q46="Ever marijuana use"
q47="Initiation of marijuana use"
q48="Current marijuana use"
q49="Ever prescription pain medicine use"
q50="Ever cocaine use"
q51="Ever inhalant use"
q52="Ever heroin use"
q53="Ever methamphetamine use"
q54="Ever ecstasy use"
q55="Illegal injected drug use"
q56="Ever sexual intercourse"
q57="Sex before 13 years"
q58="Number of sex partners"
q59="Current sexual activity"
q60="Alcohol/drugs and sex"
q61="Condom use"
q62="Birth control pill use"
q66="Perception of weight"
q67="Weight loss"
q68="Fruit juice drinking"
q69="Fruit eating"
q70="Green salad eating"
q71="Potato eating"
q72="Carrot eating"
q73="Other vegetable eating"
q74="No soda drinking"
q75="Breakfast eating"
q76="Physical activity >= 5 days"
q77="PE attendance"
q78="Sports team participation"
q79="Concussion"
q80="Social media"
q81="HIV testing"
q82="STD testing"
q83="Oral health care"
q84="Current mental health"
q85="Sleep"
q86="Unstable housing"
q87="Grades in school"
qn8="Did not always wear a seat belt"
qn9="Rode with a driver who had been drinking alcohol"
qn10="Drove a car or other vehicle when they had been drinking alcohol"
qn11="Texted or e-mailed while driving a car or other vehicle"
qn12="Carried a weapon on school property"
qn13="Carried a gun"
qn14="Did not go to school because they felt unsafe at school or on their way to or from school"
qn15="Were threatened or injured with a weapon on school property"
qn16="Were in a physical fight"
qn17="Were in a physical fight on school property"
qn18="Ever saw someone get physically attacked, beaten, stabbed, or shot in their neighborhood"
qn19="Were ever physically forced to have sexual intercourse"
qn20="Experienced sexual violence"
qn21="Experienced sexual dating violence"
qn22="Experienced physical dating violence"
qn23="Felt that they were ever treated badly or unfairly in school because of their race or ethnicity"
qn24="Were bullied on school property"
qn25="Were electronically bullied"
qn26="Felt sad or hopeless"
qn27="Seriously considered attempting suicide"
qn28="Made a plan about how they would attempt suicide"
qn29="Actually attempted suicide"
qn30="Had a suicide attempt that resulted in an injury, poisoning, or overdose that had to be treated by a doctor or nurse"
qn31="Ever smoked a cigarette"
qn32="Smoked a cigarette before age 13 years"
qn33="Currently smoked cigarettes"
qn34="Smoked more than 10 cigarettes per day"
qn35="Ever used an electronic vapor product"
qn36="Currently used an electronic vapor product"
qn37="Usually got their electronic vapor products by buying them themselves in a convenience store, supermarket, discount store, or gas station"
qn38="Currently used smokeless tobacco"
qn39="Currently smoked cigars"
qn40="Tried to quit using all tobacco products"
qn41="Had their first drink of alcohol before age 13 years"
qn42="Currently drank alcohol"
qn43="Currently were binge drinking"
qn44="Reported that the largest number of drinks they had in a row was 10 or more"
qn45="Usually got the alcohol they drank by someone giving it to them"
qn46="Ever used marijuana"
qn47="Tried marijuana for the first time before age 13 years"
qn48="Currently used marijuana"
qn49="Ever took prescription pain medicine without a doctor's prescription or differently than how a doctor told them to use it"
qn50="Ever used cocaine"
qn51="Ever used inhalants"
qn52="Ever used heroin"
qn53="Ever used methamphetamines"
qn54="Ever used ecstasy"
qn55="Ever injected any illegal drug"
qn56="Ever had sexual intercourse"
qn57="Had sexual intercourse for the first time before age 13 years"
qn58="Had sexual intercourse with four or more persons during their life"
qn59="Were currently sexually active"
qn60="Drank alcohol or used drugs before last sexual intercourse"
qn61="Used a condom during last sexual intercourse"
qn62="Used birth control pills before last sexual intercourse with opposite-sex partner"
qn66="Described themselves as slightly or very overweight"
qn67="Were trying to lose weight"
qn68="Did not drink fruit juice"
qn69="Did not eat fruit"
qn70="Did not eat salad"
qn71="Did not eat potatoes"
qn72="Did not eat carrots"
qn73="Did not eat other vegetables"
qn74="Did not drink a can, bottle, or glass of soda or pop"
qn75="Did not eat breakfast"
qn76="Were physically active at least 60 minutes per day on 5 or more days"
qn77="Attended physical education (PE) classes on 1 or more days"
qn78="Played on at least one sports team"
qn79="Had a concussion from playing a sport or being physically active"
qn80="Used social media several times a day"
qn81="Were ever tested for human immunodeficiency virus (HIV)"
qn82="Were tested for a sexually transmitted disease (STD) other than HIV"
qn83="Saw a dentist"
qn84="Reported that their mental health was most of the time or always not good"
qn85="Got 8 or more hours of sleep"
qn86="Experience unstable housing"
qn87="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 smoked 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"
qniudimp="Used an IUD (such as Mirena or ParaGard) or implant (such as Implanon or Nexplanon) before last sexual intercourse with an opposite-sex partner"
qnothhpl="Used birth control pills; an IUD (such as Mirena or ParaGard) or implant (such as Implanon or Nexplanon); or a shot (such as Depo-Provera), patch (such as OrthoEvra), or birth control ring (such as NuvaRing) before last sexual intercourse with an opposite-"
qnbcnone="Did not use any method to prevent pregnancy during last sexual intercourse with an opposite-sex partner"
qnfr0="Did not eat fruit or drink 100% fruit juices"
qnfr1="Ate fruit or drank 100% fruit juices one or more times per day"
qnfr2="Ate fruit or drank 100% fruit juices two or more times per day"
qnveg0="Did not eat vegetables"
qnveg1="Ate vegetables one or more times per day"
qnveg2="Ate vegetables two or more times per day"
qnveg3="Ate vegetables three or more times per day"
qnsoda1="Drank a can, bottle, or glass of soda or pop one or more times per day"
qnsoda2="Drank a can, bottle, or glass of soda or pop two or more times per day"
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"
qnnodnt="Never saw a dentist"
qbasicneedsace="Household adult tried hard to meet basic needs ACEs"
qclose2people="Feel close to people at their school"
qconsentsexcont="Verbally asked for consent last sexual contact"
qcurrentopioid="Current Rx Pain med w/out Rx"
qemoabuseace="Parental emotional abuse ACEs"
qhallucdrug="Ever used hallucinogenic drugs"
qincarparentace="Ever incarcerated parent/guardian ACEs"
qintviolenceace="Adults in home intimate partner violence ACEs"
qlivedwabuseace="Ever lived w/parent/guardian w/substance abuse ACEs"
qlivedwillace="Ever lived with parent/guardian w mental illness ACEs"
qmusclestrength="Muscle strengthening"
qparentalmonitoring="Parental monitoring"
qphyabuseace="Parental physical abuse ACEs"
qphyviolenceace="Past 12-month incidence of physical violence"
qsexabuseace="Ever sexual abuse by adult or older person ACEs"
qsportsdrink="Sports drinks"
qsunburn="Sunburn"
qtalkadultace="Lifetime prevalence of feeling able to talk to adults about feelings"
qtalkfriendace="Lifetime prevalence of feeling supported by friends"
qtransgender="Transgender"
qtreatbadlyace="Lifetime prevalence of perceived sexual minority discrimination"
qunfairlyace="Lifetime prevalence of perceived racial/ethnic injustice"
qunfairlydisc="Unfairly disciplined at school"
qverbalabuseace="Past 12-month incidence of emotional violence"
qwater="Plain water"
qnbasicneedsace="Reported that an adult in their household most of the time or always tried to make sure their basic needs were met"
qnclose2people="Strongly agree or agree that they feel close to people at their school"
qnconsentsexcont="Verbally asked for consent the last time they had sexual contact"
qncurrentopioid="Currently took prescription pain medicine without a doctor's prescription or differently than how a doctor told them to use it"
qnemoabuseace="Reported that a parent or other adult in their home most of the time or always insulted them or put them down"
qnhallucdrug="Ever used hallucinogenic drugs"
qnillict="Ever used select illicit drugs"
qnincarparentace="Have ever been separated from a parent or guardian because they went to jail, prison, or a detention center"
qnintviolenceace="Reported that their parents or other adults in their home most of the time or always slapped, hit, kicked, punched, or beat each other up"
qnlivedwabuseace="Ever lived with a parent or guardian who was having a problem with alcohol or drug use"
qnlivedwillace="Ever lived with a parent or guardian who had severe depression, anxiety, or another mental illness, or was suicidal"
qnmusclestrength="Did exercises to strengthen or tone their muscles on three or more days"
qnparentalmonitoring="Reported that their parents or other adults in their family most of the time or always know where they are going or with whom they will be"
qnphyabuseace="Reported that a parent or other adult in their home most of the time or always hit, beat, kicked, or physically hurt them in any way"
qnphyviolenceace="Reported that a parent or other adult in their home hit, beat, kicked, or physically hurt them in any way one or more times"
qnsexabuseace="Reported that an adult or person at least 5 years older than them ever made them do sexual things they did not want to do"
qnsportsdrink="Did not drink a can, bottle, or glass of a sports drink"
qnspdrk1="Drank a can, bottle, or glass of a sports drink one or more times per day"
qnspdrk2="Drank a can, bottle, or glass of a sports drink two or more times per day"
qnsunburn="Had a sunburn"
qntalkadultace="Most of the time or always feel that they are able to talk to an adult in their family or another caring adult about their feelings"
qntalkfriendace="Most of the time or always feel that they are able to talk to a friend about their feelings"
qntransgender="Are transgender"
qntreatbadlyace="Felt that they were ever treated badly or unfairly because they are or people think they are lesbian, gay, bisexual, transgender, or questioning"
qnunfairlyace="Felt that they were treated badly or unfairly because of their race or ethnicity"
qnunfairlydisc="Have been unfairly disciplined at school"
qnverbalabuseace="Reported that a parent or other adult in their home hit, beat, kicked, or physically hurt them in any way one or more times"
qnwater="Did not drink a bottle or glass of plain water"
qnwater1="Drank a bottle or glass of plain water one or more times per day"
qnwater2="Drank a bottle or glass of plain water two or more times per day"
qnwater3="Drank a bottle or glass of plain water three or more times per day"
;
run;