**** * FILE NAME: CNTY11_SASOUT.SAS * * DESCRIPTION: THIS PROGRAM CONVERTS A STATES ASCII DATAFILE OF COMPLETES LOCATED AT * * FILEREF, INTO A SAS DATABASE STORED AT LIBREF * * REFERENCES: * * INPUT DATAIN FILEREF OF ASCII DATAFILE OF COMPLETES * * FORMATS FORMAT11.SAS7BCAT SAS FORMATS DATABASE * * OUTPUT DATAOUT.SASDATA SAS DATABASE VERSION OF ASCII DATA AS SPECIFIED IN * * FILEREF * * UPDATED - 12/18/2012 * ****; ** * Clear Output and Log Windows * **; DM OUTPUT 'clear' continue; DM LOG 'clear' continue; **** * DEFINE SAS ENVIRONMENT OPTIONS * ****; OPTIONS PAGENO=1 NOFMTERR; **** * CLEAR EXISTING TITLES AND FOOTNOTES * ****; TITLE ; FOOTNOTE ; RUN ; * * INSTRUCTIONS: * * SPECIFY PATH OF WHERE ASCII DATAFILE IS STORED * * SPECIFY PATH OF WHERE SAS DATASET IS TO BE STORED * * SPECIFY PATH OF WHERE SAS FORMAT LIBRARY IS STORED * * SPECIFY PATH OF WHERE THE FORMAT ASSIGNMET STATEMENT IS STORED * *; *FILENAME DATAIN '' LRECL = 416 ; ** * EXAMPLE: * * FILENAME DATAIN 'C:\BRFSS\2011\CNTY11.ASC' LRECL = 416 * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD FILENAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE FILENAME STATEMENT * **; *LIBNAME DATAOUT '' ; ** * EXAMPLE: * * LIBNAME DATAOUT 'C:\' * * A SAS DATABASE WILL BE STORED AT C:\SASDATA.SAS7BDAT * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD LIBNAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE LIBNAME STATEMENT * **; *LIBNAME LIBRARY '' ; ** * EXAMPLE: * * LIBNAME LIBRARY 'C:\' * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD LIBNAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE LIBNAME STATEMENT * **; *FILENAME FORMATIN '' ; ** * EXAMPLE: * * FILENAME FORMATIN 'C:\FORMATSTATEMENT.SAS' * * NOTE: MAKE SURE THE ASTERISK IS REMOVED BEFORE THE WORD FILENAME AND * * MAKE SURE THAT THE GREATER THAN AND LESS THAN SIGNS < > ARE REMOVED * * FROM THE FILENAME STATEMENT * **; DATA DATAOUT.SASDATA ; INFILE DATAIN MISSOVER ; INPUT _STATE 1-2 /* Record Identification */ PRECALL 3 FMONTH 4-5 INTVID $6-10 SEQNO 11-20 _PSU 21-30 CTELENUM 31 CELLFON 32 PVTRESID 33 GENHLTH 34 /* Section 1: Health Status */ PHYSHLTH 35-36 /* Section 2: Healthy Days - Health-Related Quality of Life */ MENTHLTH 37-38 POORHLTH 39-40 HLTHPLN1 41 /* Section 3: Health Care Access */ PERSDOC2 42 MEDCOST 43 CHECKUP1 44 BPHIGH4 45 /* Section 4: Hypertension Awareness */ BPMEDS 46 BLOODCHO 47 /* Section 5: Cholesterol Awareness */ CHOLCHK 48 TOLDHI2 49 CVDINFR4 50 /* Section 6: Chronic Health Conditions */ CVDCRHD4 51 CVDSTRK3 52 ASTHMA3 53 ASTHNOW 54 CHCSCNCR 55 CHCOCNCR 56 CHCCOPD 57 HAVARTH3 58 ADDEPEV2 59 CHCKIDNY 60 CHCVISON 61 DIABETE3 62 SMOKE100 63 /* Section 7: Tobacco Use */ SMOKDAY2 64 STOPSMK2 65 LASTSMK2 66-67 USENOW3 68 AGE 69-70 /* Section 8: Demographics */ HISPANC2 71 MRACE $72-77 ORACE2 78 VETERAN3 79 MARITAL 80 CHILDREN 81-82 EDUCA 83 EMPLOY 84 INCOME2 85-86 WEIGHT2 87-90 HEIGHT3 91-94 NUMHHOL2 98 NUMPHON2 99 CPDEMO1 100 CPDEMO2 101 CPDEMO3 102 CPDEMO4 103-105 RENTHOM1 106 SEX 107 PREGNANT 108 FRUITJU1 109-111 /* Section 9: Fruits & Vegetables */ FRUIT1 112-114 FVBEANS 115-117 FVGREEN 118-120 FVORANG 121-123 VEGETAB1 124-126 EXERANY2 127 /* Section 10: Exercise (Physical Activity) */ EXRACT01 128-129 EXEROFT1 130-132 EXERHMM1 133-135 EXRACT02 136-137 EXEROFT2 138-140 EXERHMM2 141-143 STRENGTH 144-146 QLACTLM2 147 /* Section 11: Disability */ USEEQUIP 148 LMTJOIN3 149 /* Section 12: Arthritis Burden */ ARTHDIS2 150 ARTHSOCL 151 JOINPAIN 152-153 SEATBELT 154 /* Section 13: Seatbelt Use */ FLUSHOT5 155 /* Section 14: Immunization */ FLSHTMY2 156-161 IMFVPLAC 162-163 PNEUVAC3 164 ALCDAY5 165-167 /* Section 15: Alcohol Consumption */ AVEDRNK2 168-169 DRNK3GE5 170-171 MAXDRNKS 172-173 HIVTST6 174 /* Section 16: HIV/AIDS */ HIVTSTD3 175-180 HIVRISK3 181 _STSTR 182-186 _IMPAGE 187-188 _IMPRACE 189-190 _IMPNPH 191 _RFHLTH 192 /* Section 1: Calculated Variables */ _HCVU651 193 /* Section 3: Calculated Variables */ _RFHYPE5 194 /* Section 4: Calculated Variables */ _CHOLCHK 195 /* Section 5: Calculated Variables */ _RFCHOL 196 _LTASTH1 197 /* Section 6: Calculated Variables */ _CASTHM1 198 _ASTHMS1 199 _DRDXAR1 200 _SMOKER3 201 /* Section 7: Calculated Variables */ _RFSMOK3 202 MRACEORG $203-208 /* Section 8: Calculated Race Variables */ MRACEASC 209-214 _PRACE 215-216 _MRACE 217-218 RACE2 219 _RACEG2 220 _RACEGR2 221 _RACE_G 222 _CNRACE 223 _CNRACEC 224 _AGEG5YR 225-226 _AGE65YR 227 _AGE_G 228 HTIN4 229-231 HTM4 232-234 WTKG3 235-239 _BMI5 240-243 _BMI5CAT 244 _RFBMI5 245 _CHLDCNT 246 _EDUCAG 247 _INCOMG 248 FTJUDA1_ 249-252 /* Section 9: Calculated Variables */ FRUTDA1_ 253-256 BEANDAY_ 257-260 GRENDAY_ 261-264 ORNGDAY_ 265-268 VEGEDA1_ 269-272 _MISFRTN 273 _MISVEGN 274 _FRTRESP 275 _VEGRESP 276 _FRUTSUM 277-282 _VEGESUM 283-288 _FRT16 289 _VEG23 290 _FRUITEX 291 _VEGETEX 292 _TOTINDA 293 /* Section 10: Calculated Variables */ METVAL1_ 294-296 METVAL2_ 297-299 MAXVO2_ 300-304 FC60_ 305-309 ACTINT1_ 310 ACTINT2_ 311 PADUR1_ 312-314 PADUR2_ 315-317 PAFREQ1_ 318-322 PAFREQ2_ 323-327 _MINACT1 328-332 _MINACT2 333-337 STRFREQ_ 338-342 PAMISS_ 343 PAMIN1_ 344-348 PAMIN2_ 349-353 PAMIN_ 354-358 PAVIGM1_ 359-363 PAVIGM2_ 364-368 PAVIGMN_ 369-373 _PACAT 374 _PAINDEX 375 _PA150R1 376 _PA300R1 377 _PA3002L 378 _PASTRNG 379 _PAREC 380 _PASTAER 381 _RFSEAT2 382 /* Section 13: Calculated Variables */ _RFSEAT3 383 _FLSHOT5 384 /* Section 14: Calculated Variables */ _PNEUMO2 385 DRNKANY5 386 /* Section 15: Calculated Variables */ DROCDY3_ 387-389 _RFBING5 390 _DRNKDY4 391-394 _DRNKMO4 395-398 _RFDRHV4 399 _RFDRMN4 400 _RFDRWM4 401 _AIDTST3 402 /* Section 16: Calculated Variables */ _CNTYWT 403-412 /* County Weighting and Stratification Variables */ _CNTY 413-415 /* County Weighting and Stratification Variables */ ENDOFREC 416 /* End of Record Marker */ ; * TO INCLUDE THE FORMAT ASSIGNEMT STATEMENT REMOVE THE ASTERISK * * FROM THE BEGINNING OF THE FOLLOWING LINE * ; * %INCLUDE FORMATIN ; **** * THIS SECTION CREATES LABELS FOR THE VARIABLES * ****; Label _CNTYNAM = 'COUNTY NAME' ; RUN;