Hello,   I have 2 tables  Reg_SHSC_sorted with 207 cases CIHI_SHSC_sorted with 115 cases I am trying to find the cases that are  present in the 1st table i.e. Reg_SHSC_sorted and missing from  the 2nd table i.e. CIHI_SHSC_sorted  Is the following code correct? proc sql; create table MissingCIHI as select a.RegID, a.days_to_removal_date,a.site,b.* from reg_SHSC_sorted a left join CIHI_SHSC_sorted b on a.Reg_ID =b.ID and a.site=b.site and a.days_to_removal_date>=b.days_to_admdate-2 and a.days_to_removal_date <=b.days_to_ddate+2 where a.RegID NE b.ID ;quit; ... View more

data Non_QBP_PBF_STROKE (keep = HEM_NONQBP ISC_NONQBP HEM_QBP ISC_QBP INDEX_ACUTE); set pbf_stroke; If  sum(of HEM_NONQBP ISC_NONQBP) =1 and INDEX_ACUTE=1 and sum(of HEM_QBP ISC_QBP)=0; run;   How would I write the above step correctly   I want to get the count of all cases where either HEM_NONQBP or ISC_NONQBP=1 and index-acute=1 and HEM_QBP or ISC_QBP should be 0   Thanks ... View more

  Hello Can someone advise why i would get this error    NOTE: Invalid data for ADM_DT in line 21 58-75. NOTE: Invalid data for ADM_TM in line 21 77-94. NOTE: Invalid data for DISCH_DT in line 21 109-126. NOTE: Invalid data for DISCH_TM in line 21 128-145. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed   My code: data WORK.DAD1819Q3 ; infile "\\ccnfs\Company\KNOWLEDGE MANAGEMENT\DAD_NACRS\FY1819Q3_DAD.csv" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2; *obs=101; %let _EFIERR_ = 0; /* set the ERROR detection macro variable*/ informat CIHI_KEY $16. ; informat INST_NO $4. ; informat CHECK_DIGIT $1. ; informat RECORD_ID $1. ; informat RECORD_NO $1. ; informat CODER_ID $2. ; informat PROVINCE_ISSUING_HCN $2. ; informat RESPONSIBILITY_FOR_PAYMENT $2. ; informat PROVINCIAL_ANCILLARY_DATA $17. ; informat POSTAL_CODE $6. ; informat RESIDENCE_CODE $7. ; *informat BIRTH_DT anydtdtm40. ; /* VARIABLE DOES NOT EXIST IN FY1718Q4 DATA */ informat AGE_CODE $1. ; informat AGE_UNITS $3. ; informat GENDER $1. ; informat ADM_DT DATETIME20. ; informat ADM_TM DATETIME20. ; informat INST_FROM_TYPE $1. ; informat INST_FROM_NO $5. ; informat ADM_CATEGORY $1. ; informat READM_CODE $1. ; informat AMBULANCE_CODE $1. ; informat ENTRY_CODE $1. ; informat PATIENT_LEFT_ED_DT DATETIME20. ; informat PATIENT_LEFT_ED_TM DATETIME20. ; informat WAIT_TM_IN_ED best32. ; informat DISCH_DT DATETIME20. ; informat DISCH_TM DATETIME20. ; informat INST_TO_TYPE $1. ; informat INST_TO_NO $5. ; informat DISCH_DISPOSITION $2. ; informat MAIN_PATIENT_SUB_SERVICE $1. ; informat BLOOD_TRANS_NOT_RECEIVED_IND $1.; informat BLOOD_TRANSFUSION_IND $1. ; informat RED_BLOOD_CELL_IND $1. ; informat PLATELETS_IND $1. ; informat PLASMA_IND $1. ; informat ALBUMIN_IND $1. ; informat OTHER_BLOOD_COMPONENT_IND $1. ; informat AUTOTRASFUSION_IND $1. ; informat BASIC_OPTION_01 $1. ; informat BASIC_OPTION_02 $1. ; informat BASIC_OPTION_03 $1. ; informat BASIC_OPTION_04 $1. ; informat BASIC_OPTION_05 $1. ; informat BASIC_OPTION_06 $1. ; informat BASIC_OPTION_07 $1. ; informat BASIC_OPTION_08 $1. ; informat BASIC_OPTION_09 $1. ; informat BASIC_OPTION_10 $1. ; informat BASIC_OPTION_11 $1. ; informat BASIC_OPTION_12 $1. ; informat BASIC_OPTION_13 $1. ; informat BASIC_OPTION_14 $1. ; informat BASIC_OPTION_15 $1. ; informat BASIC_OPTION_16 $1. ; informat BASIC_OPTION_17 $2. ; informat BASIC_OPTION_18 $2. ; informat BASIC_OPTION_19 $4. ; informat WEIGHT_IN_GRAMS best32. ; informat AGE_GROUP $2. ; informat CODING_CLASSIFICATION_IND $1. ; informat INST_TYPE $1. ; informat ANALYTICAL_INST_TYPE $1. ; informat ABSTRACT_OVERFLOW $1. ; informat FIRST_SPECIAL_CARE_UNIT_NO $2.; informat LAST_ACTIVITY_DT DATETIME20. ; informat SERVICE_TRANSFER_SERVICE_1 $2.; informat SERVICE_TRANSFER_SERVICE_2 $2. ; informat SERVICE_TRANSFER_SERVICE_3 $2. ; informat SERVICE_TRANSFER_SUB_SERVICE_1 $1.; informat SERVICE_TRANSFER_SUB_SERVICE_2 $1.; informat SERVICE_TRANSFER_SUB_SERVICE_3 $1.; informat SERVICE_TRANSFER_DAYS_1 best32. ; informat SERVICE_TRANSFER_DAYS_2 best32. ; informat SERVICE_TRANSFER_DAYS_3 best32. ; informat CA_STAGING_CLINICAL_TUMOUR $2. ; informat CA_STAGING_CLINICAL_NODE $2. ; informat CA_STAGING_CLINICAL_METASTASIS $1.; informat CA_STAGING_PATHO_TUMOUR $2. ; informat CA_STAGING_PATHO_NODE $2. ; informat CA_STAGING_PATHO_METASTASIS $1. ; informat CA_STAGING_SUMMARY_STAGE $4. ; informat DIAG_PREFIX_01 $1. ; informat DIAG_PREFIX_02 $1. ; informat DIAG_PREFIX_03 $1. ; informat DIAG_PREFIX_04 $1. ; informat DIAG_PREFIX_05 $1. ; informat DIAG_PREFIX_06 $1. ; informat DIAG_PREFIX_07 $1. ; informat DIAG_PREFIX_08 $1. ; informat DIAG_PREFIX_09 $1. ; informat DIAG_PREFIX_10 $1. ; informat DIAG_PREFIX_11 $1. ; informat DIAG_PREFIX_12 $1. ; informat DIAG_PREFIX_13 $1. ; informat DIAG_PREFIX_14 $1. ; informat DIAG_PREFIX_15 $1. ; informat DIAG_PREFIX_16 $1. ; informat DIAG_PREFIX_17 $1. ; informat DIAG_PREFIX_18 $1. ; informat DIAG_PREFIX_19 $1. ; informat DIAG_PREFIX_20 $1. ; informat DIAG_PREFIX_21 $1. ; informat DIAG_PREFIX_22 $1. ; informat DIAG_PREFIX_23 $1. ; informat DIAG_PREFIX_24 $1. ; informat DIAG_PREFIX_25 $1. ; informat DIAG_CODE_01 $7. ; informat DIAG_CODE_02 $7. ; informat DIAG_CODE_03 $7. ; informat DIAG_CODE_04 $7. ; informat DIAG_CODE_05 $7. ; informat DIAG_CODE_06 $7. ; informat DIAG_CODE_07 $7. ; informat DIAG_CODE_08 $7. ; informat DIAG_CODE_09 $7. ; informat DIAG_CODE_10 $7. ; informat DIAG_CODE_11 $7. ; informat DIAG_CODE_12 $7. ; informat DIAG_CODE_13 $7. ; informat DIAG_CODE_14 $7. ; informat DIAG_CODE_15 $7. ; informat DIAG_CODE_16 $7. ; informat DIAG_CODE_17 $7. ; informat DIAG_CODE_18 $7. ; informat DIAG_CODE_19 $7. ; informat DIAG_CODE_20 $7. ; informat DIAG_CODE_21 $7. ; informat DIAG_CODE_22 $7. ; informat DIAG_CODE_23 $7. ; informat DIAG_CODE_24 $7. ; informat DIAG_CODE_25 $7. ; informat DIAG_TYPE_01 $1. ; informat DIAG_TYPE_02 $1. ; informat DIAG_TYPE_03 $1. ; informat DIAG_TYPE_04 $1. ; informat DIAG_TYPE_05 $1. ; informat DIAG_TYPE_06 $1. ; informat DIAG_TYPE_07 $1. ; informat DIAG_TYPE_08 $1. ; informat DIAG_TYPE_09 $1. ; informat DIAG_TYPE_10 $1. ; informat DIAG_TYPE_11 $1. ; informat DIAG_TYPE_12 $1. ; informat DIAG_TYPE_13 $1. ; informat DIAG_TYPE_14 $1. ; informat DIAG_TYPE_15 $1. ; informat DIAG_TYPE_16 $1. ; informat DIAG_TYPE_17 $1. ; informat DIAG_TYPE_18 $1. ; informat DIAG_TYPE_19 $1. ; informat DIAG_TYPE_20 $1. ; informat DIAG_TYPE_21 $1. ; informat DIAG_TYPE_22 $1. ; informat DIAG_TYPE_23 $1. ; informat DIAG_TYPE_24 $1. ; informat DIAG_TYPE_25 $1. ; informat DIAG_CLUSTER_01 $1. ; informat DIAG_CLUSTER_02 $1. ; informat DIAG_CLUSTER_03 $1. ; informat DIAG_CLUSTER_04 $1. ; informat DIAG_CLUSTER_05 $1. ; informat DIAG_CLUSTER_06 $1. ; informat DIAG_CLUSTER_07 $1. ; informat DIAG_CLUSTER_08 $1. ; informat DIAG_CLUSTER_09 $1. ; informat DIAG_CLUSTER_10 $1. ; informat DIAG_CLUSTER_11 $1. ; informat DIAG_CLUSTER_12 $1. ; informat DIAG_CLUSTER_13 $1. ; informat DIAG_CLUSTER_14 $1. ; informat DIAG_CLUSTER_15 $1. ; informat DIAG_CLUSTER_16 $1. ; informat DIAG_CLUSTER_17 $1. ; informat DIAG_CLUSTER_18 $1. ; informat DIAG_CLUSTER_19 $1. ; informat DIAG_CLUSTER_20 $1. ; informat DIAG_CLUSTER_21 $1. ; informat DIAG_CLUSTER_22 $1. ; informat DIAG_CLUSTER_23 $1. ; informat DIAG_CLUSTER_24 $1. ; informat DIAG_CLUSTER_25 $1. ; informat DIED_DURING_INTERVENTION $1. ; informat INTERV_EPISODE_NUMBER_01 $2. ; informat INTERV_EPISODE_NUMBER_02 $2. ; informat INTERV_EPISODE_NUMBER_03 $2. ; informat INTERV_EPISODE_NUMBER_04 $2. ; informat INTERV_EPISODE_NUMBER_05 $2. ; informat INTERV_EPISODE_NUMBER_06 $2. ; informat INTERV_EPISODE_NUMBER_07 $2. ; informat INTERV_EPISODE_NUMBER_08 $2. ; informat INTERV_EPISODE_NUMBER_09 $2. ; informat INTERV_EPISODE_NUMBER_10 $2. ; informat INTERV_EPISODE_NUMBER_11 $2. ; informat INTERV_EPISODE_NUMBER_12 $2. ; informat INTERV_EPISODE_NUMBER_13 $2. ; informat INTERV_EPISODE_NUMBER_14 $2. ; informat INTERV_EPISODE_NUMBER_15 $2. ; informat INTERV_EPISODE_NUMBER_16 $2. ; informat INTERV_EPISODE_NUMBER_17 $2. ; informat INTERV_EPISODE_NUMBER_18 $2. ; informat INTERV_EPISODE_NUMBER_19 $2. ; informat INTERV_EPISODE_NUMBER_20 $2. ; informat INTERV_INTV_IN_EPIS_NUM_01 $2.; informat INTERV_INTV_IN_EPIS_NUM_02 $2.; informat INTERV_INTV_IN_EPIS_NUM_03 $2.; informat INTERV_INTV_IN_EPIS_NUM_04 $2.; informat INTERV_INTV_IN_EPIS_NUM_05 $2.; informat INTERV_INTV_IN_EPIS_NUM_06 $2.; informat INTERV_INTV_IN_EPIS_NUM_07 $2. ; informat INTERV_INTV_IN_EPIS_NUM_08 $2. ; informat INTERV_INTV_IN_EPIS_NUM_09 $2. ; informat INTERV_INTV_IN_EPIS_NUM_10 $2. ; informat INTERV_INTV_IN_EPIS_NUM_11 $2. ; informat INTERV_INTV_IN_EPIS_NUM_12 $2. ; informat INTERV_INTV_IN_EPIS_NUM_13 $2. ; informat INTERV_INTV_IN_EPIS_NUM_14 $2. ; informat INTERV_INTV_IN_EPIS_NUM_15 $2. ; informat INTERV_INTV_IN_EPIS_NUM_16 $2. ; informat INTERV_INTV_IN_EPIS_NUM_17 $2. ; informat INTERV_INTV_IN_EPIS_NUM_18 $2. ; informat INTERV_INTV_IN_EPIS_NUM_19 $2. ; informat INTERV_INTV_IN_EPIS_NUM_20 $2. ; informat INTERV_EPISODE_START_DT_01 DATETIME20.; informat INTERV_EPISODE_START_DT_02 DATETIME20.; informat INTERV_EPISODE_START_DT_03 DATETIME20.; informat INTERV_EPISODE_START_DT_04 DATETIME20.; informat INTERV_EPISODE_START_DT_05 DATETIME20.; informat INTERV_EPISODE_START_DT_06 DATETIME20.; informat INTERV_EPISODE_START_DT_07 DATETIME20.; informat INTERV_EPISODE_START_DT_08 DATETIME20.; informat INTERV_EPISODE_START_DT_09 DATETIME20.; informat INTERV_EPISODE_START_DT_10 DATETIME20.; informat INTERV_EPISODE_START_DT_11 DATETIME20.; informat INTERV_EPISODE_START_DT_12 DATETIME20.; informat INTERV_EPISODE_START_DT_13 DATETIME20.; informat INTERV_EPISODE_START_DT_14 DATETIME20.; informat INTERV_EPISODE_START_DT_15 DATETIME20.; informat INTERV_EPISODE_START_DT_16 DATETIME20.; informat INTERV_EPISODE_START_DT_17 DATETIME20.; informat INTERV_EPISODE_START_DT_18 DATETIME20.; informat INTERV_EPISODE_START_DT_19 DATETIME20.; informat INTERV_EPISODE_START_DT_20 DATETIME20.; informat INTERV_EPISODE_START_TM_01 DATETIME20.; informat INTERV_EPISODE_START_TM_02 DATETIME20.; informat INTERV_EPISODE_START_TM_03 DATETIME20.; informat INTERV_EPISODE_START_TM_04 DATETIME20.; informat INTERV_EPISODE_START_TM_05 DATETIME20.; informat INTERV_EPISODE_START_TM_06 DATETIME20.; informat INTERV_EPISODE_START_TM_07 DATETIME20.; informat INTERV_EPISODE_START_TM_08 DATETIME20.; informat INTERV_EPISODE_START_TM_09 DATETIME20.; informat INTERV_EPISODE_START_TM_10 DATETIME20.; informat INTERV_EPISODE_START_TM_11 DATETIME20.; informat INTERV_EPISODE_START_TM_12 DATETIME20.; informat INTERV_EPISODE_START_TM_13 DATETIME20.; informat INTERV_EPISODE_START_TM_14 DATETIME20.; informat INTERV_EPISODE_START_TM_15 DATETIME20.; informat INTERV_EPISODE_START_TM_16 DATETIME20.; informat INTERV_EPISODE_START_TM_17 DATETIME20.; informat INTERV_EPISODE_START_TM_18 DATETIME20.; informat INTERV_EPISODE_START_TM_19 DATETIME20.; informat INTERV_EPISODE_START_TM_20 DATETIME20.; informat INTERV_EPISODE_END_DT_01 DATETIME20.; informat INTERV_EPISODE_END_DT_02 DATETIME20.; informat INTERV_EPISODE_END_DT_03 DATETIME20.; informat INTERV_EPISODE_END_DT_04 DATETIME20.; informat INTERV_EPISODE_END_DT_05 DATETIME20.; informat INTERV_EPISODE_END_DT_06 DATETIME20.; informat INTERV_EPISODE_END_DT_07 DATETIME20.; informat INTERV_EPISODE_END_DT_08 DATETIME20.; informat INTERV_EPISODE_END_DT_09 DATETIME20.; informat INTERV_EPISODE_END_DT_10 DATETIME20.; informat INTERV_EPISODE_END_DT_11 DATETIME20.; informat INTERV_EPISODE_END_DT_12 DATETIME20.; informat INTERV_EPISODE_END_DT_13 DATETIME20.; informat INTERV_EPISODE_END_DT_14 DATETIME20.; informat INTERV_EPISODE_END_DT_15 DATETIME20.; informat INTERV_EPISODE_END_DT_16 DATETIME20.; informat INTERV_EPISODE_END_DT_17 DATETIME20.; informat INTERV_EPISODE_END_DT_18 DATETIME20.; informat INTERV_EPISODE_END_DT_19 DATETIME20.; informat INTERV_EPISODE_END_DT_20 DATETIME20.; informat INTERV_EPISODE_END_TM_01 DATETIME20.; informat INTERV_EPISODE_END_TM_02 DATETIME20.; informat INTERV_EPISODE_END_TM_03 DATETIME20.; informat INTERV_EPISODE_END_TM_04 DATETIME20.; informat INTERV_EPISODE_END_TM_05 DATETIME20.; informat INTERV_EPISODE_END_TM_06 DATETIME20.; informat INTERV_EPISODE_END_TM_07 DATETIME20.; informat INTERV_EPISODE_END_TM_08 DATETIME20.; informat INTERV_EPISODE_END_TM_09 DATETIME20.; informat INTERV_EPISODE_END_TM_10 DATETIME20.; informat INTERV_EPISODE_END_TM_11 DATETIME20.; informat INTERV_EPISODE_END_TM_12 DATETIME20.; informat INTERV_EPISODE_END_TM_13 DATETIME20.; informat INTERV_EPISODE_END_TM_14 DATETIME20.; informat INTERV_EPISODE_END_TM_15 DATETIME20.; informat INTERV_EPISODE_END_TM_16 DATETIME20.; informat INTERV_EPISODE_END_TM_17 DATETIME20.; informat INTERV_EPISODE_END_TM_18 DATETIME20.; informat INTERV_EPISODE_END_TM_19 DATETIME20.; informat INTERV_EPISODE_END_TM_20 DATETIME20.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_01 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_02 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_03 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_04 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_05 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_06 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_07 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_08 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_09 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_10 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_11 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_12 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_13 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_14 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_15 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_16 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_17 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_18 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_19 $1.; informat INTERV_BEGUN_PRE_ADMIT_FLAG_20 $1.; informat INTERV_CODE_01 $10. ; informat INTERV_CODE_02 $10. ; informat INTERV_CODE_03 $10. ; informat INTERV_CODE_04 $10. ; informat INTERV_CODE_05 $10. ; informat INTERV_CODE_06 $10. ; informat INTERV_CODE_07 $10. ; informat INTERV_CODE_08 $10. ; informat INTERV_CODE_09 $10. ; informat INTERV_CODE_10 $10. ; informat INTERV_CODE_11 $10. ; informat INTERV_CODE_12 $10. ; informat INTERV_CODE_13 $10. ; informat INTERV_CODE_14 $10. ; informat INTERV_CODE_15 $10. ; informat INTERV_CODE_16 $10. ; informat INTERV_CODE_17 $10. ; informat INTERV_CODE_18 $10. ; informat INTERV_CODE_19 $10. ; informat INTERV_CODE_20 $10. ; informat INTERV_STATUS_ATTRIB_01 $2. ; informat INTERV_STATUS_ATTRIB_02 $2. ; informat INTERV_STATUS_ATTRIB_03 $2. ; informat INTERV_STATUS_ATTRIB_04 $2. ; informat INTERV_STATUS_ATTRIB_05 $2. ; informat INTERV_STATUS_ATTRIB_06 $2. ; informat INTERV_STATUS_ATTRIB_07 $2. ; informat INTERV_STATUS_ATTRIB_08 $2. ; informat INTERV_STATUS_ATTRIB_09 $2. ; informat INTERV_STATUS_ATTRIB_10 $2. ; informat INTERV_STATUS_ATTRIB_11 $2. ; informat INTERV_STATUS_ATTRIB_12 $2. ; informat INTERV_STATUS_ATTRIB_13 $2. ; informat INTERV_STATUS_ATTRIB_14 $2. ; informat INTERV_STATUS_ATTRIB_15 $2. ; informat INTERV_STATUS_ATTRIB_16 $2. ; informat INTERV_STATUS_ATTRIB_17 $2. ; informat INTERV_STATUS_ATTRIB_18 $2. ; informat INTERV_STATUS_ATTRIB_19 $2. ; informat INTERV_STATUS_ATTRIB_20 $2. ; informat INTERV_LOC_ATTRIB_01 $2. ; informat INTERV_LOC_ATTRIB_02 $2. ; informat INTERV_LOC_ATTRIB_03 $2. ; informat INTERV_LOC_ATTRIB_04 $2. ; informat INTERV_LOC_ATTRIB_05 $2. ; informat INTERV_LOC_ATTRIB_06 $2. ; informat INTERV_LOC_ATTRIB_07 $2. ; informat INTERV_LOC_ATTRIB_08 $2. ; informat INTERV_LOC_ATTRIB_09 $2. ; informat INTERV_LOC_ATTRIB_10 $2. ; informat INTERV_LOC_ATTRIB_11 $2. ; informat INTERV_LOC_ATTRIB_12 $2. ; informat INTERV_LOC_ATTRIB_13 $2. ; informat INTERV_LOC_ATTRIB_14 $2. ; informat INTERV_LOC_ATTRIB_15 $2. ; informat INTERV_LOC_ATTRIB_16 $2. ; informat INTERV_LOC_ATTRIB_17 $2. ; informat INTERV_LOC_ATTRIB_18 $2. ; informat INTERV_LOC_ATTRIB_19 $2. ; informat INTERV_LOC_ATTRIB_20 $2. ; informat INTERV_EXTENT_ATTRIB_01 $2. ; informat INTERV_EXTENT_ATTRIB_02 $2. ; informat INTERV_EXTENT_ATTRIB_03 $2. ; informat INTERV_EXTENT_ATTRIB_04 $2. ; informat INTERV_EXTENT_ATTRIB_05 $2. ; informat INTERV_EXTENT_ATTRIB_06 $2. ; informat INTERV_EXTENT_ATTRIB_07 $2. ; informat INTERV_EXTENT_ATTRIB_08 $2. ; informat INTERV_EXTENT_ATTRIB_09 $2. ; informat INTERV_EXTENT_ATTRIB_10 $2. ; informat INTERV_EXTENT_ATTRIB_11 $2. ; informat INTERV_EXTENT_ATTRIB_12 $2. ; informat INTERV_EXTENT_ATTRIB_13 $2. ; informat INTERV_EXTENT_ATTRIB_14 $2. ; informat INTERV_EXTENT_ATTRIB_15 $2. ; informat INTERV_EXTENT_ATTRIB_16 $2. ; informat INTERV_EXTENT_ATTRIB_17 $2. ; informat INTERV_EXTENT_ATTRIB_18 $2. ; informat INTERV_EXTENT_ATTRIB_19 $2. ; informat INTERV_EXTENT_ATTRIB_20 $2. ; informat INTERV_PROVIDER_NO_01 $15. ; informat INTERV_PROVIDER_NO_02 $15. ; informat INTERV_PROVIDER_NO_03 $15. ; informat INTERV_PROVIDER_NO_04 $15. ; informat INTERV_PROVIDER_NO_05 $15. ; informat INTERV_PROVIDER_NO_06 $15. ; informat INTERV_PROVIDER_NO_07 $15. ; informat INTERV_PROVIDER_NO_08 $15. ; informat INTERV_PROVIDER_NO_09 $15. ; informat INTERV_PROVIDER_NO_10 $15. ; informat INTERV_PROVIDER_NO_11 $15. ; informat INTERV_PROVIDER_NO_12 $15. ; informat INTERV_PROVIDER_NO_13 $15. ; informat INTERV_PROVIDER_NO_14 $15. ; informat INTERV_PROVIDER_NO_15 $15. ; informat INTERV_PROVIDER_NO_16 $15. ; informat INTERV_PROVIDER_NO_17 $15. ; informat INTERV_PROVIDER_NO_18 $15. ; informat INTERV_PROVIDER_NO_19 $15. ; informat INTERV_PROVIDER_NO_20 $15. ; informat INTERV_PROVIDER_SERVICE_01 $5.; informat INTERV_PROVIDER_SERVICE_02 $5.; informat INTERV_PROVIDER_SERVICE_03 $5.; informat INTERV_PROVIDER_SERVICE_04 $5.; informat INTERV_PROVIDER_SERVICE_05 $5.; informat INTERV_PROVIDER_SERVICE_06 $5.; informat INTERV_PROVIDER_SERVICE_07 $5.; informat INTERV_PROVIDER_SERVICE_08 $5.; informat INTERV_PROVIDER_SERVICE_09 $5.; informat INTERV_PROVIDER_SERVICE_10 $5.; informat INTERV_PROVIDER_SERVICE_11 $5.; informat INTERV_PROVIDER_SERVICE_12 $5.; informat INTERV_PROVIDER_SERVICE_13 $5.; informat INTERV_PROVIDER_SERVICE_14 $5.; informat INTERV_PROVIDER_SERVICE_15 $5.; informat INTERV_PROVIDER_SERVICE_16 $5.; informat INTERV_PROVIDER_SERVICE_17 $5.; informat INTERV_PROVIDER_SERVICE_18 $5.; informat INTERV_PROVIDER_SERVICE_19 $5.; informat INTERV_PROVIDER_SERVICE_20 $5.; informat INTERV_TISSUE_01 $1. ; informat INTERV_TISSUE_02 $1. ; informat INTERV_TISSUE_03 $1. ; informat INTERV_TISSUE_04 $1. ; informat INTERV_TISSUE_05 $1. ; informat INTERV_TISSUE_06 $1. ; informat INTERV_TISSUE_07 $1. ; informat INTERV_TISSUE_08 $1. ; informat INTERV_TISSUE_09 $1. ; informat INTERV_TISSUE_10 $1. ; informat INTERV_TISSUE_11 $1. ; informat INTERV_TISSUE_12 $1. ; informat INTERV_TISSUE_13 $1. ; informat INTERV_TISSUE_14 $1. ; informat INTERV_TISSUE_15 $1. ; informat INTERV_TISSUE_16 $1. ; informat INTERV_TISSUE_17 $1. ; informat INTERV_TISSUE_18 $1. ; informat INTERV_TISSUE_19 $1. ; informat INTERV_TISSUE_20 $1. ; informat INTERV_OR_LOC_01 $2. ; informat INTERV_OR_LOC_02 $2. ; informat INTERV_OR_LOC_03 $2. ; informat INTERV_OR_LOC_04 $2. ; informat INTERV_OR_LOC_05 $2. ; informat INTERV_OR_LOC_06 $2. ; informat INTERV_OR_LOC_07 $2. ; informat INTERV_OR_LOC_08 $2. ; informat INTERV_OR_LOC_09 $2. ; informat INTERV_OR_LOC_10 $2. ; informat INTERV_OR_LOC_11 $2. ; informat INTERV_OR_LOC_12 $2. ; informat INTERV_OR_LOC_13 $2. ; informat INTERV_OR_LOC_14 $2. ; informat INTERV_OR_LOC_15 $2. ; informat INTERV_OR_LOC_16 $2. ; informat INTERV_OR_LOC_17 $2. ; informat INTERV_OR_LOC_18 $2. ; informat INTERV_OR_LOC_19 $2. ; informat INTERV_OR_LOC_20 $2. ; informat INTERV_ANAESTHETIST_01 $15. ; informat INTERV_ANAESTHETIST_02 $15. ; informat INTERV_ANAESTHETIST_03 $15. ; informat INTERV_ANAESTHETIST_04 $15. ; informat INTERV_ANAESTHETIST_05 $15. ; informat INTERV_ANAESTHETIST_06 $15. ; informat INTERV_ANAESTHETIST_07 $15. ; informat INTERV_ANAESTHETIST_08 $15. ; informat INTERV_ANAESTHETIST_09 $15. ; informat INTERV_ANAESTHETIST_10 $15. ; informat INTERV_ANAESTHETIST_11 $15. ; informat INTERV_ANAESTHETIST_12 $15. ; informat INTERV_ANAESTHETIST_13 $15. ; informat INTERV_ANAESTHETIST_14 $15. ; informat INTERV_ANAESTHETIST_15 $15. ; informat INTERV_ANAESTHETIST_16 $15. ; informat INTERV_ANAESTHETIST_17 $15. ; informat INTERV_ANAESTHETIST_18 $15. ; informat INTERV_ANAESTHETIST_19 $15. ; informat INTERV_ANAESTHETIST_20 $15. ; informat INTERV_ANAESTHETIC_TECH_01 $1.; informat INTERV_ANAESTHETIC_TECH_02 $1.; informat INTERV_ANAESTHETIC_TECH_03 $1.; informat INTERV_ANAESTHETIC_TECH_04 $1.; informat INTERV_ANAESTHETIC_TECH_05 $1.; informat INTERV_ANAESTHETIC_TECH_06 $1.; informat INTERV_ANAESTHETIC_TECH_07 $1. ; informat INTERV_ANAESTHETIC_TECH_08 $1. ; informat INTERV_ANAESTHETIC_TECH_09 $1. ; informat INTERV_ANAESTHETIC_TECH_10 $1. ; informat INTERV_ANAESTHETIC_TECH_11 $1. ; informat INTERV_ANAESTHETIC_TECH_12 $1. ; informat INTERV_ANAESTHETIC_TECH_13 $1. ; informat INTERV_ANAESTHETIC_TECH_14 $1. ; informat INTERV_ANAESTHETIC_TECH_15 $1. ; informat INTERV_ANAESTHETIC_TECH_16 $1. ; informat INTERV_ANAESTHETIC_TECH_17 $1. ; informat INTERV_ANAESTHETIC_TECH_18 $1. ; informat INTERV_ANAESTHETIC_TECH_19 $1. ; informat INTERV_ANAESTHETIC_TECH_20 $1. ; informat INTERV_OOH_IND_01 $1. ; informat INTERV_OOH_IND_02 $1. ; informat INTERV_OOH_IND_03 $1. ; informat INTERV_OOH_IND_04 $1. ; informat INTERV_OOH_IND_05 $1. ; informat INTERV_OOH_IND_06 $1. ; informat INTERV_OOH_IND_07 $1. ; informat INTERV_OOH_IND_08 $1. ; informat INTERV_OOH_IND_09 $1. ; informat INTERV_OOH_IND_10 $1. ; informat INTERV_OOH_IND_11 $1. ; informat INTERV_OOH_IND_12 $1. ; informat INTERV_OOH_IND_13 $1. ; informat INTERV_OOH_IND_14 $1. ; informat INTERV_OOH_IND_15 $1. ; informat INTERV_OOH_IND_16 $1. ; informat INTERV_OOH_IND_17 $1. ; informat INTERV_OOH_IND_18 $1. ; informat INTERV_OOH_IND_19 $1. ; informat INTERV_OOH_IND_20 $1. ; informat INTERV_OOH_INST_NO_01 $5. ; informat INTERV_OOH_INST_NO_02 $5. ; informat INTERV_OOH_INST_NO_03 $5. ; informat INTERV_OOH_INST_NO_04 $5. ; informat INTERV_OOH_INST_NO_05 $5. ; informat INTERV_OOH_INST_NO_06 $5. ; informat INTERV_OOH_INST_NO_07 $5. ; informat INTERV_OOH_INST_NO_08 $5. ; informat INTERV_OOH_INST_NO_09 $5. ; informat INTERV_OOH_INST_NO_10 $5. ; informat INTERV_OOH_INST_NO_11 $5. ; informat INTERV_OOH_INST_NO_12 $5. ; informat INTERV_OOH_INST_NO_13 $5. ; informat INTERV_OOH_INST_NO_14 $5. ; informat INTERV_OOH_INST_NO_15 $5. ; informat INTERV_OOH_INST_NO_16 $5. ; informat INTERV_OOH_INST_NO_17 $5. ; informat INTERV_OOH_INST_NO_18 $5. ; informat INTERV_OOH_INST_NO_19 $5. ; informat INTERV_OOH_INST_NO_20 $5. ; informat INTERV_UNPLAN_RETURN_TO_OR_01 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_02 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_03 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_04 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_05 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_06 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_07 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_08 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_09 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_10 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_11 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_12 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_13 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_14 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_15 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_16 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_17 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_18 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_19 $1. ; informat INTERV_UNPLAN_RETURN_TO_OR_20 $1. ; informat INTERV_EPISODE_DURATION_01 best32.; informat INTERV_EPISODE_DURATION_02 best32.; informat INTERV_EPISODE_DURATION_03 best32.; informat INTERV_EPISODE_DURATION_04 best32.; informat INTERV_EPISODE_DURATION_05 best32.; informat INTERV_EPISODE_DURATION_06 best32.; informat INTERV_EPISODE_DURATION_07 best32.; informat INTERV_EPISODE_DURATION_08 best32.; informat INTERV_EPISODE_DURATION_09 best32.; informat INTERV_EPISODE_DURATION_10 best32.; informat INTERV_EPISODE_DURATION_11 best32.; informat INTERV_EPISODE_DURATION_12 best32.; informat INTERV_EPISODE_DURATION_13 best32.; informat INTERV_EPISODE_DURATION_14 best32.; informat INTERV_EPISODE_DURATION_15 best32.; informat INTERV_EPISODE_DURATION_16 best32.; informat INTERV_EPISODE_DURATION_17 best32.; informat INTERV_EPISODE_DURATION_18 best32.; informat INTERV_EPISODE_DURATION_19 best32.; informat INTERV_EPISODE_DURATION_20 best32.; informat PROJECT_NO_1 $3.; informat PROJECT_NO_2 $3. ; informat PROJECT_NO_3 $3. ; informat PROJECT_NO_4 $3. ; informat PROJECT_NO_5 $3. ; informat PROJECT_FIELDS_1 $24. ; informat PROJECT_FIELDS_2 $24. ; informat PROJECT_FIELDS_3 $13. ; informat PROJECT_FIELDS_4 $24. ; informat PROJECT_FIELDS_5 $24. ; informat PREVIOUS_TERM_DELIVERIES $2. ; informat PREVIOUS_PRE_TERM_DELIVERIES $2. ; informat PREVIOUS_SPONTANEOUS_ABORTIONS $2.; informat PREVIOUS_THERAPEUTIC_ABORTIONS $2.; informat PREVIOUS_LIVE_BIRTHS $2. ; informat GESTATION_WKS_AT_ADM best32. ; informat DELIVERY_TM DATETIME20. ; informat DATE_OF_LAST_MENSES DATETIME20. ; informat BREASTFEEDING_IND $1. ; informat GESTATION_WKS_AT_DELIVERY best32. ; informat GESTATION_WKS_AT_DISCH best32. ; informat PRE_DELIVERY_DAYS best32. ; informat SOURCE_OF_REFERRAL $1. ; informat METHOD_OF_ADM $1. ; informat CHANGE_IN_LEGAL_STAT_FROM_ADM $1. ; informat AWOL $1. ; informat SUICIDE $1. ; informat PREVIOUS_PSYCHIATRIC_ADM $1. ; informat REFERRED_TO $1. ; informat ECT_TREATMENT_IND $1. ; informat NUMBER_OF_ECT_TREATMENTS $2. ; informat EDUCATION $1. ; informat EMPLOYMENT_STATUS $1. ; informat FINANCIAL_SUPPORT $1. ; informat DEATH_IN_SPECIAL_CARE_IND $1. ; informat GLASGOW_COMA_SCALE $2. ; informat SPECIAL_CARE_UNIT_NO_1 $2. ; informat SPECIAL_CARE_UNIT_NO_2 $2. ; informat SPECIAL_CARE_UNIT_NO_3 $2. ; informat SPECIAL_CARE_UNIT_NO_4 $2. ; informat SPECIAL_CARE_UNIT_NO_5 $2. ; informat SPECIAL_CARE_UNIT_NO_6 $2. ; informat SPECIAL_CARE_ADMIT_DT_1 DATETIME20. ; informat SPECIAL_CARE_ADMIT_DT_2 DATETIME20. ; informat SPECIAL_CARE_ADMIT_DT_3 DATETIME20. ; informat SPECIAL_CARE_ADMIT_DT_4 DATETIME20. ; informat SPECIAL_CARE_ADMIT_DT_5 DATETIME20. ; informat SPECIAL_CARE_ADMIT_DT_6 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_1 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_2 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_3 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_4 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_5 DATETIME20. ; informat SPECIAL_CARE_ADMIT_TM_6 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_1 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_2 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_3 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_4 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_5 DATETIME20. ; informat SPECIAL_CARE_DISCH_DT_6 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_1 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_2 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_3 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_4 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_5 DATETIME20. ; informat SPECIAL_CARE_DISCH_TM_6 DATETIME20. ; informat SPECIAL_CARE_HOURS_1 best32. ; informat SPECIAL_CARE_HOURS_2 best32. ; informat SPECIAL_CARE_HOURS_3 best32. ; informat SPECIAL_CARE_HOURS_4 best32. ; informat SPECIAL_CARE_HOURS_5 best32. ; informat SPECIAL_CARE_HOURS_6 best32. ; informat VENDOR_ID_FOR_ABSTRACTING $5. ; informat VENDOR_ID_FOR_GROUPING $5. ; informat TOTAL_LENGTH_OF_STAY best32. ; informat ACUTE_LENGTH_OF_STAY best32. ; informat ALC_LENGTH_OF_STAY best32. ; informat PROVIDER_TYPE_1 $1. ; informat PROVIDER_TYPE_2 $1. ; informat PROVIDER_TYPE_3 $1. ; informat PROVIDER_TYPE_4 $1. ; informat PROVIDER_TYPE_5 $1. ; informat PROVIDER_TYPE_6 $1. ; informat PROVIDER_TYPE_7 $1. ; informat PROVIDER_TYPE_8 $1. ; informat PROVIDER_NO_1 $15. ; informat PROVIDER_NO_2 $15. ; informat PROVIDER_NO_3 $15. ; informat PROVIDER_NO_4 $15. ; informat PROVIDER_NO_5 $15. ; informat PROVIDER_NO_6 $15. ; informat PROVIDER_NO_7 $15. ; informat PROVIDER_NO_8 $15. ; informat PROVIDER_SERVICE_1 $5. ; informat PROVIDER_SERVICE_2 $5. ; informat PROVIDER_SERVICE_3 $5. ; informat PROVIDER_SERVICE_4 $5. ; informat PROVIDER_SERVICE_5 $5. ; informat PROVIDER_SERVICE_6 $5. ; informat PROVIDER_SERVICE_7 $5. ; informat PROVIDER_SERVICE_8 $5. ; informat VENDOR_MCC $2.; informat VENDOR_CMG $3. ; informat VEDNOR_CMG_AGE_CATEGORY $1. ; informat VENDOR_COMORBIDITY_LEVEL $1. ; informat VENDOR_FLAGGED_INTERV_STATUS $1.; informat VENDOR_INTERV_EVENT_COUNT $1.; informat VENDOR_INTERV_OOH_COUNT $1. ; informat VENDOR_INP_RIW_ATYPICAL_CODE $2. ; informat VENDOR_ELOS_DAYS best32. ; informat VENDOR_INP_RI_LEVEL $1. ; informat VENDOR_CASE_WEIGHT best32. ; informat VENDOR_MAC_CODE $2. ; informat VENDOR_CACS_CODE $4. ; informat VENDOR_CACS_RIW best32. ; informat VENDOR_CACS_AGE_CATEGORY $1. ; informat VENDOR_CACS_ANESTH_CODE $1. ; informat VENDOR_CACS_IN_TECH_TOTAL_CNT $2. ; informat METHODOLOGY_YEAR $4. ; informat METHODOLOGY_VERSION $11. ; informat MCC $2. ; informat CMG $3. ; informat CMG_RETURN_CODE best32. ; informat MCC_PARTITION $1. ; informat COMORBIDITY_LEVEL $1. ; informat COMORBIDITY_TOTAL_FACTOR $9. ; informat CMG_AGE_CATEGORY $1. ; informat FLAGGED_INTERV_STATUS $1. ; informat INTERV_EVENT_COUNT $1. ; informat INTERV_OOH_COUNT $1. ; informat CMG_INTERV $10. ; informat CMG_INTERV_STATUS $2. ; informat CMG_INTERV_LOC $2. ; informat CMG_INTERV_EXTENT $2. ; informat CMG_INTERV_EPISODE $2. ; informat DIAG_USED_FOR_CMG_ASSIGNMENT $7. ; informat INP_RIW best32. ; informat ELOS_DAYS best32. ; informat ELOS_RIW_RETURN_CODE $2. ; informat INP_RIW_ATYPICAL_CODE $2. ; informat INP_RI_LEVEL $1. ; informat INP_RI_TOTAL_FACTOR best32. ; informat COMORBIDITY_COUNT_CODE $1. ; informat TRIM_DAYS best32. ; informat CARDIOVERSION_FLAG best32. ; informat CELL_SAVER_FLAG $1. ; informat CHEMOTHERAPY_FLAG $1. ; informat DIALYSIS_FLAG $1. ; informat HEART_RESUSCITATION_FLAG $1. ; informat MECH_VENT_GE_96_HOURS_FLAG $1. ; informat MECH_VENT_LT_96_HOURS_FLAG $1. ; informat FEEDING_TUBE_FLAG $1. ; informat PARACENTESIS_FLAG $1. ; informat PARENTERAL_NUTRITION_FLAG $1. ; informat PLEUROCENTESIS_FLAG $1. ; informat RADIOTHERAPY_FLAG $1. ; informat TRACHEOSTOMY_FLAG $1. ; informat VASCULAR_ACCESS_DEVICE_FLAG $1. ; informat BIOPSY_FLAG $1. ; informat ENDOSCOPY_FLAG $1. ; informat ECMO_FLAG $1. ; informat FLAGGED_INTERV_18 $1. ; informat FLAGGED_INTERV_19 $1. ; informat FLAGGED_INTERV_20 $1. ; informat CACS_METHODOLOGY_YEAR best32. ; informat CACS_METHODOLOGY_VERSION best32. ; informat MAC_CODE best32. ; informat CACS_CODE $4. ; informat CACS_RIW best32. ; informat CACS_INTERVENTION $7. ; informat CACS_INTERVENTION_STATUS $1. ; informat CSCS_INTERVENTION_LOCATION $1. ; informat CSCS_INTERVENTION_EXTENT $1. ; informat CSCS_PARTITION_CODE $1. ; informat CSCS_BRANCH_CODE $3. ; informat CSCS_LOGIC_TYPE_CODE $1. ; informat CSCS_AGE_CATEGORY_CODE $1. ; informat CSCS_ANESTHETIC_CODE $1. ; informat CSCS_IT_TOTAL_COUNT $2. ; informat CSCS_RETURN_CODE $2. ; informat CSCS_RIW_RETURN_CODE $2. ; informat CSCS_AGE_CATEGORY_RETURN $2. ; informat CSCS_ANESTHETIC_RETURN_CODE $2.; informat CSCS_IT_RETURN_CODE $2. ; informat CSCS_IT_CATEGORY_CODE_01 $2. ; informat CSCS_IT_CATEGORY_CODE_02 $2. ; informat CSCS_IT_CATEGORY_CODE_03 $2. ; informat CSCS_IT_CATEGORY_CODE_04 $2. ; informat CSCS_IT_CATEGORY_CODE_05 $2. ; informat CSCS_IT_CATEGORY_CODE_06 $2. ; informat CSCS_IT_CATEGORY_CODE_07 $2. ; informat CSCS_IT_CATEGORY_CODE_08 $2. ; informat CSCS_IT_CATEGORY_CODE_09 $2. ; informat CSCS_IT_CATEGORY_CODE_10 $2. ; informat CSCS_IT_CATEGORY_COUNT_01 $2. ; informat CSCS_IT_CATEGORY_COUNT_02 $2. ; informat CSCS_IT_CATEGORY_COUNT_03 $2. ; informat CSCS_IT_CATEGORY_COUNT_04 $2. ; informat CSCS_IT_CATEGORY_COUNT_05 $2. ; informat CSCS_IT_CATEGORY_COUNT_06 $2. ; informat CSCS_IT_CATEGORY_COUNT_07 $2. ; informat CSCS_IT_CATEGORY_COUNT_08 $2. ; informat CSCS_IT_CATEGORY_COUNT_09 $2. ; informat CSCS_IT_CATEGORY_COUNT_10 $2. ; informat BIRTHDATE_ESTIMATE_INDICATOR $3. ; informat HIG_CODE $4. ; informat HIG_ATYPICAL_CODE $2. ; informat HIG_WEIGHT best32. ; informat HIG_ELOS_DAYS best32. ; informat HIG_AGE_CATEGORY $1. ; informat HIG_FI_TOTAL_COUNT best32. ; informat HIG_OOH_FLAG $1. ; informat HIG_SCU_FLAG $1. ; informat HIG_HOMECARE_FLAG $1. ; informat HIG_LS_TRIM_DAYS best32. ; informat HIG_SS_TRIM_DAYS $2. ; informat HIG_MATERNAL_AGE_FLAG $1. ; informat HIG_RETURN_CODE $2. ; informat HIG_ELOS_WEIGHT_RETURN_CODE $2.; informat PROV_REGION_CODE $4. ; informat PROV_REGION_DESC $100. ; informat PROJECT_NO_6 $3. ; informat PROJECT_NO_7 $3. ; informat PROJECT_NO_8 $3. ; informat PROJECT_NO_9 $3. ; informat PROJECT_NO_10 $3. ; informat PROJECT_NO_11 $3. ; informat PROJECT_NO_12 $3. ; informat PROJECT_NO_13 $3. ; informat PROJECT_NO_14 $3. ; informat PROJECT_NO_15 $3. ; informat PROJECT_NO_16 $3. ; informat PROJECT_NO_17 $3. ; informat PROJECT_NO_18 $3. ; informat PROJECT_NO_19 $3. ; informat PROJECT_NO_20 $3. ; informat PROJECT_NO_21 $3. ; informat PROJECT_NO_22 $3. ; informat PROJECT_NO_23 $3. ; informat PROJECT_NO_24 $3. ; informat PROJECT_NO_25 $3. ; informat PROJECT_FIELDS_6 $24. ; informat PROJECT_FIELDS_7 $24. ; informat PROJECT_FIELDS_8 $24. ; informat PROJECT_FIELDS_9 $24. ; informat PROJECT_FIELDS_10 $24. ; informat PROJECT_FIELDS_11 $24. ; informat PROJECT_FIELDS_12 $24. ; informat PROJECT_FIELDS_13 $24. ; informat PROJECT_FIELDS_14 $24. ; informat PROJECT_FIELDS_15 $24. ; informat PROJECT_FIELDS_16 $24. ; informat PROJECT_FIELDS_17 $24. ; informat PROJECT_FIELDS_18 $24. ; informat PROJECT_FIELDS_19 $24. ; informat PROJECT_FIELDS_20 $24. ; informat PROJECT_FIELDS_21 $24. ; informat PROJECT_FIELDS_22 $24. ; informat PROJECT_FIELDS_23 $24. ; informat PROJECT_FIELDS_24 $24. ; informat PROJECT_FIELDS_25 $24. ; informat TOTAL_SPECIAL_CARE_HOURS best32. ; informat MEDICAL_CMG $3. ; informat TYPICAL_INPATIENT_RIW $9. ; informat HIG_PER_DIEM_FACTOR $9. ; informat HCN_INDEX $1. ; informat AGE best32. ; informat FACILITY_NO best32. ; informat SITE_LHIN $2. ; informat RESCODE $4. ; informat PATIENT_LHIN $2. ; informat MCC_2018 $2. ; informat CMG_2018 $3. ; informat INP_RIW_ATYPICAL_CODE_2018 $2.; informat INP_RIW_2018 best32. ; informat INST_NAME $80. ; informat INST_ACUTE $1. ; informat DIAG_CODE_01_LABEL $255. ; informat HIG_CODE_LABEL $100. ; informat FACILITY_NAME $65. ; informat FACILITY_LHIN $2. ; informat CMG_LABEL $100. ; informat LEGAL_STATUS_UPON_ARRIVAL_ED $1. ; informat LEGAL_STATUS_AT_ADMISSION $1. ; informat TYPE_OF_RESTRAINT_1 $1. ; informat FREQUENCY_OF_RESTRAINT_USE_1 $1. ; informat TYPE_OF_RESTRAINT_2 $1. ; informat FREQUENCY_OF_RESTRAINT_USE_2 $1. ; informat TYPE_OF_RESTRAINT_3 $1. ; informat FREQUENCY_OF_RESTRAINT_USE_3 $1. ; informat TYPE_OF_RESTRAINT_4 $1. ; informat FREQUENCY_OF_RESTRAINT_USE_4 $1. ; informat CRYOPRECIPITATE_PLASMA $1. ; informat CRYOSUPERNATANT_PLASMA $1. ; informat INTRAVEN_SUBCUT_IMM_GLOBULIN $1. ; informat FIBRINOGEN $1. ; informat PROTHROMBIN_CPX_CONCENT_PCC $1. ; informat ANTI_INHIBIT_COAGULANT_FEIBA $1. ; informat ANTITHROMBIN_III $1. ; informat C1_INHIBITOR $1. ; informat PROTEIN_OTHER_FACTORS $1. ; informat HEIGHT $1. ; informat WEIGHT_KG best32. ; informat hcn_encrypted_DAR $10. ; FORMAT ADM_DT DATETIME20. ; FORMAT ADM_TM DATETIME20. ; FORMAT PATIENT_LEFT_ED_DT DATETIME20. ; FORMAT PATIENT_LEFT_ED_TM DATETIME20. ; FORMAT DISCH_DT DATETIME20. ; FORMAT DISCH_TM DATETIME20. ; FORMAT LAST_ACTIVITY_DT DATETIME20. ; FORMAT INTERV_EPISODE_START_DT: DATETIME20. ; FORMAT INTERV_EPISODE_START_TM: DATETIME20. ; FORMAT INTERV_EPISODE_END_DT: DATETIME20. ; FORMAT INTERV_EPISODE_END_TM: DATETIME20. ; FORMAT SPECIAL_CARE_ADMIT_TM: DATETIME20. ; FORMAT SPECIAL_CARE_DISCH_DT: DATETIME20. ; input CIHI_KEY $ INST_NO $ CHECK_DIGIT $ RECORD_ID $ RECORD_NO $ CODER_ID $ PROVINCE_ISSUING_HCN $ RESPONSIBILITY_FOR_PAYMENT $ PROVINCIAL_ANCILLARY_DATA $ POSTAL_CODE $ RESIDENCE_CODE $ AGE_CODE $ AGE_UNITS $ GENDER $ ADM_DT ADM_TM INST_FROM_TYPE $ INST_FROM_NO ADM_CATEGORY $ READM_CODE $ AMBULANCE_CODE $ ENTRY_CODE $ PATIENT_LEFT_ED_DT PATIENT_LEFT_ED_TM WAIT_TM_IN_ED DISCH_DT DISCH_TM INST_TO_TYPE $ INST_TO_NO $ DISCH_DISPOSITION $ MAIN_PATIENT_SERVICE $ MAIN_PATIENT_SUB_SERVICE $ BLOOD_TRANS_NOT_RECEIVED_IND $ BLOOD_TRANSFUSION_IND $ RED_BLOOD_CELL_IND $ PLATELETS_IND $ PLASMA_IND $ ALBUMIN_IND $ OTHER_BLOOD_COMPONENT_IND $ AUTOTRASFUSION_IND $ BASIC_OPTION_01 $ BASIC_OPTION_02 $ BASIC_OPTION_03 $ BASIC_OPTION_04 $ BASIC_OPTION_05 $ BASIC_OPTION_06 $ BASIC_OPTION_07 $ BASIC_OPTION_08 $ BASIC_OPTION_09 $ BASIC_OPTION_10 $ BASIC_OPTION_11 $ BASIC_OPTION_12 $ BASIC_OPTION_13 $ BASIC_OPTION_14 $ BASIC_OPTION_15 $ BASIC_OPTION_16 $ BASIC_OPTION_17 $ BASIC_OPTION_18 $ BASIC_OPTION_19 $ WEIGHT_IN_GRAMS AGE_GROUP $ CODING_CLASSIFICATION_IND $ INST_TYPE $ ANALYTICAL_INST_TYPE $ ABSTRACT_OVERFLOW $ FIRST_SPECIAL_CARE_UNIT_NO $ LAST_ACTIVITY_DT SERVICE_TRANSFER_SERVICE_1 $ SERVICE_TRANSFER_SERVICE_2 $ SERVICE_TRANSFER_SERVICE_3 $ SERVICE_TRANSFER_SUB_SERVICE_1 $ SERVICE_TRANSFER_SUB_SERVICE_2 $ SERVICE_TRANSFER_SUB_SERVICE_3 $ SERVICE_TRANSFER_DAYS_1 $ SERVICE_TRANSFER_DAYS_2 $ SERVICE_TRANSFER_DAYS_3 $ CA_STAGING_CLINICAL_TUMOUR $ CA_STAGING_CLINICAL_NODE $ CA_STAGING_CLINICAL_METASTASIS $ CA_STAGING_PATHO_TUMOUR $ CA_STAGING_PATHO_NODE $ CA_STAGING_PATHO_METASTASIS $ CA_STAGING_SUMMARY_STAGE $ DIAG_PREFIX_01 $ DIAG_PREFIX_02 $ DIAG_PREFIX_03 $ DIAG_PREFIX_04 $ DIAG_PREFIX_05 $ DIAG_PREFIX_06 $ DIAG_PREFIX_07 $ DIAG_PREFIX_08 $ DIAG_PREFIX_09 $ DIAG_PREFIX_10 $ DIAG_PREFIX_11 $ DIAG_PREFIX_12 $ DIAG_PREFIX_13 $ DIAG_PREFIX_14 $ DIAG_PREFIX_15 $ DIAG_PREFIX_16 $ DIAG_PREFIX_17 $ DIAG_PREFIX_18 $ DIAG_PREFIX_19 $ DIAG_PREFIX_20 $ DIAG_PREFIX_21 $ DIAG_PREFIX_22 $ DIAG_PREFIX_23 $ DIAG_PREFIX_24 $ DIAG_PREFIX_25 $ DIAG_CODE_01 $ DIAG_CODE_02 $ DIAG_CODE_03 $ DIAG_CODE_04 $ DIAG_CODE_05 $ DIAG_CODE_06 $ DIAG_CODE_07 $ DIAG_CODE_08 $ DIAG_CODE_09 $ DIAG_CODE_10 $ DIAG_CODE_11 $ DIAG_CODE_12 $ DIAG_CODE_13 $ DIAG_CODE_14 $ DIAG_CODE_15 $ DIAG_CODE_16 $ DIAG_CODE_17 $ DIAG_CODE_18 $ DIAG_CODE_19 $ DIAG_CODE_20 $ DIAG_CODE_21 $ DIAG_CODE_22 $ DIAG_CODE_23 $ DIAG_CODE_24 $ DIAG_CODE_25 $ DIAG_TYPE_01 $ DIAG_TYPE_02 $ DIAG_TYPE_03 $ DIAG_TYPE_04 $ DIAG_TYPE_05 $ DIAG_TYPE_06 $ DIAG_TYPE_07 $ DIAG_TYPE_08 $ DIAG_TYPE_09 $ DIAG_TYPE_10 $ DIAG_TYPE_11 $ DIAG_TYPE_12 $ DIAG_TYPE_13 $ DIAG_TYPE_14 $ DIAG_TYPE_15 $ DIAG_TYPE_16 $ DIAG_TYPE_17 $ DIAG_TYPE_18 $ DIAG_TYPE_19 $ DIAG_TYPE_20 $ DIAG_TYPE_21 $ DIAG_TYPE_22 $ DIAG_TYPE_23 $ DIAG_TYPE_24 $ DIAG_TYPE_25 $ DIAG_CLUSTER_01 $ DIAG_CLUSTER_02 $ DIAG_CLUSTER_03 $ DIAG_CLUSTER_04 $ DIAG_CLUSTER_05 $ DIAG_CLUSTER_06 $ DIAG_CLUSTER_07 $ DIAG_CLUSTER_08 $ DIAG_CLUSTER_09 $ DIAG_CLUSTER_10 $ DIAG_CLUSTER_11 $ DIAG_CLUSTER_12 $ DIAG_CLUSTER_13 $ DIAG_CLUSTER_14 $ DIAG_CLUSTER_15 $ DIAG_CLUSTER_16 $ DIAG_CLUSTER_17 $ DIAG_CLUSTER_18 $ DIAG_CLUSTER_19 $ DIAG_CLUSTER_20 $ DIAG_CLUSTER_21 $ DIAG_CLUSTER_22 $ DIAG_CLUSTER_23 $ DIAG_CLUSTER_24 $ DIAG_CLUSTER_25 $ DIED_DURING_INTERVENTION $ INTERV_EPISODE_NUMBER_01 $ INTERV_EPISODE_NUMBER_02 $ INTERV_EPISODE_NUMBER_03 $ INTERV_EPISODE_NUMBER_04 $ INTERV_EPISODE_NUMBER_05 $ INTERV_EPISODE_NUMBER_06 $ INTERV_EPISODE_NUMBER_07 $ INTERV_EPISODE_NUMBER_08 $ INTERV_EPISODE_NUMBER_09 $ INTERV_EPISODE_NUMBER_10 $ INTERV_EPISODE_NUMBER_11 $ INTERV_EPISODE_NUMBER_12 $ INTERV_EPISODE_NUMBER_13 $ INTERV_EPISODE_NUMBER_14 $ INTERV_EPISODE_NUMBER_15 $ INTERV_EPISODE_NUMBER_16 $ INTERV_EPISODE_NUMBER_17 $ INTERV_EPISODE_NUMBER_18 $ INTERV_EPISODE_NUMBER_19 $ INTERV_EPISODE_NUMBER_20 $ INTERV_INTV_IN_EPIS_NUM_01 $ INTERV_INTV_IN_EPIS_NUM_02 $ INTERV_INTV_IN_EPIS_NUM_03 $ INTERV_INTV_IN_EPIS_NUM_04 $ INTERV_INTV_IN_EPIS_NUM_05 $ INTERV_INTV_IN_EPIS_NUM_06 $ INTERV_INTV_IN_EPIS_NUM_07 $ INTERV_INTV_IN_EPIS_NUM_08 $ INTERV_INTV_IN_EPIS_NUM_09 $ INTERV_INTV_IN_EPIS_NUM_10 $ INTERV_INTV_IN_EPIS_NUM_11 $ INTERV_INTV_IN_EPIS_NUM_12 $ INTERV_INTV_IN_EPIS_NUM_13 $ INTERV_INTV_IN_EPIS_NUM_14 $ INTERV_INTV_IN_EPIS_NUM_15 $ INTERV_INTV_IN_EPIS_NUM_16 $ INTERV_INTV_IN_EPIS_NUM_17 $ INTERV_INTV_IN_EPIS_NUM_18 $ INTERV_INTV_IN_EPIS_NUM_19 $ INTERV_INTV_IN_EPIS_NUM_20 $ INTERV_EPISODE_START_DT_01 INTERV_EPISODE_START_DT_02 INTERV_EPISODE_START_DT_03 INTERV_EPISODE_START_DT_04 INTERV_EPISODE_START_DT_05 INTERV_EPISODE_START_DT_06 INTERV_EPISODE_START_DT_07 INTERV_EPISODE_START_DT_08 INTERV_EPISODE_START_DT_09 INTERV_EPISODE_START_DT_10 INTERV_EPISODE_START_DT_11 INTERV_EPISODE_START_DT_12 INTERV_EPISODE_START_DT_13 INTERV_EPISODE_START_DT_14 INTERV_EPISODE_START_DT_15 INTERV_EPISODE_START_DT_16 INTERV_EPISODE_START_DT_17 INTERV_EPISODE_START_DT_18 INTERV_EPISODE_START_DT_19 INTERV_EPISODE_START_DT_20 INTERV_EPISODE_START_TM_01 INTERV_EPISODE_START_TM_02 INTERV_EPISODE_START_TM_03 INTERV_EPISODE_START_TM_04 INTERV_EPISODE_START_TM_05 INTERV_EPISODE_START_TM_06 INTERV_EPISODE_START_TM_07 INTERV_EPISODE_START_TM_08 INTERV_EPISODE_START_TM_09 INTERV_EPISODE_START_TM_10 INTERV_EPISODE_START_TM_11 INTERV_EPISODE_START_TM_12 INTERV_EPISODE_START_TM_13 INTERV_EPISODE_START_TM_14 INTERV_EPISODE_START_TM_15 INTERV_EPISODE_START_TM_16 INTERV_EPISODE_START_TM_17 INTERV_EPISODE_START_TM_18 INTERV_EPISODE_START_TM_19 INTERV_EPISODE_START_TM_20 INTERV_EPISODE_END_DT_01 INTERV_EPISODE_END_DT_02 INTERV_EPISODE_END_DT_03 INTERV_EPISODE_END_DT_04 INTERV_EPISODE_END_DT_05 INTERV_EPISODE_END_DT_06 INTERV_EPISODE_END_DT_07 INTERV_EPISODE_END_DT_08 INTERV_EPISODE_END_DT_09 INTERV_EPISODE_END_DT_10 INTERV_EPISODE_END_DT_11 INTERV_EPISODE_END_DT_12 INTERV_EPISODE_END_DT_13 INTERV_EPISODE_END_DT_14 INTERV_EPISODE_END_DT_15 INTERV_EPISODE_END_DT_16 INTERV_EPISODE_END_DT_17 INTERV_EPISODE_END_DT_18 INTERV_EPISODE_END_DT_19 INTERV_EPISODE_END_DT_20 INTERV_EPISODE_END_TM_01 INTERV_EPISODE_END_TM_02 INTERV_EPISODE_END_TM_03 INTERV_EPISODE_END_TM_04 INTERV_EPISODE_END_TM_05 INTERV_EPISODE_END_TM_06 INTERV_EPISODE_END_TM_07 INTERV_EPISODE_END_TM_08 INTERV_EPISODE_END_TM_09 INTERV_EPISODE_END_TM_10 INTERV_EPISODE_END_TM_11 INTERV_EPISODE_END_TM_12 INTERV_EPISODE_END_TM_13 INTERV_EPISODE_END_TM_14 INTERV_EPISODE_END_TM_15 INTERV_EPISODE_END_TM_16 INTERV_EPISODE_END_TM_17 INTERV_EPISODE_END_TM_18 INTERV_EPISODE_END_TM_19 INTERV_EPISODE_END_TM_20 INTERV_BEGUN_PRE_ADMIT_FLAG_01 $ INTERV_BEGUN_PRE_ADMIT_FLAG_02 $ INTERV_BEGUN_PRE_ADMIT_FLAG_03 $ INTERV_BEGUN_PRE_ADMIT_FLAG_04 $ INTERV_BEGUN_PRE_ADMIT_FLAG_05 $ INTERV_BEGUN_PRE_ADMIT_FLAG_06 $ INTERV_BEGUN_PRE_ADMIT_FLAG_07 $ INTERV_BEGUN_PRE_ADMIT_FLAG_08 $ INTERV_BEGUN_PRE_ADMIT_FLAG_09 $ INTERV_BEGUN_PRE_ADMIT_FLAG_10 $ INTERV_BEGUN_PRE_ADMIT_FLAG_11 $ INTERV_BEGUN_PRE_ADMIT_FLAG_12 $ INTERV_BEGUN_PRE_ADMIT_FLAG_13 $ INTERV_BEGUN_PRE_ADMIT_FLAG_14 $ INTERV_BEGUN_PRE_ADMIT_FLAG_15 $ INTERV_BEGUN_PRE_ADMIT_FLAG_16 $ INTERV_BEGUN_PRE_ADMIT_FLAG_17 $ INTERV_BEGUN_PRE_ADMIT_FLAG_18 $ INTERV_BEGUN_PRE_ADMIT_FLAG_19 $ INTERV_BEGUN_PRE_ADMIT_FLAG_20 $ INTERV_CODE_01 $ INTERV_CODE_02 $ INTERV_CODE_03 $ INTERV_CODE_04 $ INTERV_CODE_05 $ INTERV_CODE_06 $ INTERV_CODE_07 $ INTERV_CODE_08 $ INTERV_CODE_09 $ INTERV_CODE_10 $ INTERV_CODE_11 $ INTERV_CODE_12 $ INTERV_CODE_13 $ INTERV_CODE_14 $ INTERV_CODE_15 $ INTERV_CODE_16 $ INTERV_CODE_17 $ INTERV_CODE_18 $ INTERV_CODE_19 $ INTERV_CODE_20 $ INTERV_STATUS_ATTRIB_01 $ INTERV_STATUS_ATTRIB_02 $ INTERV_STATUS_ATTRIB_03 $ INTERV_STATUS_ATTRIB_04 $ INTERV_STATUS_ATTRIB_05 $ INTERV_STATUS_ATTRIB_06 $ INTERV_STATUS_ATTRIB_07 $ INTERV_STATUS_ATTRIB_08 $ INTERV_STATUS_ATTRIB_09 $ INTERV_STATUS_ATTRIB_10 $ INTERV_STATUS_ATTRIB_11 $ INTERV_STATUS_ATTRIB_12 $ INTERV_STATUS_ATTRIB_13 $ INTERV_STATUS_ATTRIB_14 $ INTERV_STATUS_ATTRIB_15 $ INTERV_STATUS_ATTRIB_16 $ INTERV_STATUS_ATTRIB_17 $ INTERV_STATUS_ATTRIB_18 $ INTERV_STATUS_ATTRIB_19 $ INTERV_STATUS_ATTRIB_20 $ INTERV_LOC_ATTRIB_01 $ INTERV_LOC_ATTRIB_02 $ INTERV_LOC_ATTRIB_03 $ INTERV_LOC_ATTRIB_04 $ INTERV_LOC_ATTRIB_05 $ INTERV_LOC_ATTRIB_06 $ INTERV_LOC_ATTRIB_07 $ INTERV_LOC_ATTRIB_08 $ INTERV_LOC_ATTRIB_09 $ INTERV_LOC_ATTRIB_10 $ INTERV_LOC_ATTRIB_11 $ INTERV_LOC_ATTRIB_12 $ INTERV_LOC_ATTRIB_13 $ INTERV_LOC_ATTRIB_14 $ INTERV_LOC_ATTRIB_15 $ INTERV_LOC_ATTRIB_16 $ INTERV_LOC_ATTRIB_17 $ INTERV_LOC_ATTRIB_18 $ INTERV_LOC_ATTRIB_19 $ INTERV_LOC_ATTRIB_20 $ INTERV_EXTENT_ATTRIB_01 $ INTERV_EXTENT_ATTRIB_02 $ INTERV_EXTENT_ATTRIB_03 $ INTERV_EXTENT_ATTRIB_04 $ INTERV_EXTENT_ATTRIB_05 $ INTERV_EXTENT_ATTRIB_06 $ INTERV_EXTENT_ATTRIB_07 $ INTERV_EXTENT_ATTRIB_08 $ INTERV_EXTENT_ATTRIB_09 $ INTERV_EXTENT_ATTRIB_10 $ INTERV_EXTENT_ATTRIB_11 $ INTERV_EXTENT_ATTRIB_12 $ INTERV_EXTENT_ATTRIB_13 $ INTERV_EXTENT_ATTRIB_14 $ INTERV_EXTENT_ATTRIB_15 $ INTERV_EXTENT_ATTRIB_16 $ INTERV_EXTENT_ATTRIB_17 $ INTERV_EXTENT_ATTRIB_18 $ INTERV_EXTENT_ATTRIB_19 $ INTERV_EXTENT_ATTRIB_20 $ INTERV_PROVIDER_NO_01 $ INTERV_PROVIDER_NO_02 $ INTERV_PROVIDER_NO_03 $ INTERV_PROVIDER_NO_04 $ INTERV_PROVIDER_NO_05 $ INTERV_PROVIDER_NO_06 $ INTERV_PROVIDER_NO_07 $ INTERV_PROVIDER_NO_08 $ INTERV_PROVIDER_NO_09 $ INTERV_PROVIDER_NO_10 $ INTERV_PROVIDER_NO_11 $ INTERV_PROVIDER_NO_12 $ INTERV_PROVIDER_NO_13 $ INTERV_PROVIDER_NO_14 $ INTERV_PROVIDER_NO_15 $ INTERV_PROVIDER_NO_16 $ INTERV_PROVIDER_NO_17 $ INTERV_PROVIDER_NO_18 $ INTERV_PROVIDER_NO_19 $ INTERV_PROVIDER_NO_20 $ INTERV_PROVIDER_SERVICE_01 $ INTERV_PROVIDER_SERVICE_02 $ INTERV_PROVIDER_SERVICE_03 $ INTERV_PROVIDER_SERVICE_04 $ INTERV_PROVIDER_SERVICE_05 $ INTERV_PROVIDER_SERVICE_06 $ INTERV_PROVIDER_SERVICE_07 $ INTERV_PROVIDER_SERVICE_08 $ INTERV_PROVIDER_SERVICE_09 $ INTERV_PROVIDER_SERVICE_10 $ INTERV_PROVIDER_SERVICE_11 $ INTERV_PROVIDER_SERVICE_12 $ INTERV_PROVIDER_SERVICE_13 $ INTERV_PROVIDER_SERVICE_14 $ INTERV_PROVIDER_SERVICE_15 $ INTERV_PROVIDER_SERVICE_16 $ INTERV_PROVIDER_SERVICE_17 $ INTERV_PROVIDER_SERVICE_18 $ INTERV_PROVIDER_SERVICE_19 $ INTERV_PROVIDER_SERVICE_20 $ INTERV_TISSUE_01 $ INTERV_TISSUE_02 $ INTERV_TISSUE_03 $ INTERV_TISSUE_04 $ INTERV_TISSUE_05 $ INTERV_TISSUE_06 $ INTERV_TISSUE_07 $ INTERV_TISSUE_08 $ INTERV_TISSUE_09 $ INTERV_TISSUE_10 $ INTERV_TISSUE_11 $ INTERV_TISSUE_12 $ INTERV_TISSUE_13 $ INTERV_TISSUE_14 $ INTERV_TISSUE_15 $ INTERV_TISSUE_16 $ INTERV_TISSUE_17 $ INTERV_TISSUE_18 $ INTERV_TISSUE_19 $ INTERV_TISSUE_20 $ INTERV_OR_LOC_01 $ INTERV_OR_LOC_02 $ INTERV_OR_LOC_03 $ INTERV_OR_LOC_04 $ INTERV_OR_LOC_05 $ INTERV_OR_LOC_06 $ INTERV_OR_LOC_07 $ INTERV_OR_LOC_08 $ INTERV_OR_LOC_09 $ INTERV_OR_LOC_10 $ INTERV_OR_LOC_11 $ INTERV_OR_LOC_12 $ INTERV_OR_LOC_13 $ INTERV_OR_LOC_14 $ INTERV_OR_LOC_15 $ INTERV_OR_LOC_16 $ INTERV_OR_LOC_17 $ INTERV_OR_LOC_18 $ INTERV_OR_LOC_19 $ INTERV_OR_LOC_20 $ INTERV_ANAESTHETIST_01 $ INTERV_ANAESTHETIST_02 $ INTERV_ANAESTHETIST_03 $ INTERV_ANAESTHETIST_04 $ INTERV_ANAESTHETIST_05 $ INTERV_ANAESTHETIST_06 $ INTERV_ANAESTHETIST_07 $ INTERV_ANAESTHETIST_08 $ INTERV_ANAESTHETIST_09 $ INTERV_ANAESTHETIST_10 $ INTERV_ANAESTHETIST_11 $ INTERV_ANAESTHETIST_12 $ INTERV_ANAESTHETIST_13 $ INTERV_ANAESTHETIST_14 $ INTERV_ANAESTHETIST_15 $ INTERV_ANAESTHETIST_16 $ INTERV_ANAESTHETIST_17 $ INTERV_ANAESTHETIST_18 $ INTERV_ANAESTHETIST_19 $ INTERV_ANAESTHETIST_20 $ INTERV_ANAESTHETIC_TECH_01 $ INTERV_ANAESTHETIC_TECH_02 $ INTERV_ANAESTHETIC_TECH_03 $ INTERV_ANAESTHETIC_TECH_04 $ INTERV_ANAESTHETIC_TECH_05 $ INTERV_ANAESTHETIC_TECH_06 $ INTERV_ANAESTHETIC_TECH_07 $ INTERV_ANAESTHETIC_TECH_08 $ INTERV_ANAESTHETIC_TECH_09 $ INTERV_ANAESTHETIC_TECH_10 $ INTERV_ANAESTHETIC_TECH_11 $ INTERV_ANAESTHETIC_TECH_12 $ INTERV_ANAESTHETIC_TECH_13 $ INTERV_ANAESTHETIC_TECH_14 $ INTERV_ANAESTHETIC_TECH_15 $ INTERV_ANAESTHETIC_TECH_16 $ INTERV_ANAESTHETIC_TECH_17 $ INTERV_ANAESTHETIC_TECH_18 $ INTERV_ANAESTHETIC_TECH_19 $ INTERV_ANAESTHETIC_TECH_20 $ INTERV_OOH_IND_01 $ INTERV_OOH_IND_02 $ INTERV_OOH_IND_03 $ INTERV_OOH_IND_04 $ INTERV_OOH_IND_05 $ INTERV_OOH_IND_06 $ INTERV_OOH_IND_07 $ INTERV_OOH_IND_08 $ INTERV_OOH_IND_09 $ INTERV_OOH_IND_10 $ INTERV_OOH_IND_11 $ INTERV_OOH_IND_12 $ INTERV_OOH_IND_13 $ INTERV_OOH_IND_14 $ INTERV_OOH_IND_15 $ INTERV_OOH_IND_16 $ INTERV_OOH_IND_17 $ INTERV_OOH_IND_18 $ INTERV_OOH_IND_19 $ INTERV_OOH_IND_20 $ INTERV_OOH_INST_NO_01 $ INTERV_OOH_INST_NO_02 $ INTERV_OOH_INST_NO_03 $ INTERV_OOH_INST_NO_04 $ INTERV_OOH_INST_NO_05 $ INTERV_OOH_INST_NO_06 $ INTERV_OOH_INST_NO_07 $ INTERV_OOH_INST_NO_08 $ INTERV_OOH_INST_NO_09 $ INTERV_OOH_INST_NO_10 $ INTERV_OOH_INST_NO_11 $ INTERV_OOH_INST_NO_12 $ INTERV_OOH_INST_NO_13 $ INTERV_OOH_INST_NO_14 $ INTERV_OOH_INST_NO_15 $ INTERV_OOH_INST_NO_16 $ INTERV_OOH_INST_NO_17 $ INTERV_OOH_INST_NO_18 $ INTERV_OOH_INST_NO_19 $ INTERV_OOH_INST_NO_20 $ INTERV_UNPLAN_RETURN_TO_OR_01 $ INTERV_UNPLAN_RETURN_TO_OR_02 $ INTERV_UNPLAN_RETURN_TO_OR_03 $ INTERV_UNPLAN_RETURN_TO_OR_04 $ INTERV_UNPLAN_RETURN_TO_OR_05 $ INTERV_UNPLAN_RETURN_TO_OR_06 $ INTERV_UNPLAN_RETURN_TO_OR_07 $ INTERV_UNPLAN_RETURN_TO_OR_08 $ INTERV_UNPLAN_RETURN_TO_OR_09 $ INTERV_UNPLAN_RETURN_TO_OR_10 $ INTERV_UNPLAN_RETURN_TO_OR_11 $ INTERV_UNPLAN_RETURN_TO_OR_12 $ INTERV_UNPLAN_RETURN_TO_OR_13 $ INTERV_UNPLAN_RETURN_TO_OR_14 $ INTERV_UNPLAN_RETURN_TO_OR_15 $ INTERV_UNPLAN_RETURN_TO_OR_16 $ INTERV_UNPLAN_RETURN_TO_OR_17 $ INTERV_UNPLAN_RETURN_TO_OR_18 $ INTERV_UNPLAN_RETURN_TO_OR_19 $ INTERV_UNPLAN_RETURN_TO_OR_20 $ INTERV_EPISODE_DURATION_01 $ INTERV_EPISODE_DURATION_02 $ INTERV_EPISODE_DURATION_03 $ INTERV_EPISODE_DURATION_04 $ INTERV_EPISODE_DURATION_05 $ INTERV_EPISODE_DURATION_06 $ INTERV_EPISODE_DURATION_07 $ INTERV_EPISODE_DURATION_08 $ INTERV_EPISODE_DURATION_09 $ INTERV_EPISODE_DURATION_10 $ INTERV_EPISODE_DURATION_11 $ INTERV_EPISODE_DURATION_12 $ INTERV_EPISODE_DURATION_13 $ INTERV_EPISODE_DURATION_14 $ INTERV_EPISODE_DURATION_15 $ INTERV_EPISODE_DURATION_16 $ INTERV_EPISODE_DURATION_17 $ INTERV_EPISODE_DURATION_18 $ INTERV_EPISODE_DURATION_19 $ INTERV_EPISODE_DURATION_20 $ PROJECT_NO_1 $ PROJECT_NO_2 $ PROJECT_NO_3 $ PROJECT_NO_4 $ PROJECT_NO_5 $ PROJECT_FIELDS_1 $ PROJECT_FIELDS_2 $ PROJECT_FIELDS_3 $ PROJECT_FIELDS_4 $ PROJECT_FIELDS_5 $ PREVIOUS_TERM_DELIVERIES $ PREVIOUS_PRE_TERM_DELIVERIES $ PREVIOUS_SPONTANEOUS_ABORTIONS $ PREVIOUS_THERAPEUTIC_ABORTIONS $ PREVIOUS_LIVE_BIRTHS $ GESTATION_WKS_AT_ADM DELIVERY_TM DATE_OF_LAST_MENSES BREASTFEEDING_IND $ GESTATION_WKS_AT_DELIVERY GESTATION_WKS_AT_DISCH PRE_DELIVERY_DAYS SOURCE_OF_REFERRAL $ METHOD_OF_ADM $ CHANGE_IN_LEGAL_STAT_FROM_ADM $ AWOL $ SUICIDE $ PREVIOUS_PSYCHIATRIC_ADM $ REFERRED_TO $ ECT_TREATMENT_IND $ NUMBER_OF_ECT_TREATMENTS $ EDUCATION $ EMPLOYMENT_STATUS $ FINANCIAL_SUPPORT $ DEATH_IN_SPECIAL_CARE_IND $ GLASGOW_COMA_SCALE $ SPECIAL_CARE_UNIT_NO_1 $ SPECIAL_CARE_UNIT_NO_2 $ SPECIAL_CARE_UNIT_NO_3 $ SPECIAL_CARE_UNIT_NO_4 $ SPECIAL_CARE_UNIT_NO_5 $ SPECIAL_CARE_UNIT_NO_6 $ SPECIAL_CARE_ADMIT_DT_1 SPECIAL_CARE_ADMIT_DT_2 SPECIAL_CARE_ADMIT_DT_3 SPECIAL_CARE_ADMIT_DT_4 SPECIAL_CARE_ADMIT_DT_5 SPECIAL_CARE_ADMIT_DT_6 SPECIAL_CARE_ADMIT_TM_1 SPECIAL_CARE_ADMIT_TM_2 SPECIAL_CARE_ADMIT_TM_3 SPECIAL_CARE_ADMIT_TM_4 SPECIAL_CARE_ADMIT_TM_5 SPECIAL_CARE_ADMIT_TM_6 SPECIAL_CARE_DISCH_DT_1 SPECIAL_CARE_DISCH_DT_2 SPECIAL_CARE_DISCH_DT_3 SPECIAL_CARE_DISCH_DT_4 SPECIAL_CARE_DISCH_DT_5 SPECIAL_CARE_DISCH_DT_6 SPECIAL_CARE_DISCH_TM_1 SPECIAL_CARE_DISCH_TM_2 SPECIAL_CARE_DISCH_TM_3 SPECIAL_CARE_DISCH_TM_4 SPECIAL_CARE_DISCH_TM_5 SPECIAL_CARE_DISCH_TM_6 SPECIAL_CARE_HOURS_1 SPECIAL_CARE_HOURS_2 SPECIAL_CARE_HOURS_3 SPECIAL_CARE_HOURS_4 SPECIAL_CARE_HOURS_5 SPECIAL_CARE_HOURS_6 VENDOR_ID_FOR_ABSTRACTING $ VENDOR_ID_FOR_GROUPING $ TOTAL_LENGTH_OF_STAY ACUTE_LENGTH_OF_STAY ALC_LENGTH_OF_STAY PROVIDER_TYPE_1 $ PROVIDER_TYPE_2 $ PROVIDER_TYPE_3 $ PROVIDER_TYPE_4 $ PROVIDER_TYPE_5 $ PROVIDER_TYPE_6 $ PROVIDER_TYPE_7 $ PROVIDER_TYPE_8 $ PROVIDER_NO_1 $ PROVIDER_NO_2 $ PROVIDER_NO_3 $ PROVIDER_NO_4 $ PROVIDER_NO_5 $ PROVIDER_NO_6 $ PROVIDER_NO_7 $ PROVIDER_NO_8 $ PROVIDER_SERVICE_1 $ PROVIDER_SERVICE_2 $ PROVIDER_SERVICE_3 $ PROVIDER_SERVICE_4 $ PROVIDER_SERVICE_5 $ PROVIDER_SERVICE_6 $ PROVIDER_SERVICE_7 $ PROVIDER_SERVICE_8 $ VENDOR_MCC VENDOR_CMG VEDNOR_CMG_AGE_CATEGORY $ VENDOR_COMORBIDITY_LEVEL VENDOR_FLAGGED_INTERV_STATUS VENDOR_INTERV_EVENT_COUNT VENDOR_INTERV_OOH_COUNT VENDOR_INP_RIW_ATYPICAL_CODE $ VENDOR_ELOS_DAYS VENDOR_INP_RI_LEVEL VENDOR_CASE_WEIGHT VENDOR_MAC_CODE $ VENDOR_CACS_CODE $ VENDOR_CACS_RIW VENDOR_CACS_AGE_CATEGORY $ VENDOR_CACS_ANESTH_CODE $ VENDOR_CACS_IN_TECH_TOTAL_CNT $ METHODOLOGY_YEAR METHODOLOGY_VERSION $ MCC CMG CMG_RETURN_CODE MCC_PARTITION $ COMORBIDITY_LEVEL COMORBIDITY_TOTAL_FACTOR CMG_AGE_CATEGORY $ FLAGGED_INTERV_STATUS INTERV_EVENT_COUNT INTERV_OOH_COUNT CMG_INTERV $ CMG_INTERV_STATUS $ CMG_INTERV_LOC $ CMG_INTERV_EXTENT $ CMG_INTERV_EPISODE DIAG_USED_FOR_CMG_ASSIGNMENT $ INP_RIW ELOS_DAYS ELOS_RIW_RETURN_CODE $ INP_RIW_ATYPICAL_CODE $ INP_RI_LEVEL INP_RI_TOTAL_FACTOR COMORBIDITY_COUNT_CODE TRIM_DAYS CARDIOVERSION_FLAG $ CELL_SAVER_FLAG $ CHEMOTHERAPY_FLAG $ DIALYSIS_FLAG $ HEART_RESUSCITATION_FLAG $ MECH_VENT_GE_96_HOURS_FLAG $ MECH_VENT_LT_96_HOURS_FLAG $ FEEDING_TUBE_FLAG $ PARACENTESIS_FLAG $ PARENTERAL_NUTRITION_FLAG $ PLEUROCENTESIS_FLAG $ RADIOTHERAPY_FLAG $ TRACHEOSTOMY_FLAG $ VASCULAR_ACCESS_DEVICE_FLAG $ BIOPSY_FLAG $ ENDOSCOPY_FLAG $ ECMO_FLAG $ FLAGGED_INTERV_18 $ FLAGGED_INTERV_19 $ FLAGGED_INTERV_20 $ CACS_METHODOLOGY_YEAR $ CACS_METHODOLOGY_VERSION $ MAC_CODE $ CACS_CODE $ CACS_RIW $ CACS_INTERVENTION $ CACS_INTERVENTION_STATUS $ CSCS_INTERVENTION_LOCATION $ CSCS_INTERVENTION_EXTENT $ CSCS_PARTITION_CODE $ CSCS_BRANCH_CODE $ CSCS_LOGIC_TYPE_CODE $ CSCS_AGE_CATEGORY_CODE $ CSCS_ANESTHETIC_CODE $ CSCS_IT_TOTAL_COUNT $ CSCS_RETURN_CODE $ CSCS_RIW_RETURN_CODE $ CSCS_AGE_CATEGORY_RETURN $ CSCS_ANESTHETIC_RETURN_CODE $ CSCS_IT_RETURN_CODE $ CSCS_IT_CATEGORY_CODE_01 $ CSCS_IT_CATEGORY_CODE_02 $ CSCS_IT_CATEGORY_CODE_03 $ CSCS_IT_CATEGORY_CODE_04 $ CSCS_IT_CATEGORY_CODE_05 $ CSCS_IT_CATEGORY_CODE_06 $ CSCS_IT_CATEGORY_CODE_07 $ CSCS_IT_CATEGORY_CODE_08 $ CSCS_IT_CATEGORY_CODE_09 $ CSCS_IT_CATEGORY_CODE_10 $ CSCS_IT_CATEGORY_COUNT_01 $ CSCS_IT_CATEGORY_COUNT_02 $ CSCS_IT_CATEGORY_COUNT_03 $ CSCS_IT_CATEGORY_COUNT_04 $ CSCS_IT_CATEGORY_COUNT_05 $ CSCS_IT_CATEGORY_COUNT_06 $ CSCS_IT_CATEGORY_COUNT_07 $ CSCS_IT_CATEGORY_COUNT_08 $ CSCS_IT_CATEGORY_COUNT_09 $ CSCS_IT_CATEGORY_COUNT_10 $ BIRTHDATE_ESTIMATE_INDICATOR $ HIG_CODE $ HIG_ATYPICAL_CODE $ HIG_WEIGHT HIG_ELOS_DAYS HIG_AGE_CATEGORY $ HIG_FI_TOTAL_COUNT $ HIG_OOH_FLAG $ HIG_SCU_FLAG $ HIG_HOMECARE_FLAG $ HIG_LS_TRIM_DAYS $ HIG_SS_TRIM_DAYS $ HIG_MATERNAL_AGE_FLAG $ HIG_RETURN_CODE $ HIG_ELOS_WEIGHT_RETURN_CODE $ PROV_REGION_CODE $ PROV_REGION_DESC $ PROJECT_NO_6 $ PROJECT_NO_7 $ PROJECT_NO_8 $ PROJECT_NO_9 $ PROJECT_NO_10 $ PROJECT_NO_11 $ PROJECT_NO_12 $ PROJECT_NO_13 $ PROJECT_NO_14 $ PROJECT_NO_15 $ PROJECT_NO_16 $ PROJECT_NO_17 $ PROJECT_NO_18 $ PROJECT_NO_19 $ PROJECT_NO_20 $ PROJECT_NO_21 $ PROJECT_NO_22 $ PROJECT_NO_23 $ PROJECT_NO_24 $ PROJECT_NO_25 $ PROJECT_FIELDS_6 $ PROJECT_FIELDS_7 $ PROJECT_FIELDS_8 $ PROJECT_FIELDS_9 $ PROJECT_FIELDS_10 $ PROJECT_FIELDS_11 $ PROJECT_FIELDS_12 $ PROJECT_FIELDS_13 $ PROJECT_FIELDS_14 $ PROJECT_FIELDS_15 $ PROJECT_FIELDS_16 $ PROJECT_FIELDS_17 $ PROJECT_FIELDS_18 $ PROJECT_FIELDS_19 $ PROJECT_FIELDS_20 $ PROJECT_FIELDS_21 $ PROJECT_FIELDS_22 $ PROJECT_FIELDS_23 $ PROJECT_FIELDS_24 $ PROJECT_FIELDS_25 $ TOTAL_SPECIAL_CARE_HOURS MEDICAL_CMG TYPICAL_INPATIENT_RIW HIG_PER_DIEM_FACTOR HCN_INDEX $ AGE FACILITY_NO $ SITE_LHIN $ RESCODE $ PATIENT_LHIN $ MCC_2018 $ CMG_2018 $ INP_RIW_ATYPICAL_CODE_2018 $ INP_RIW_2018 INST_NAME $ INST_ACUTE DIAG_CODE_01_LABEL $ HIG_CODE_LABEL $ FACILITY_NAME $ FACILITY_LHIN $ CMG_LABEL $ LEGAL_STATUS_UPON_ARRIVAL_ED $ LEGAL_STATUS_AT_ADMISSION $ TYPE_OF_RESTRAINT_1 $ FREQUENCY_OF_RESTRAINT_USE_1 $ TYPE_OF_RESTRAINT_2 $ FREQUENCY_OF_RESTRAINT_USE_2 $ TYPE_OF_RESTRAINT_3 $ FREQUENCY_OF_RESTRAINT_USE_3 $ TYPE_OF_RESTRAINT_4 $ FREQUENCY_OF_RESTRAINT_USE_4 $ CRYOPRECIPITATE_PLASMA $ CRYOSUPERNATANT_PLASMA $ INTRAVEN_SUBCUT_IMM_GLOBULIN $ FIBRINOGEN $ PROTHROMBIN_CPX_CONCENT_PCC $ ANTI_INHIBIT_COAGULANT_FEIBA $ ANTITHROMBIN_III $ C1_INHIBITOR $ PROTEIN_OTHER_FACTORS $ HEIGHT $ WEIGHT_KG hcn_encrypted_DAR $ ; if _ERROR_ then call symputx('_EFIERR_',1); run; ... View more

Hello  Would appreciate if someone can help me understand the code below There are 25 dx codes in the p970_138_dadsdsrecs database  Is the code below essentially creating 25 tables where dx10code1 to dx10code25 are not blank setting them together and finding the cases where the dx condition is found in the 25 codes (i.e. in the step bolded) Would this be equivalent to creating an array of the 25 codes and then finding those bolded dx codes?   proc sql; create table dad_dx_all1 as select id, key_enc, epi_enc, 1 as seq, dx10code1 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype1 as dx_type from idave.p970_138_dadsdsrecs where not dx10code1 is null ;quit; proc sql; create table dad_dx_all2 as select id, key_enc, epi_enc, 2 as seq, dx10code2 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype2 as dx_type from idave.p970_138_dadsdsrecs where not dx10code2 is null ;quit; proc sql; create table dad_dx_all3 as select id, key_enc, epi_enc, 3 as seq, dx10code3 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype3 as dx_type from idave.p970_138_dadsdsrecs where not dx10code3 is null ;quit; proc sql; create table dad_dx_all4 as select id, key_enc, epi_enc, 4 as seq, dx10code4 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype4 as dx_type from idave.p970_138_dadsdsrecs where not dx10code4 is null ;quit; proc sql; create table dad_dx_all5 as select id, key_enc, epi_enc, 5 as seq, dx10code5 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype5 as dx_type from idave.p970_138_dadsdsrecs where not dx10code5 is null ;quit; proc sql; create table dad_dx_all6 as select id, key_enc, epi_enc, 6 as seq, dx10code6 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype6 as dx_type from idave.p970_138_dadsdsrecs where not dx10code6 is null ;quit; proc sql; create table dad_dx_all7 as select id, key_enc, epi_enc, 7 as seq, dx10code7 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype7 as dx_type from idave.p970_138_dadsdsrecs where not dx10code7 is null ;quit; proc sql; create table dad_dx_all8 as select id, key_enc, epi_enc, 8 as seq, dx10code8 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype8 as dx_type from idave.p970_138_dadsdsrecs where not dx10code8 is null ;quit; proc sql; create table dad_dx_all9 as select id, key_enc, epi_enc, 9 as seq, dx10code9 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype9 as dx_type from idave.p970_138_dadsdsrecs where not dx10code9 is null ;quit; proc sql; create table dad_dx_all10 as select id, key_enc, epi_enc, 10 as seq, dx10code10 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype10 as dx_type from idave.p970_138_dadsdsrecs where not dx10code10 is null ;quit; proc sql; create table dad_dx_all11 as select id, key_enc, epi_enc, 11 as seq, dx10code11 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype11 as dx_type from idave.p970_138_dadsdsrecs where not dx10code11 is null ;quit; proc sql; create table dad_dx_all12 as select id, key_enc, epi_enc, 12 as seq, dx10code12 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype12 as dx_type from idave.p970_138_dadsdsrecs where not dx10code12 is null ;quit; proc sql; create table dad_dx_all13 as select id, key_enc, epi_enc, 13 as seq, dx10code13 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype13 as dx_type from idave.p970_138_dadsdsrecs where not dx10code13 is null ;quit; proc sql; create table dad_dx_all14 as select id, key_enc, epi_enc, 14 as seq, dx10code14 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype14 as dx_type from idave.p970_138_dadsdsrecs where not dx10code14 is null ;quit; proc sql; create table dad_dx_all15 as select id, key_enc, epi_enc, 15 as seq, dx10code15 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype15 as dx_type from idave.p970_138_dadsdsrecs where not dx10code15 is null ;quit; proc sql; create table dad_dx_all16 as select id, key_enc, epi_enc, 16 as seq, dx10code16 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype16 as dx_type from idave.p970_138_dadsdsrecs where not dx10code16 is null ;quit; proc sql; create table dad_dx_all17 as select id, key_enc, epi_enc, 17 as seq, dx10code17 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype17 as dx_type from idave.p970_138_dadsdsrecs where not dx10code17 is null ;quit; proc sql; create table dad_dx_all18 as select id, key_enc, epi_enc, 18 as seq, dx10code18 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype18 as dx_type from idave.p970_138_dadsdsrecs where not dx10code18 is null ;quit; proc sql; create table dad_dx_all19 as select id, key_enc, epi_enc, 19 as seq, dx10code19 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype19 as dx_type from idave.p970_138_dadsdsrecs where not dx10code19 is null ;quit; proc sql; create table dad_dx_all20 as select id, key_enc, epi_enc, 20 as seq, dx10code20 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype20 as dx_type from idave.p970_138_dadsdsrecs where not dx10code20 is null ;quit; proc sql; create table dad_dx_all21 as select id, key_enc, epi_enc, 21 as seq, dx10code21 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype21 as dx_type from idave.p970_138_dadsdsrecs where not dx10code21 is null ;quit; proc sql; create table dad_dx_all22 as select id, key_enc, epi_enc, 22 as seq, dx10code22 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype22 as dx_type from idave.p970_138_dadsdsrecs where not dx10code22 is null ;quit; proc sql; create table dad_dx_all23 as select id, key_enc, epi_enc, 23 as seq, dx10code23 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype23 as dx_type from idave.p970_138_dadsdsrecs where not dx10code23 is null ;quit; proc sql; create table dad_dx_all24 as select id, key_enc, epi_enc, 24 as seq, dx10code24 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype24 as dx_type from idave.p970_138_dadsdsrecs where not dx10code24 is null ;quit; proc sql; create table dad_dx_all25 as select id, key_enc, epi_enc, 25 as seq, dx10code25 as dx, case when source = 'I' then inst when source = 'S' then aminst end as site, source, dxtype25 as dx_type from idave.p970_138_dadsdsrecs where not dx10code25 is null ;quit; /*Combine all of the above tables into one*/ data pa.dad_dx_all; set dad_dx_all1 dad_dx_all2 dad_dx_all3 dad_dx_all4 dad_dx_all5 dad_dx_all6 dad_dx_all7 dad_dx_all8 dad_dx_all9 dad_dx_all10 dad_dx_all11 dad_dx_all12 dad_dx_all13 dad_dx_all14 dad_dx_all15 dad_dx_all16 dad_dx_all17 dad_dx_all18 dad_dx_all19 dad_dx_all20 dad_dx_all21 dad_dx_all22 dad_dx_all23 dad_dx_all24 dad_dx_all25; run;   proc sql; create table pa.non_stemi_ami_cihi as select distinct key_enc from pa.dad_dx_all where key_enc in (select key_enc from pa.dad_dx_all where dx in ('I210', 'I211', 'I212', 'I213', 'I214', 'I2140', 'I2141', 'I2142', 'I2149', 'I219', 'I220', 'I221', 'I228', 'I229', 'I240')) and key_enc in (select key_enc from pa.dad_dx_all where not dx in ('R9430')) ;quit; ... View more