/****************************************************************************************/ /* This SAS program reads ASCII format (text format) 2016 SHPPS data and creates a */ /* formatted and labeled SAS dataset. */ /* */ /* Change the file location specifications to the location where */ /* you have stored the SHPPS 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. */ /* */ /* Note: Run "SHPPS 2016 District Formats Program.sas" BEFORE you run */ /* "xxxx_SAS_Input_Program.sas" to create the SHPPS dataset. */ /****************************************************************************************/ libname dataout 'c:\shpps2016'; libname library 'c:\shpps2016'; data dataout.dstatus2016; infile"c:\shpps2016\dstatus2016.dat" lrecl=3000; missing A C F N M ; input STCMSID 1-5 DISTCMSID 6-10 MERGE_ID 11-19 D_ACTIVE 29-33 REGION 34-38 POVERTY 39-43 CERTAIN 44-48 DIST_CONTAINS_ELEM 49-53 DIST_CONTAINS_MIDDLE 54-58 DIST_CONTAINS_HIGH 59-63 SAMPSTRA 64-68 STATAGREE 69-73 WHYREF_1 74-78 WHYREF_2 79-83 WHYREF_3 84-88 WHYREF_4 89-93 WHYREF_5 94-98 WHYREF_6 99-103 WHYREF_7 104-108 WHYREF_8 109-113 WHYREF_9 114-118 WHYREF_10 119-123 WHYREF_11 124-128 WHYREF_12 129-133 WHYREF_13 134-138 WHYREF_14 139-143 WHYREF_15 144-148 WHYREF_SPEC $149-199 OVERALLWT 12.7 @200 STATPART 216-220 HEDWT 12.7 @221 HEDM1STAT 237-241 HEDM2STAT 242-246 HEDM3STAT 247-251 HEDM4STAT 252-256 HEDM5STAT 257-261 PEDWT 12.7 @262 PEDM1STAT 278-282 PEDM2STAT 283-287 PEDM3STAT 288-292 PEDM4STAT 293-297 PEDM5STAT 298-302 HSDWT 12.7 @303 HSDSTAT 319-323 ENDWT 12.7 @324 ENDM1STAT 340-344 ENDM2STAT 345-349 ENDM3STAT 350-354 FSDWT 12.7 @355 FSDSTAT 371-375 HEDM1PART 376-380 HEDM2PART 381-385 HEDM3PART 386-390 HEDM4PART 391-395 HEDM5PART 396-400 HEDPART 401-405 PEDM1PART 406-410 PEDM2PART 411-415 PEDM3PART 416-420 PEDM4PART 421-425 PEDM5PART 426-430 PEDPART 431-435 HSDPART 436-440 ENDM1PART 441-445 ENDM2PART 446-450 ENDM3PART 451-455 ENDPART 456-460 FSDPART 461-465 ; ************************************ * Assign formats to SAS variables.* ************************************; Format STCMSID STATE. D_ACTIVE ACTIVE. REGION REGIONF. POVERTY POVERTYF. CERTAIN CERTAINF. SAMPSTRA SAMPSTRAF. STATAGREE STATAGREEF. WHYREF_1 WHYREF_2 WHYREF_3 WHYREF_4 WHYREF_5 WHYREF_6 WHYREF_7 WHYREF_8 WHYREF_9 WHYREF_10 WHYREF_11 WHYREF_12 WHYREF_13 WHYREF_14 WHYREF_15 STATUSYN. STATPART STATPARTF. HEDM1STAT HEDM2STAT HEDM3STAT HEDM4STAT HEDM5STAT PEDM1STAT PEDM2STAT PEDM3STAT PEDM4STAT PEDM5STAT HSDSTAT ENDM1STAT ENDM2STAT ENDM3STAT FSDSTAT identif. HEDM1PART HEDM2PART HEDM3PART HEDM4PART HEDM5PART HEDPART PEDM1PART PEDM2PART PEDM3PART PEDM4PART PEDM5PART PEDPART HSDPART ENDM1PART ENDM2PART ENDM3PART ENDPART FSDPART PARTIF. DIST_CONTAINS_ELEM DIST_CONTAINS_MIDDLE DIST_CONTAINS_HIGH DIST. ; *********************************** * Assign labels to SAS variables.* ***********************************; label STCMSID = 'State CMS ID' DISTCMSID = 'District CMS ID' MERGE_ID = 'Concatenated State and District ID' D_ACTIVE = 'District Active Flag in CMS' REGION = 'Region' POVERTY = 'District Poverty' CERTAIN = 'District Drawn with Certainty' STATAGREE = 'District Agreement to Participate Status' WHYREF_1 = 'District Refusal Reason-Burden for Teachers/Staff' WHYREF_2 = 'District Refusal Reason-Too Many Surveys/Standardized Tests' WHYREF_3 = 'District Refusal Reason-Poor Timing(In School Year)' WHYREF_4 = 'District Refusal Reason-Not Mandated' WHYREF_5 = 'District Refusal Reason-Administrative Change(Change in Superintendent or Principal)' WHYREF_6 = 'District Refusal Reason-Loss of Instructional Time' WHYREF_7 = 'Content is objectionable to staff and/or community' WHYREF_8 = 'School undergoing accreditation/major transition' WHYREF_9 = 'Against district/union policy' WHYREF_10 = 'Review board declined' WHYREF_11 = 'Concerns about confidentiality' WHYREF_12 = 'Not enough incentive offered' WHYREF_13 = 'Community/school tragedy (suicide/death)' WHYREF_14 = 'Bad experience with school based survey' WHYREF_15 = 'District Refusal Reason-Other' WHYREF_SPEC = 'District Refusal Reason -Specified' STATPART = 'District Participation Status' HEDM1STAT = 'Module1-Health Education Respondent Identification' HEDM2STAT = 'Module2-Health Education Respondent Identification' HEDM3STAT = 'Module3-Health Education Respondent Identification' HEDM4STAT = 'Module4-Health Education Respondent Identification' HEDM5STAT = 'Module5-Health Education Respondent Identification' PEDM1STAT = 'Module1-Physical Education Respondent Identification' PEDM2STAT = 'Module2-Physical Education Respondent Identification' PEDM3STAT = 'Module3-Physical Education Respondent Identification' PEDM4STAT = 'Module4-Physical Education Respondent Identification' PEDM5STAT = 'Module5-Physical Education Respondent Identification' HSDSTAT = 'Health Service Respondent Identification' ENDM1STAT = 'Module1-Healthy and Safe School Environment Respondent Identification' ENDM2STAT = 'Module2-Healthy and Safe School Environment Respondent Identification' ENDM3STAT = 'Module3-Healthy and Safe School Environment Respondent Identification' FSDSTAT = 'Nutrition Service Respondent Identification' HEDM1PART = 'Module1-Health Education Participation Status' HEDM2PART = 'Module2-Health Education Participation Status' HEDM3PART = 'Module3-Health Education Participation Status' HEDM4PART = 'Module4-Health Education Participation Status' HEDM5PART = 'Module5-Health Education Participation Status' HEDPART = 'Overall-Health Education Participation Status' PEDM1PART = 'Module1-Physical Education Participation Status' PEDM2PART = 'Module2-Physical Education Participation Status' PEDM3PART = 'Module3-Physical Education Participation Status' PEDM4PART = 'Module4-Physical Education Participation Status' PEDM5PART = 'Module5-Physical Education Participation Status' PEDPART = 'Overall-Physical Education Participation Status' HSDPART = 'Health Service Participation Status' ENDM1PART = 'Module1-Healthy and Safe School Environment Participation Status' ENDM2PART = 'Module2-Healthy and Safe School Environment Participation Status' ENDM3PART = 'Module3-Healthy and Safe School Environment Participation Status' ENDPART = 'Overall-Healthy and Safe School Environment Participation Status' FSDPART = 'Nutrition Service Participation Status' SAMPSTRA = 'Sampling Stratum' OVERALLWT = 'District Weight for Cross Component Analysis' HEDWT = 'Analysis Weight for District under HED Component' PEDWT = 'Analysis Weight for District under PED Component' HSDWT = 'Analysis Weight for District under HSD Component' ENDWT = 'Analysis Weight for District under END Component' FSDWT = 'Analysis Weight for District under FSD Component' DIST_CONTAINS_ELEM = "District contains Elementary School" DIST_CONTAINS_MIDDLE = "District contains Middle School" DIST_CONTAINS_HIGH = "District contains High School" ; run; 国产精品久久久久久一级毛片