/***************************************************************************** * Creation Date: 07/31/2017 * MI_SASD_2015q1q3_CORE.Do * This program will load the 2015 MI ASCII CORE File into Stata. * Because Stata loads the entire file into memory, it may not be possible * to load every data element for large files. If necessary, edit this * program to change the memory size or to load only selected data elements. *****************************************************************************/ ***************************************************************; * ----------------------------------------------------------- *; * | NOTICE: Use of HCUP data constitutes acceptance of the | *; * | terms and conditions of the HCUP Data Use Agreement. | *; * ----------------------------------------------------------- *; ***************************************************************; *** Set available memory size *** set mem 500m *** Read data elements from the ASCII file *** *** Skip the first two lines from the ASCII file i.e. infix 3 firstlineoffile *** infix 3 firstlineoffile /// int AGE 1- 3 /// int AGEDAY 4- 6 /// int AGEMONTH 7- 9 /// byte AMONTH 10- 11 /// byte ATYPE 12- 13 /// byte AWEEKEND 14- 15 /// str CPT1 16- 20 /// str CPT2 21- 25 /// str CPT3 26- 30 /// str CPT4 31- 35 /// str CPT5 36- 40 /// str CPT6 41- 45 /// str CPT7 46- 50 /// str CPT8 51- 55 /// str CPT9 56- 60 /// str CPT10 61- 65 /// str CPT11 66- 70 /// str CPT12 71- 75 /// str CPT13 76- 80 /// str CPT14 81- 85 /// str CPT15 86- 90 /// str CPT16 91- 95 /// str CPT17 96- 100 /// str CPT18 101- 105 /// str CPT19 106- 110 /// str CPT20 111- 115 /// str CPT21 116- 120 /// str CPT22 121- 125 /// str CPT23 126- 130 /// str CPT24 131- 135 /// str CPT25 136- 140 /// str CPT26 141- 145 /// str CPT27 146- 150 /// str CPT28 151- 155 /// str CPT29 156- 160 /// str CPT30 161- 165 /// int CPTCCS1 166- 168 /// int CPTCCS2 169- 171 /// int CPTCCS3 172- 174 /// int CPTCCS4 175- 177 /// int CPTCCS5 178- 180 /// int CPTCCS6 181- 183 /// int CPTCCS7 184- 186 /// int CPTCCS8 187- 189 /// int CPTCCS9 190- 192 /// int CPTCCS10 193- 195 /// int CPTCCS11 196- 198 /// int CPTCCS12 199- 201 /// int CPTCCS13 202- 204 /// int CPTCCS14 205- 207 /// int CPTCCS15 208- 210 /// int CPTCCS16 211- 213 /// int CPTCCS17 214- 216 /// int CPTCCS18 217- 219 /// int CPTCCS19 220- 222 /// int CPTCCS20 223- 225 /// int CPTCCS21 226- 228 /// int CPTCCS22 229- 231 /// int CPTCCS23 232- 234 /// int CPTCCS24 235- 237 /// int CPTCCS25 238- 240 /// int CPTCCS26 241- 243 /// int CPTCCS27 244- 246 /// int CPTCCS28 247- 249 /// int CPTCCS29 250- 252 /// int CPTCCS30 253- 255 /// int CPTDAY1 256- 258 /// int CPTDAY2 259- 261 /// int CPTDAY3 262- 264 /// int CPTDAY4 265- 267 /// int CPTDAY5 268- 270 /// int CPTDAY6 271- 273 /// int CPTDAY7 274- 276 /// int CPTDAY8 277- 279 /// int CPTDAY9 280- 282 /// int CPTDAY10 283- 285 /// int CPTDAY11 286- 288 /// int CPTDAY12 289- 291 /// int CPTDAY13 292- 294 /// int CPTDAY14 295- 297 /// int CPTDAY15 298- 300 /// int CPTDAY16 301- 303 /// int CPTDAY17 304- 306 /// int CPTDAY18 307- 309 /// int CPTDAY19 310- 312 /// int CPTDAY20 313- 315 /// int CPTDAY21 316- 318 /// int CPTDAY22 319- 321 /// int CPTDAY23 322- 324 /// int CPTDAY24 325- 327 /// int CPTDAY25 328- 330 /// int CPTDAY26 331- 333 /// int CPTDAY27 334- 336 /// int CPTDAY28 337- 339 /// int CPTDAY29 340- 342 /// int CPTDAY30 343- 345 /// byte DIED 346- 347 /// str DISP_X 348- 349 /// byte DISPUB04 350- 351 /// byte DISPUNIFORM 352- 353 /// byte DMONTH 354- 355 /// byte DQTR 356- 357 /// str DX_Visit_Reason1 358- 364 /// str DX1 365- 371 /// str DX2 372- 378 /// str DX3 379- 385 /// str DX4 386- 392 /// str DX5 393- 399 /// str DX6 400- 406 /// str DX7 407- 413 /// str DX8 414- 420 /// str DX9 421- 427 /// str DX10 428- 434 /// str DX11 435- 441 /// str DX12 442- 448 /// str DX13 449- 455 /// str DX14 456- 462 /// str DX15 463- 469 /// str DX16 470- 476 /// str DX17 477- 483 /// str DX18 484- 490 /// str DX19 491- 497 /// str DX20 498- 504 /// str DX21 505- 511 /// str DX22 512- 518 /// str DX23 519- 525 /// str DX24 526- 532 /// str DX25 533- 539 /// str DX26 540- 546 /// str DX27 547- 553 /// str DX28 554- 560 /// str DX29 561- 567 /// str DX30 568- 574 /// int DXCCS1 575- 578 /// int DXCCS2 579- 582 /// int DXCCS3 583- 586 /// int DXCCS4 587- 590 /// int DXCCS5 591- 594 /// int DXCCS6 595- 598 /// int DXCCS7 599- 602 /// int DXCCS8 603- 606 /// int DXCCS9 607- 610 /// int DXCCS10 611- 614 /// int DXCCS11 615- 618 /// int DXCCS12 619- 622 /// int DXCCS13 623- 626 /// int DXCCS14 627- 630 /// int DXCCS15 631- 634 /// int DXCCS16 635- 638 /// int DXCCS17 639- 642 /// int DXCCS18 643- 646 /// int DXCCS19 647- 650 /// int DXCCS20 651- 654 /// int DXCCS21 655- 658 /// int DXCCS22 659- 662 /// int DXCCS23 663- 666 /// int DXCCS24 667- 670 /// int DXCCS25 671- 674 /// int DXCCS26 675- 678 /// int DXCCS27 679- 682 /// int DXCCS28 683- 686 /// int DXCCS29 687- 690 /// int DXCCS30 691- 694 /// int DXVER 695- 697 /// int E_CCS1 698- 701 /// int E_CCS2 702- 705 /// int E_CCS3 706- 709 /// int E_CCS4 710- 713 /// int E_CCS5 714- 717 /// int E_CCS6 718- 721 /// int E_CCS7 722- 725 /// int E_CCS8 726- 729 /// int E_CCS9 730- 733 /// int E_CCS10 734- 737 /// str ECODE1 738- 744 /// str ECODE2 745- 751 /// str ECODE3 752- 758 /// str ECODE4 759- 765 /// str ECODE5 766- 772 /// str ECODE6 773- 779 /// str ECODE7 780- 786 /// str ECODE8 787- 793 /// str ECODE9 794- 800 /// str ECODE10 801- 807 /// byte FEMALE 808- 809 /// byte HCUP_ED 810- 811 /// byte HCUP_OS 812- 813 /// long HCUP_SURGERY_BROAD_CPT 814- 818 /// long HCUP_SURGERY_BROAD_I9 819- 823 /// long HCUP_SURGERY_NARROW_CPT 824- 828 /// long HCUP_SURGERY_NARROW_I9 829- 833 /// byte HISPANIC 834- 835 /// str HISPANIC_X 836 /// int HOSPBRTH 837- 839 /// str HOSPST 840- 841 /// double KEY 842- 856 /// long LOS 857- 861 /// long LOS_X 862- 867 /// long MDNUM1_R 868- 876 /// byte MEDINCSTQ 877- 878 /// long MRN_R 879- 887 /// int NCHRONIC 888- 890 /// int NCPT 891- 894 /// int NDX 895- 897 /// byte NECODE 898- 899 /// byte NEOMAT 900- 901 /// int NPR 902- 904 /// byte ORPROC 905- 906 /// byte PAY1 907- 908 /// str PAY1_X 909- 910 /// byte PAY2 911- 912 /// str PAY2_X 913- 914 /// int PL_CBSA 915- 917 /// byte PL_NCHS 918- 919 /// byte PL_RUCC 920- 921 /// byte PL_UIC 922- 923 /// byte PL_UR_CAT4 924- 925 /// str PointOfOrigin_X 926 /// str PointOfOriginUB04 927 /// str PR1 928- 934 /// str PR2 935- 941 /// str PR3 942- 948 /// str PR4 949- 955 /// str PR5 956- 962 /// str PR6 963- 969 /// str PR7 970- 976 /// str PR8 977- 983 /// str PR9 984- 990 /// str PR10 991- 997 /// str PR11 998-1004 /// str PR12 1005-1011 /// str PR13 1012-1018 /// str PR14 1019-1025 /// str PR15 1026-1032 /// str PR16 1033-1039 /// str PR17 1040-1046 /// str PR18 1047-1053 /// str PR19 1054-1060 /// str PR20 1061-1067 /// str PR21 1068-1074 /// str PR22 1075-1081 /// str PR23 1082-1088 /// str PR24 1089-1095 /// str PR25 1096-1102 /// str PR26 1103-1109 /// str PR27 1110-1116 /// str PR28 1117-1123 /// str PR29 1124-1130 /// str PR30 1131-1137 /// int PRCCS1 1138-1140 /// int PRCCS2 1141-1143 /// int PRCCS3 1144-1146 /// int PRCCS4 1147-1149 /// int PRCCS5 1150-1152 /// int PRCCS6 1153-1155 /// int PRCCS7 1156-1158 /// int PRCCS8 1159-1161 /// int PRCCS9 1162-1164 /// int PRCCS10 1165-1167 /// int PRCCS11 1168-1170 /// int PRCCS12 1171-1173 /// int PRCCS13 1174-1176 /// int PRCCS14 1177-1179 /// int PRCCS15 1180-1182 /// int PRCCS16 1183-1185 /// int PRCCS17 1186-1188 /// int PRCCS18 1189-1191 /// int PRCCS19 1192-1194 /// int PRCCS20 1195-1197 /// int PRCCS21 1198-1200 /// int PRCCS22 1201-1203 /// int PRCCS23 1204-1206 /// int PRCCS24 1207-1209 /// int PRCCS25 1210-1212 /// int PRCCS26 1213-1215 /// int PRCCS27 1216-1218 /// int PRCCS28 1219-1221 /// int PRCCS29 1222-1224 /// int PRCCS30 1225-1227 /// long PRDAY1 1228-1232 /// int PROCTYPE 1233-1235 /// int PRVER 1236-1238 /// str PSTATE 1239-1240 /// long PSTCO2 1241-1245 /// byte RACE 1246-1247 /// str RACE_X 1248 /// byte STATE_AS 1249-1250 /// byte STATE_ED 1251-1252 /// byte STATE_OS 1253-1254 /// double TOTCHG 1255-1264 /// double TOTCHG_X 1265-1279 /// int YEAR 1280-1283 /// str ZIP 1284-1288 /// str ZIP3 1289-1291 /// int ZIPINC_QRTL 1292-1294 /// long HOSPID 1295-1299 /// int AYEAR 1300-1303 /// byte BMONTH 1304-1305 /// int BYEAR 1306-1309 /// byte PRMONTH1 1310-1311 /// int PRYEAR1 1312-1315 /// using "MI_SASD_2015q1q3_CORE.ASC" *** Assign labels to the data elements *** label var AGE "Age in years at admission" label var AGEDAY "Age in days (when age < 1 year)" label var AGEMONTH "Age in months (when age < 11 years)" label var AMONTH "Admission month" label var ATYPE "Admission type" label var AWEEKEND "Admission day is a weekend" label var CPT1 "CPT/HCPCS procedure code 1" label var CPT2 "CPT/HCPCS procedure code 2" label var CPT3 "CPT/HCPCS procedure code 3" label var CPT4 "CPT/HCPCS procedure code 4" label var CPT5 "CPT/HCPCS procedure code 5" label var CPT6 "CPT/HCPCS procedure code 6" label var CPT7 "CPT/HCPCS procedure code 7" label var CPT8 "CPT/HCPCS procedure code 8" label var CPT9 "CPT/HCPCS procedure code 9" label var CPT10 "CPT/HCPCS procedure code 10" label var CPT11 "CPT/HCPCS procedure code 11" label var CPT12 "CPT/HCPCS procedure code 12" label var CPT13 "CPT/HCPCS procedure code 13" label var CPT14 "CPT/HCPCS procedure code 14" label var CPT15 "CPT/HCPCS procedure code 15" label var CPT16 "CPT/HCPCS procedure code 16" label var CPT17 "CPT/HCPCS procedure code 17" label var CPT18 "CPT/HCPCS procedure code 18" label var CPT19 "CPT/HCPCS procedure code 19" label var CPT20 "CPT/HCPCS procedure code 20" label var CPT21 "CPT/HCPCS procedure code 21" label var CPT22 "CPT/HCPCS procedure code 22" label var CPT23 "CPT/HCPCS procedure code 23" label var CPT24 "CPT/HCPCS procedure code 24" label var CPT25 "CPT/HCPCS procedure code 25" label var CPT26 "CPT/HCPCS procedure code 26" label var CPT27 "CPT/HCPCS procedure code 27" label var CPT28 "CPT/HCPCS procedure code 28" label var CPT29 "CPT/HCPCS procedure code 29" label var CPT30 "CPT/HCPCS procedure code 30" label var CPTCCS1 "CCS: CPT 1" label var CPTCCS2 "CCS: CPT 2" label var CPTCCS3 "CCS: CPT 3" label var CPTCCS4 "CCS: CPT 4" label var CPTCCS5 "CCS: CPT 5" label var CPTCCS6 "CCS: CPT 6" label var CPTCCS7 "CCS: CPT 7" label var CPTCCS8 "CCS: CPT 8" label var CPTCCS9 "CCS: CPT 9" label var CPTCCS10 "CCS: CPT 10" label var CPTCCS11 "CCS: CPT 11" label var CPTCCS12 "CCS: CPT 12" label var CPTCCS13 "CCS: CPT 13" label var CPTCCS14 "CCS: CPT 14" label var CPTCCS15 "CCS: CPT 15" label var CPTCCS16 "CCS: CPT 16" label var CPTCCS17 "CCS: CPT 17" label var CPTCCS18 "CCS: CPT 18" label var CPTCCS19 "CCS: CPT 19" label var CPTCCS20 "CCS: CPT 20" label var CPTCCS21 "CCS: CPT 21" label var CPTCCS22 "CCS: CPT 22" label var CPTCCS23 "CCS: CPT 23" label var CPTCCS24 "CCS: CPT 24" label var CPTCCS25 "CCS: CPT 25" label var CPTCCS26 "CCS: CPT 26" label var CPTCCS27 "CCS: CPT 27" label var CPTCCS28 "CCS: CPT 28" label var CPTCCS29 "CCS: CPT 29" label var CPTCCS30 "CCS: CPT 30" label var CPTDAY1 "Number of days from admission to CPT1" label var CPTDAY2 "Number of days from admission to CPT2" label var CPTDAY3 "Number of days from admission to CPT3" label var CPTDAY4 "Number of days from admission to CPT4" label var CPTDAY5 "Number of days from admission to CPT5" label var CPTDAY6 "Number of days from admission to CPT6" label var CPTDAY7 "Number of days from admission to CPT7" label var CPTDAY8 "Number of days from admission to CPT8" label var CPTDAY9 "Number of days from admission to CPT9" label var CPTDAY10 "Number of days from admission to CPT10" label var CPTDAY11 "Number of days from admission to CPT11" label var CPTDAY12 "Number of days from admission to CPT12" label var CPTDAY13 "Number of days from admission to CPT13" label var CPTDAY14 "Number of days from admission to CPT14" label var CPTDAY15 "Number of days from admission to CPT15" label var CPTDAY16 "Number of days from admission to CPT16" label var CPTDAY17 "Number of days from admission to CPT17" label var CPTDAY18 "Number of days from admission to CPT18" label var CPTDAY19 "Number of days from admission to CPT19" label var CPTDAY20 "Number of days from admission to CPT20" label var CPTDAY21 "Number of days from admission to CPT21" label var CPTDAY22 "Number of days from admission to CPT22" label var CPTDAY23 "Number of days from admission to CPT23" label var CPTDAY24 "Number of days from admission to CPT24" label var CPTDAY25 "Number of days from admission to CPT25" label var CPTDAY26 "Number of days from admission to CPT26" label var CPTDAY27 "Number of days from admission to CPT27" label var CPTDAY28 "Number of days from admission to CPT28" label var CPTDAY29 "Number of days from admission to CPT29" label var CPTDAY30 "Number of days from admission to CPT30" label var DIED "Died during hospitalization" label var DISP_X "Disposition of patient (as received from source)" label var DISPUB04 "Disposition of patient (UB-04 standard coding)" label var DISPUNIFORM "Disposition of patient (uniform)" label var DMONTH "Discharge month" label var DQTR "Discharge quarter" label var DX_Visit_Reason1 "Reason for visit diagnosis 1" label var DX1 "Diagnosis 1" label var DX2 "Diagnosis 2" label var DX3 "Diagnosis 3" label var DX4 "Diagnosis 4" label var DX5 "Diagnosis 5" label var DX6 "Diagnosis 6" label var DX7 "Diagnosis 7" label var DX8 "Diagnosis 8" label var DX9 "Diagnosis 9" label var DX10 "Diagnosis 10" label var DX11 "Diagnosis 11" label var DX12 "Diagnosis 12" label var DX13 "Diagnosis 13" label var DX14 "Diagnosis 14" label var DX15 "Diagnosis 15" label var DX16 "Diagnosis 16" label var DX17 "Diagnosis 17" label var DX18 "Diagnosis 18" label var DX19 "Diagnosis 19" label var DX20 "Diagnosis 20" label var DX21 "Diagnosis 21" label var DX22 "Diagnosis 22" label var DX23 "Diagnosis 23" label var DX24 "Diagnosis 24" label var DX25 "Diagnosis 25" label var DX26 "Diagnosis 26" label var DX27 "Diagnosis 27" label var DX28 "Diagnosis 28" label var DX29 "Diagnosis 29" label var DX30 "Diagnosis 30" label var DXCCS1 "CCS: diagnosis 1" label var DXCCS2 "CCS: diagnosis 2" label var DXCCS3 "CCS: diagnosis 3" label var DXCCS4 "CCS: diagnosis 4" label var DXCCS5 "CCS: diagnosis 5" label var DXCCS6 "CCS: diagnosis 6" label var DXCCS7 "CCS: diagnosis 7" label var DXCCS8 "CCS: diagnosis 8" label var DXCCS9 "CCS: diagnosis 9" label var DXCCS10 "CCS: diagnosis 10" label var DXCCS11 "CCS: diagnosis 11" label var DXCCS12 "CCS: diagnosis 12" label var DXCCS13 "CCS: diagnosis 13" label var DXCCS14 "CCS: diagnosis 14" label var DXCCS15 "CCS: diagnosis 15" label var DXCCS16 "CCS: diagnosis 16" label var DXCCS17 "CCS: diagnosis 17" label var DXCCS18 "CCS: diagnosis 18" label var DXCCS19 "CCS: diagnosis 19" label var DXCCS20 "CCS: diagnosis 20" label var DXCCS21 "CCS: diagnosis 21" label var DXCCS22 "CCS: diagnosis 22" label var DXCCS23 "CCS: diagnosis 23" label var DXCCS24 "CCS: diagnosis 24" label var DXCCS25 "CCS: diagnosis 25" label var DXCCS26 "CCS: diagnosis 26" label var DXCCS27 "CCS: diagnosis 27" label var DXCCS28 "CCS: diagnosis 28" label var DXCCS29 "CCS: diagnosis 29" label var DXCCS30 "CCS: diagnosis 30" label var DXVER "Diagnosis Version" label var E_CCS1 "CCS: E Code 1" label var E_CCS2 "CCS: E Code 2" label var E_CCS3 "CCS: E Code 3" label var E_CCS4 "CCS: E Code 4" label var E_CCS5 "CCS: E Code 5" label var E_CCS6 "CCS: E Code 6" label var E_CCS7 "CCS: E Code 7" label var E_CCS8 "CCS: E Code 8" label var E_CCS9 "CCS: E Code 9" label var E_CCS10 "CCS: E Code 10" label var ECODE1 "E code 1" label var ECODE2 "E code 2" label var ECODE3 "E code 3" label var ECODE4 "E code 4" label var ECODE5 "E code 5" label var ECODE6 "E code 6" label var ECODE7 "E code 7" label var ECODE8 "E code 8" label var ECODE9 "E code 9" label var ECODE10 "E code 10" label var FEMALE "Indicator of sex" label var HCUP_ED "HCUP Emergency Department service indicator" label var HCUP_OS "HCUP Observation Stay service indicator" label var HCUP_SURGERY_BROAD_CPT "Number of reported CPT procedures that qualify as a surgery using a broad definition" label var HCUP_SURGERY_BROAD_I9 "Number of reported ICD-9-CM procedures that qualify as a surgery using a broad definition" label var HCUP_SURGERY_NARROW_CPT "Number of reported CPT procedures that qualify as a surgery using a narrow definition" label var HCUP_SURGERY_NARROW_I9 "Number of reported ICD-9-CM procedures that qualify as a surgery using a narrow definition" label var HISPANIC "Hispanic ethnicity (uniform)" label var HISPANIC_X "Hispanic ethnicity (as received from source)" label var HOSPBRTH "Indicator of birth in this hospital" label var HOSPST "Hospital state postal code" label var KEY "HCUP record identifier" label var LOS "Length of stay (cleaned)" label var LOS_X "Length of stay (as received from source)" label var MDNUM1_R "Physician 1 number (re-identified)" label var MEDINCSTQ "Median household income state quartile for patient ZIP Code" label var MRN_R "Medical record number (re-identified)" label var NCHRONIC "Number of chronic conditions" label var NCPT "Number of CPT/HCPCS procedures for this visit" label var NDX "Number of diagnoses on this record" label var NECODE "Number of E codes on this record" label var NEOMAT "Neonatal and/or maternal DX and/or PR" label var NPR "Number of procedures on this record" label var ORPROC "Major operating room procedure indicator" label var PAY1 "Primary expected payer (uniform)" label var PAY1_X "Primary expected payer (as received from source)" label var PAY2 "Secondary expected payer (uniform)" label var PAY2_X "Secondary expected payer (as received from source)" label var PL_CBSA "Patient location: Core Based Statistical Area (CBSA)" label var PL_NCHS "Patient Location: NCHS Urban-Rural Code" label var PL_RUCC "Patient location: Rural-Urban Continuum Codes(RUCC)" label var PL_UIC "Patient location: Urban Influence Codes" label var PL_UR_CAT4 "Patient Location: Urban-Rural 4 Categories" label var PointOfOrigin_X "Point of origin for admission or visit, as received from source" label var PointOfOriginUB04 "Point of origin for admission or visit, UB-04 standard coding" label var PR1 "Procedure 1" label var PR2 "Procedure 2" label var PR3 "Procedure 3" label var PR4 "Procedure 4" label var PR5 "Procedure 5" label var PR6 "Procedure 6" label var PR7 "Procedure 7" label var PR8 "Procedure 8" label var PR9 "Procedure 9" label var PR10 "Procedure 10" label var PR11 "Procedure 11" label var PR12 "Procedure 12" label var PR13 "Procedure 13" label var PR14 "Procedure 14" label var PR15 "Procedure 15" label var PR16 "Procedure 16" label var PR17 "Procedure 17" label var PR18 "Procedure 18" label var PR19 "Procedure 19" label var PR20 "Procedure 20" label var PR21 "Procedure 21" label var PR22 "Procedure 22" label var PR23 "Procedure 23" label var PR24 "Procedure 24" label var PR25 "Procedure 25" label var PR26 "Procedure 26" label var PR27 "Procedure 27" label var PR28 "Procedure 28" label var PR29 "Procedure 29" label var PR30 "Procedure 30" label var PRCCS1 "CCS: procedure 1" label var PRCCS2 "CCS: procedure 2" label var PRCCS3 "CCS: procedure 3" label var PRCCS4 "CCS: procedure 4" label var PRCCS5 "CCS: procedure 5" label var PRCCS6 "CCS: procedure 6" label var PRCCS7 "CCS: procedure 7" label var PRCCS8 "CCS: procedure 8" label var PRCCS9 "CCS: procedure 9" label var PRCCS10 "CCS: procedure 10" label var PRCCS11 "CCS: procedure 11" label var PRCCS12 "CCS: procedure 12" label var PRCCS13 "CCS: procedure 13" label var PRCCS14 "CCS: procedure 14" label var PRCCS15 "CCS: procedure 15" label var PRCCS16 "CCS: procedure 16" label var PRCCS17 "CCS: procedure 17" label var PRCCS18 "CCS: procedure 18" label var PRCCS19 "CCS: procedure 19" label var PRCCS20 "CCS: procedure 20" label var PRCCS21 "CCS: procedure 21" label var PRCCS22 "CCS: procedure 22" label var PRCCS23 "CCS: procedure 23" label var PRCCS24 "CCS: procedure 24" label var PRCCS25 "CCS: procedure 25" label var PRCCS26 "CCS: procedure 26" label var PRCCS27 "CCS: procedure 27" label var PRCCS28 "CCS: procedure 28" label var PRCCS29 "CCS: procedure 29" label var PRCCS30 "CCS: procedure 30" label var PRDAY1 "Number of days from admission to PR1" label var PROCTYPE "Procedure type indicator" label var PRVER "Procedure Version" label var PSTATE "Patient State postal code" label var PSTCO2 "Patient state/county FIPS code, possibly derived from ZIP Code" label var RACE "Race (uniform)" label var RACE_X "Race (as received from source)" label var STATE_AS "State Ambulatory Surgery service indicator" label var STATE_ED "State Emergency Department service indicator" label var STATE_OS "State Observation Stay service indicator" label var TOTCHG "Total charges (cleaned)" label var TOTCHG_X "Total charges (as received from source)" label var YEAR "Calendar year" label var ZIP "Patient ZIP Code" label var ZIP3 "Patient ZIP Code, first 3 digits" label var ZIPINC_QRTL "Median household income national quartile for patient ZIP Code" label var HOSPID "HCUP hospital identification number" label var AYEAR "Admission year" label var BMONTH "Birth month" label var BYEAR "Birth year" label var PRMONTH1 "Month of procedure 1" label var PRYEAR1 "Year of procedure 1" *** Convert special values to missing values *** recode AGE (-99 -88 -66=.) recode AGEDAY (-99 -88 -66=.) recode AGEMONTH (-99 -88 -66=.) recode AMONTH (-9 -8 -6 -5=.) recode ATYPE (-9 -8 -6 -5=.) recode AWEEKEND (-9 -8 -6 -5=.) recode CPTCCS1 (-99 -88 -66=.) recode CPTCCS2 (-99 -88 -66=.) recode CPTCCS3 (-99 -88 -66=.) recode CPTCCS4 (-99 -88 -66=.) recode CPTCCS5 (-99 -88 -66=.) recode CPTCCS6 (-99 -88 -66=.) recode CPTCCS7 (-99 -88 -66=.) recode CPTCCS8 (-99 -88 -66=.) recode CPTCCS9 (-99 -88 -66=.) recode CPTCCS10 (-99 -88 -66=.) recode CPTCCS11 (-99 -88 -66=.) recode CPTCCS12 (-99 -88 -66=.) recode CPTCCS13 (-99 -88 -66=.) recode CPTCCS14 (-99 -88 -66=.) recode CPTCCS15 (-99 -88 -66=.) recode CPTCCS16 (-99 -88 -66=.) recode CPTCCS17 (-99 -88 -66=.) recode CPTCCS18 (-99 -88 -66=.) recode CPTCCS19 (-99 -88 -66=.) recode CPTCCS20 (-99 -88 -66=.) recode CPTCCS21 (-99 -88 -66=.) recode CPTCCS22 (-99 -88 -66=.) recode CPTCCS23 (-99 -88 -66=.) recode CPTCCS24 (-99 -88 -66=.) recode CPTCCS25 (-99 -88 -66=.) recode CPTCCS26 (-99 -88 -66=.) recode CPTCCS27 (-99 -88 -66=.) recode CPTCCS28 (-99 -88 -66=.) recode CPTCCS29 (-99 -88 -66=.) recode CPTCCS30 (-99 -88 -66=.) recode CPTDAY1 (-99 -88 -66=.) recode CPTDAY2 (-99 -88 -66=.) recode CPTDAY3 (-99 -88 -66=.) recode CPTDAY4 (-99 -88 -66=.) recode CPTDAY5 (-99 -88 -66=.) recode CPTDAY6 (-99 -88 -66=.) recode CPTDAY7 (-99 -88 -66=.) recode CPTDAY8 (-99 -88 -66=.) recode CPTDAY9 (-99 -88 -66=.) recode CPTDAY10 (-99 -88 -66=.) recode CPTDAY11 (-99 -88 -66=.) recode CPTDAY12 (-99 -88 -66=.) recode CPTDAY13 (-99 -88 -66=.) recode CPTDAY14 (-99 -88 -66=.) recode CPTDAY15 (-99 -88 -66=.) recode CPTDAY16 (-99 -88 -66=.) recode CPTDAY17 (-99 -88 -66=.) recode CPTDAY18 (-99 -88 -66=.) recode CPTDAY19 (-99 -88 -66=.) recode CPTDAY20 (-99 -88 -66=.) recode CPTDAY21 (-99 -88 -66=.) recode CPTDAY22 (-99 -88 -66=.) recode CPTDAY23 (-99 -88 -66=.) recode CPTDAY24 (-99 -88 -66=.) recode CPTDAY25 (-99 -88 -66=.) recode CPTDAY26 (-99 -88 -66=.) recode CPTDAY27 (-99 -88 -66=.) recode CPTDAY28 (-99 -88 -66=.) recode CPTDAY29 (-99 -88 -66=.) recode CPTDAY30 (-99 -88 -66=.) recode DIED (-9 -8 -6 -5=.) recode DISPUB04 (-9 -8 -6 -5=.) recode DISPUNIFORM (-9 -8 -6 -5=.) recode DMONTH (-9 -8 -6 -5=.) recode DQTR (-9 -8 -6 -5=.) recode DXCCS1 (-999 -888 -666=.) recode DXCCS2 (-999 -888 -666=.) recode DXCCS3 (-999 -888 -666=.) recode DXCCS4 (-999 -888 -666=.) recode DXCCS5 (-999 -888 -666=.) recode DXCCS6 (-999 -888 -666=.) recode DXCCS7 (-999 -888 -666=.) recode DXCCS8 (-999 -888 -666=.) recode DXCCS9 (-999 -888 -666=.) recode DXCCS10 (-999 -888 -666=.) recode DXCCS11 (-999 -888 -666=.) recode DXCCS12 (-999 -888 -666=.) recode DXCCS13 (-999 -888 -666=.) recode DXCCS14 (-999 -888 -666=.) recode DXCCS15 (-999 -888 -666=.) recode DXCCS16 (-999 -888 -666=.) recode DXCCS17 (-999 -888 -666=.) recode DXCCS18 (-999 -888 -666=.) recode DXCCS19 (-999 -888 -666=.) recode DXCCS20 (-999 -888 -666=.) recode DXCCS21 (-999 -888 -666=.) recode DXCCS22 (-999 -888 -666=.) recode DXCCS23 (-999 -888 -666=.) recode DXCCS24 (-999 -888 -666=.) recode DXCCS25 (-999 -888 -666=.) recode DXCCS26 (-999 -888 -666=.) recode DXCCS27 (-999 -888 -666=.) recode DXCCS28 (-999 -888 -666=.) recode DXCCS29 (-999 -888 -666=.) recode DXCCS30 (-999 -888 -666=.) recode DXVER (-99 -88 -66=.) recode E_CCS1 (-999 -888 -666=.) recode E_CCS2 (-999 -888 -666=.) recode E_CCS3 (-999 -888 -666=.) recode E_CCS4 (-999 -888 -666=.) recode E_CCS5 (-999 -888 -666=.) recode E_CCS6 (-999 -888 -666=.) recode E_CCS7 (-999 -888 -666=.) recode E_CCS8 (-999 -888 -666=.) recode E_CCS9 (-999 -888 -666=.) recode E_CCS10 (-999 -888 -666=.) recode FEMALE (-9 -8 -6 -5=.) recode HCUP_ED (-9 -8 -6 -5=.) recode HCUP_OS (-9 -8 -6 -5=.) recode HCUP_SURGERY_BROAD_CPT (-9999 -8888 -6666=.) recode HCUP_SURGERY_BROAD_I9 (-9999 -8888 -6666=.) recode HCUP_SURGERY_NARROW_CPT (-9999 -8888 -6666=.) recode HCUP_SURGERY_NARROW_I9 (-9999 -8888 -6666=.) recode HISPANIC (-9 -8 -6 -5=.) recode HOSPBRTH (-99 -88 -66=.) recode LOS (-9999 -8888 -6666=.) recode LOS_X (-99999 -88888 -66666=.) recode MDNUM1_R (-99999999 -88888888 -66666666=.) recode MEDINCSTQ (-9 -8 -6 -5=.) recode MRN_R (-99999999 -88888888 -66666666=.) recode NCHRONIC (-99 -88 -66=.) recode NCPT (-999 -888 -666=.) recode NDX (-99 -88 -66=.) recode NECODE (-9 -8 -6 -5=.) recode NEOMAT (-9 -8 -6 -5=.) recode NPR (-99 -88 -66=.) recode ORPROC (-9 -8 -6 -5=.) recode PAY1 (-9 -8 -6 -5=.) recode PAY2 (-9 -8 -6 -5=.) recode PL_CBSA (-99 -88 -66=.) recode PL_NCHS (-9 -8 -6 -5=.) recode PL_RUCC (-9 -8 -6 -5=.) recode PL_UIC (-9 -8 -6 -5=.) recode PL_UR_CAT4 (-9 -8 -6 -5=.) recode PRCCS1 (-99 -88 -66=.) recode PRCCS2 (-99 -88 -66=.) recode PRCCS3 (-99 -88 -66=.) recode PRCCS4 (-99 -88 -66=.) recode PRCCS5 (-99 -88 -66=.) recode PRCCS6 (-99 -88 -66=.) recode PRCCS7 (-99 -88 -66=.) recode PRCCS8 (-99 -88 -66=.) recode PRCCS9 (-99 -88 -66=.) recode PRCCS10 (-99 -88 -66=.) recode PRCCS11 (-99 -88 -66=.) recode PRCCS12 (-99 -88 -66=.) recode PRCCS13 (-99 -88 -66=.) recode PRCCS14 (-99 -88 -66=.) recode PRCCS15 (-99 -88 -66=.) recode PRCCS16 (-99 -88 -66=.) recode PRCCS17 (-99 -88 -66=.) recode PRCCS18 (-99 -88 -66=.) recode PRCCS19 (-99 -88 -66=.) recode PRCCS20 (-99 -88 -66=.) recode PRCCS21 (-99 -88 -66=.) recode PRCCS22 (-99 -88 -66=.) recode PRCCS23 (-99 -88 -66=.) recode PRCCS24 (-99 -88 -66=.) recode PRCCS25 (-99 -88 -66=.) recode PRCCS26 (-99 -88 -66=.) recode PRCCS27 (-99 -88 -66=.) recode PRCCS28 (-99 -88 -66=.) recode PRCCS29 (-99 -88 -66=.) recode PRCCS30 (-99 -88 -66=.) recode PRDAY1 (-9999 -8888 -6666=.) recode PROCTYPE (-99 -88 -66=.) recode PRVER (-99 -88 -66=.) recode PSTCO2 (-9999 -8888 -6666=.) recode RACE (-9 -8 -6 -5=.) recode STATE_AS (-9 -8 -6 -5=.) recode STATE_ED (-9 -8 -6 -5=.) recode STATE_OS (-9 -8 -6 -5=.) recode TOTCHG (-999999999 -888888888 -666666666=.) recode TOTCHG_X (-99999999999.99 -88888888888.88 -66666666666.66=.) recode YEAR (-999 -888 -666=.) recode ZIPINC_QRTL (-99 -88 -66=.) recode AYEAR (-999 -888 -666=.) recode BMONTH (-9 -8 -6 -5=.) recode BYEAR (-999 -888 -666=.) recode PRMONTH1 (-9 -8 -6 -5=.) recode PRYEAR1 (-999 -888 -666=.) save "MI_SASD_2015q1q3_CORE.dta", replace