/******************************************************************* * CA_SEDD_2010_CORE.SAS: * THE SAS CODE SHOWN BELOW WILL LOAD THE ASCII * OUTPATIENT SEDD CORE FILE INTO SAS *******************************************************************/ ***********************************************; * Create SAS informats for missing values ; ***********************************************; PROC FORMAT; INVALUE N2PF '-9' = . '-8' = .A '-6' = .C '-5' = .N OTHER = (|2.|) ; INVALUE N3PF '-99' = . '-88' = .A '-66' = .C OTHER = (|3.|) ; INVALUE N4PF '-999' = . '-888' = .A '-666' = .C OTHER = (|4.|) ; INVALUE N4P1F '-9.9' = . '-8.8' = .A '-6.6' = .C OTHER = (|4.1|) ; INVALUE N5PF '-9999' = . '-8888' = .A '-6666' = .C OTHER = (|5.|) ; INVALUE N5P2F '-9.99' = . '-8.88' = .A '-6.66' = .C OTHER = (|5.2|) ; INVALUE N6PF '-99999' = . '-88888' = .A '-66666' = .C OTHER = (|6.|) ; INVALUE N6P2F '-99.99' = . '-88.88' = .A '-66.66' = .C OTHER = (|6.2|) ; INVALUE N7P2F '-999.99' = . '-888.88' = .A '-666.66' = .C OTHER = (|7.2|) ; INVALUE N7P4F '-9.9999' = . '-8.8888' = .A '-6.6666' = .C OTHER = (|7.4|) ; INVALUE N8PF '-9999999' = . '-8888888' = .A '-6666666' = .C OTHER = (|8.|) ; INVALUE N8P2F '-9999.99' = . '-8888.88' = .A '-6666.66' = .C OTHER = (|8.2|) ; INVALUE N9PF '-99999999' = . '-88888888' = .A '-66666666' = .C OTHER = (|9.|) ; INVALUE N9P2F '-99999.99' = . '-88888.88' = .A '-66666.66' = .C OTHER = (|9.2|) ; INVALUE N10PF '-999999999' = . '-888888888' = .A '-666666666' = .C OTHER = (|10.|) ; INVALUE N10P4F '-9999.9999' = . '-8888.8888' = .A '-6666.6666' = .C OTHER = (|10.4|) ; INVALUE N10P5F '-999.99999' = . '-888.88888' = .A '-666.66666' = .C OTHER = (|10.5|) ; INVALUE DATE10F '-999999999' = . '-888888888' = .A '-666666666' = .C OTHER = (|MMDDYY10.|) ; INVALUE N11PF '-9999999999' = . '-8888888888' = .A '-6666666666' = .C OTHER = (|11.|) ; INVALUE N12P2F '-99999999.99' = . '-88888888.88' = .A '-66666666.66' = .C OTHER = (|12.2|) ; INVALUE N12P5F '-99999.99999' = . '-88888.88888' = .A '-66666.66666' = .C OTHER = (|12.5|) ; INVALUE N13PF '-999999999999' = . '-888888888888' = .A '-666666666666' = .C OTHER = (|13.|) ; INVALUE N15P2F '-99999999999.99' = . '-88888888888.88' = .A '-66666666666.66' = .C OTHER = (|15.2|) ; RUN; *******************************; * Data Step *; *******************************; DATA CA_SEDDC_2010_CORE; INFILE 'CA_SEDD_2010_CORE.ASC' LRECL = 607; *** Variable attribute ***; ATTRIB AGE LENGTH=3 LABEL="Age in years at admission" AGEDAY LENGTH=3 LABEL="Age in days (when age < 1 year)" AGEMONTH LENGTH=3 LABEL="Age in months (when age < 11 years)" AMONTH LENGTH=3 LABEL="Admission month" AWEEKEND LENGTH=3 LABEL="Admission day is a weekend" CPT1 LENGTH=$5 LABEL="CPT/HCPCS procedure code 1" CPT2 LENGTH=$5 LABEL="CPT/HCPCS procedure code 2" CPT3 LENGTH=$5 LABEL="CPT/HCPCS procedure code 3" CPT4 LENGTH=$5 LABEL="CPT/HCPCS procedure code 4" CPT5 LENGTH=$5 LABEL="CPT/HCPCS procedure code 5" CPT6 LENGTH=$5 LABEL="CPT/HCPCS procedure code 6" CPT7 LENGTH=$5 LABEL="CPT/HCPCS procedure code 7" CPT8 LENGTH=$5 LABEL="CPT/HCPCS procedure code 8" CPT9 LENGTH=$5 LABEL="CPT/HCPCS procedure code 9" CPT10 LENGTH=$5 LABEL="CPT/HCPCS procedure code 10" CPT11 LENGTH=$5 LABEL="CPT/HCPCS procedure code 11" CPT12 LENGTH=$5 LABEL="CPT/HCPCS procedure code 12" CPT13 LENGTH=$5 LABEL="CPT/HCPCS procedure code 13" CPT14 LENGTH=$5 LABEL="CPT/HCPCS procedure code 14" CPT15 LENGTH=$5 LABEL="CPT/HCPCS procedure code 15" CPT16 LENGTH=$5 LABEL="CPT/HCPCS procedure code 16" CPT17 LENGTH=$5 LABEL="CPT/HCPCS procedure code 17" CPT18 LENGTH=$5 LABEL="CPT/HCPCS procedure code 18" CPT19 LENGTH=$5 LABEL="CPT/HCPCS procedure code 19" CPT20 LENGTH=$5 LABEL="CPT/HCPCS procedure code 20" CPT21 LENGTH=$5 LABEL="CPT/HCPCS procedure code 21" CPTCCS1 LENGTH=4 LABEL="CCS: CPT 1" CPTCCS2 LENGTH=4 LABEL="CCS: CPT 2" CPTCCS3 LENGTH=4 LABEL="CCS: CPT 3" CPTCCS4 LENGTH=4 LABEL="CCS: CPT 4" CPTCCS5 LENGTH=4 LABEL="CCS: CPT 5" CPTCCS6 LENGTH=4 LABEL="CCS: CPT 6" CPTCCS7 LENGTH=4 LABEL="CCS: CPT 7" CPTCCS8 LENGTH=4 LABEL="CCS: CPT 8" CPTCCS9 LENGTH=4 LABEL="CCS: CPT 9" CPTCCS10 LENGTH=4 LABEL="CCS: CPT 10" CPTCCS11 LENGTH=4 LABEL="CCS: CPT 11" CPTCCS12 LENGTH=4 LABEL="CCS: CPT 12" CPTCCS13 LENGTH=4 LABEL="CCS: CPT 13" CPTCCS14 LENGTH=4 LABEL="CCS: CPT 14" CPTCCS15 LENGTH=4 LABEL="CCS: CPT 15" CPTCCS16 LENGTH=4 LABEL="CCS: CPT 16" CPTCCS17 LENGTH=4 LABEL="CCS: CPT 17" CPTCCS18 LENGTH=4 LABEL="CCS: CPT 18" CPTCCS19 LENGTH=4 LABEL="CCS: CPT 19" CPTCCS20 LENGTH=4 LABEL="CCS: CPT 20" CPTCCS21 LENGTH=4 LABEL="CCS: CPT 21" DIED LENGTH=3 LABEL="Died during hospitalization" DISPUB04 LENGTH=3 LABEL="Disposition of patient (UB-04 standard coding)" DISPUNIFORM LENGTH=3 LABEL="Disposition of patient (uniform)" DISP_X LENGTH=$2 LABEL="Disposition of patient (as received from source)" DQTR LENGTH=3 LABEL="Discharge quarter" DSHOSPID LENGTH=$17 LABEL="Data source hospital identifier" DX1 LENGTH=$5 LABEL="Diagnosis 1" DX2 LENGTH=$5 LABEL="Diagnosis 2" DX3 LENGTH=$5 LABEL="Diagnosis 3" DX4 LENGTH=$5 LABEL="Diagnosis 4" DX5 LENGTH=$5 LABEL="Diagnosis 5" DX6 LENGTH=$5 LABEL="Diagnosis 6" DX7 LENGTH=$5 LABEL="Diagnosis 7" DX8 LENGTH=$5 LABEL="Diagnosis 8" DX9 LENGTH=$5 LABEL="Diagnosis 9" DX10 LENGTH=$5 LABEL="Diagnosis 10" DX11 LENGTH=$5 LABEL="Diagnosis 11" DX12 LENGTH=$5 LABEL="Diagnosis 12" DX13 LENGTH=$5 LABEL="Diagnosis 13" DX14 LENGTH=$5 LABEL="Diagnosis 14" DX15 LENGTH=$5 LABEL="Diagnosis 15" DX16 LENGTH=$5 LABEL="Diagnosis 16" DX17 LENGTH=$5 LABEL="Diagnosis 17" DX18 LENGTH=$5 LABEL="Diagnosis 18" DX19 LENGTH=$5 LABEL="Diagnosis 19" DX20 LENGTH=$5 LABEL="Diagnosis 20" DX21 LENGTH=$5 LABEL="Diagnosis 21" DX22 LENGTH=$5 LABEL="Diagnosis 22" DX23 LENGTH=$5 LABEL="Diagnosis 23" DX24 LENGTH=$5 LABEL="Diagnosis 24" DX25 LENGTH=$5 LABEL="Diagnosis 25" DXCCS1 LENGTH=4 LABEL="CCS: diagnosis 1" DXCCS2 LENGTH=4 LABEL="CCS: diagnosis 2" DXCCS3 LENGTH=4 LABEL="CCS: diagnosis 3" DXCCS4 LENGTH=4 LABEL="CCS: diagnosis 4" DXCCS5 LENGTH=4 LABEL="CCS: diagnosis 5" DXCCS6 LENGTH=4 LABEL="CCS: diagnosis 6" DXCCS7 LENGTH=4 LABEL="CCS: diagnosis 7" DXCCS8 LENGTH=4 LABEL="CCS: diagnosis 8" DXCCS9 LENGTH=4 LABEL="CCS: diagnosis 9" DXCCS10 LENGTH=4 LABEL="CCS: diagnosis 10" DXCCS11 LENGTH=4 LABEL="CCS: diagnosis 11" DXCCS12 LENGTH=4 LABEL="CCS: diagnosis 12" DXCCS13 LENGTH=4 LABEL="CCS: diagnosis 13" DXCCS14 LENGTH=4 LABEL="CCS: diagnosis 14" DXCCS15 LENGTH=4 LABEL="CCS: diagnosis 15" DXCCS16 LENGTH=4 LABEL="CCS: diagnosis 16" DXCCS17 LENGTH=4 LABEL="CCS: diagnosis 17" DXCCS18 LENGTH=4 LABEL="CCS: diagnosis 18" DXCCS19 LENGTH=4 LABEL="CCS: diagnosis 19" DXCCS20 LENGTH=4 LABEL="CCS: diagnosis 20" DXCCS21 LENGTH=4 LABEL="CCS: diagnosis 21" DXCCS22 LENGTH=4 LABEL="CCS: diagnosis 22" DXCCS23 LENGTH=4 LABEL="CCS: diagnosis 23" DXCCS24 LENGTH=4 LABEL="CCS: diagnosis 24" DXCCS25 LENGTH=4 LABEL="CCS: diagnosis 25" DaysToEvent LENGTH=8 LABEL="Days from 'start date' to admission" ECODE1 LENGTH=$5 LABEL="E code 1" ECODE2 LENGTH=$5 LABEL="E code 2" ECODE3 LENGTH=$5 LABEL="E code 3" ECODE4 LENGTH=$5 LABEL="E code 4" ECODE5 LENGTH=$5 LABEL="E code 5" E_CCS1 LENGTH=3 LABEL="CCS: E Code 1" E_CCS2 LENGTH=3 LABEL="CCS: E Code 2" E_CCS3 LENGTH=3 LABEL="CCS: E Code 3" E_CCS4 LENGTH=3 LABEL="CCS: E Code 4" E_CCS5 LENGTH=3 LABEL="CCS: E Code 5" FEMALE LENGTH=3 LABEL="Indicator of sex" HCUP_AS LENGTH=3 LABEL="HCUP Ambulatory Surgery service indicator" HCUP_ED LENGTH=3 LABEL="HCUP Emergency Department service indicator" HCUP_OS LENGTH=3 LABEL="HCUP Observation Stay service indicator" HISPANIC_X LENGTH=$2 LABEL="Hispanic ethnicity (as received from source)" HOSPBRTH LENGTH=3 LABEL="Indicator of birth in this hospital" HOSPST LENGTH=$2 LABEL="Hospital state postal code" KEY LENGTH=8 FORMAT=Z18. LABEL="HCUP record identifier" LOS LENGTH=4 LABEL="Length of stay (cleaned)" LOS_X LENGTH=4 LABEL="Length of stay (as received from source)" MEDINCSTQ LENGTH=3 LABEL="Median household income state quartile for patient ZIP Code" NCHRONIC LENGTH=3 LABEL="Number of chronic conditions" NCPT LENGTH=3 LABEL="Number of CPT/HCPCS procedures on this record" NDX LENGTH=3 LABEL="Number of diagnoses on this record" NECODE LENGTH=3 LABEL="Number of E codes on this record" NEOMAT LENGTH=3 LABEL="Neonatal and/or maternal DX and/or PR" PAY1 LENGTH=3 LABEL="Primary expected payer (uniform)" PAY1_X LENGTH=$2 LABEL="Primary expected payer (as received from source)" PL_CBSA LENGTH=3 LABEL="Patient location: Core Based Statistical Area (CBSA)" PL_MSA1993 LENGTH=3 LABEL="Patient location: Metropolitan Statistical Area (MSA), 1993" PL_NCHS2006 LENGTH=3 LABEL="Patient Location: NCHS Urban-Rural Code (V2006)" PL_RUCA4_2005 LENGTH=3 LABEL="Patient location: Rural-Urban Commuting Area (RUCA) Codes, four levels" PL_RUCC2003 LENGTH=3 LABEL="Patient location: Rural-Urban Continuum Codes(RUCC), 2003" PL_UIC2003 LENGTH=3 LABEL="Patient location: Urban Influence Codes, 2003" PL_UR_CAT4 LENGTH=3 LABEL="Patient Location: Urban-Rural 4 Categories" PNUM_R LENGTH=5 LABEL="Person number (re-identified)" PROCTYPE LENGTH=3 LABEL="Procedure type indicator" PSTATE LENGTH=$2 LABEL="Patient State postal code" RACE LENGTH=3 LABEL="Race (uniform)" RACE_X LENGTH=$2 LABEL="Race (as received from source)" STATE_AS LENGTH=3 LABEL="State Ambulatory Surgery service indicator" STATE_ED LENGTH=3 LABEL="State Emergency Department service indicator" STATE_OS LENGTH=3 LABEL="State Observation Stay service indicator" VisitLink LENGTH=8 LABEL="Visit linkage variable" YEAR LENGTH=3 LABEL="Calendar year" AYEAR LENGTH=3 LABEL="Admission year" DMONTH LENGTH=3 LABEL="Discharge month" BMONTH LENGTH=3 LABEL="Birth month" ; *** Input the variables from the ASCII file ***; INPUT @1 AGE N3PF. @4 AGEDAY N3PF. @7 AGEMONTH N3PF. @10 AMONTH N2PF. @12 AWEEKEND N2PF. @14 CPT1 $CHAR5. @19 CPT2 $CHAR5. @24 CPT3 $CHAR5. @29 CPT4 $CHAR5. @34 CPT5 $CHAR5. @39 CPT6 $CHAR5. @44 CPT7 $CHAR5. @49 CPT8 $CHAR5. @54 CPT9 $CHAR5. @59 CPT10 $CHAR5. @64 CPT11 $CHAR5. @69 CPT12 $CHAR5. @74 CPT13 $CHAR5. @79 CPT14 $CHAR5. @84 CPT15 $CHAR5. @89 CPT16 $CHAR5. @94 CPT17 $CHAR5. @99 CPT18 $CHAR5. @104 CPT19 $CHAR5. @109 CPT20 $CHAR5. @114 CPT21 $CHAR5. @119 CPTCCS1 N3PF. @122 CPTCCS2 N3PF. @125 CPTCCS3 N3PF. @128 CPTCCS4 N3PF. @131 CPTCCS5 N3PF. @134 CPTCCS6 N3PF. @137 CPTCCS7 N3PF. @140 CPTCCS8 N3PF. @143 CPTCCS9 N3PF. @146 CPTCCS10 N3PF. @149 CPTCCS11 N3PF. @152 CPTCCS12 N3PF. @155 CPTCCS13 N3PF. @158 CPTCCS14 N3PF. @161 CPTCCS15 N3PF. @164 CPTCCS16 N3PF. @167 CPTCCS17 N3PF. @170 CPTCCS18 N3PF. @173 CPTCCS19 N3PF. @176 CPTCCS20 N3PF. @179 CPTCCS21 N3PF. @182 DIED N2PF. @184 DISPUB04 N2PF. @186 DISPUNIFORM N2PF. @188 DISP_X $CHAR2. @190 DQTR N2PF. @192 DSHOSPID $CHAR17. @209 DX1 $CHAR5. @214 DX2 $CHAR5. @219 DX3 $CHAR5. @224 DX4 $CHAR5. @229 DX5 $CHAR5. @234 DX6 $CHAR5. @239 DX7 $CHAR5. @244 DX8 $CHAR5. @249 DX9 $CHAR5. @254 DX10 $CHAR5. @259 DX11 $CHAR5. @264 DX12 $CHAR5. @269 DX13 $CHAR5. @274 DX14 $CHAR5. @279 DX15 $CHAR5. @284 DX16 $CHAR5. @289 DX17 $CHAR5. @294 DX18 $CHAR5. @299 DX19 $CHAR5. @304 DX20 $CHAR5. @309 DX21 $CHAR5. @314 DX22 $CHAR5. @319 DX23 $CHAR5. @324 DX24 $CHAR5. @329 DX25 $CHAR5. @334 DXCCS1 N4PF. @338 DXCCS2 N4PF. @342 DXCCS3 N4PF. @346 DXCCS4 N4PF. @350 DXCCS5 N4PF. @354 DXCCS6 N4PF. @358 DXCCS7 N4PF. @362 DXCCS8 N4PF. @366 DXCCS9 N4PF. @370 DXCCS10 N4PF. @374 DXCCS11 N4PF. @378 DXCCS12 N4PF. @382 DXCCS13 N4PF. @386 DXCCS14 N4PF. @390 DXCCS15 N4PF. @394 DXCCS16 N4PF. @398 DXCCS17 N4PF. @402 DXCCS18 N4PF. @406 DXCCS19 N4PF. @410 DXCCS20 N4PF. @414 DXCCS21 N4PF. @418 DXCCS22 N4PF. @422 DXCCS23 N4PF. @426 DXCCS24 N4PF. @430 DXCCS25 N4PF. @434 DaysToEvent N6PF. @440 ECODE1 $CHAR5. @445 ECODE2 $CHAR5. @450 ECODE3 $CHAR5. @455 ECODE4 $CHAR5. @460 ECODE5 $CHAR5. @465 E_CCS1 N4PF. @469 E_CCS2 N4PF. @473 E_CCS3 N4PF. @477 E_CCS4 N4PF. @481 E_CCS5 N4PF. @485 FEMALE N2PF. @487 HCUP_AS N2PF. @489 HCUP_ED N2PF. @491 HCUP_OS N2PF. @493 HISPANIC_X $CHAR2. @495 HOSPBRTH N3PF. @498 HOSPST $CHAR2. @500 KEY 18. @518 LOS N5PF. @523 LOS_X N6PF. @529 MEDINCSTQ N2PF. @531 NCHRONIC N3PF. @534 NCPT N3PF. @537 NDX N2PF. @539 NECODE N2PF. @541 NEOMAT N2PF. @543 PAY1 N2PF. @545 PAY1_X $CHAR2. @547 PL_CBSA N3PF. @550 PL_MSA1993 N3PF. @553 PL_NCHS2006 N2PF. @555 PL_RUCA4_2005 N2PF. @557 PL_RUCC2003 N2PF. @559 PL_UIC2003 N2PF. @561 PL_UR_CAT4 N2PF. @563 PNUM_R N9PF. @572 PROCTYPE N3PF. @575 PSTATE $CHAR2. @577 RACE N2PF. @579 RACE_X $CHAR2. @581 STATE_AS N2PF. @583 STATE_ED N2PF. @585 STATE_OS N2PF. @587 VisitLink N9PF. @596 YEAR N4PF. @600 AYEAR N4PF. @604 DMONTH N2PF. @606 BMONTH N2PF. ; RUN;