importing csv file with data step code

[Ranjeeta]

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;

[AMSAS]

The error message indicates that the data in the external file doesn't match the format expected for those variables. For example ADM_DT is expecting a DATETIME value (e.g. 04APR2019 14:35) but when the input statement reads line 21 of your input file, it is reading something (in columns 56-75) that does not compiy with the DATETIME informat (e.g. 04/04/2019 14:35).

I would suggest you add the following lines to your code and review the output in the log

if _n_=21 then put _infile_ ;

[ballardw]

The indicated variables do not contain the expected layout for the stated informat used such as:

Since you have suppressed the LOG entry portion with the Rule and values, likely because their are a fair number of lines we can't recommend the appropriate specific fix because we can't see the offending values.

My first try if I were feeling lazy would be to change the informat for one of the variables having problems to ANYDTDTM40. and see if that fixes.

A common problem that sometimes arises with dates, times and datetime values is a system that puts in invalid dates to indicate missing that may have a values of all 9s such as 99/99/9999 for a date in mmddyy10 layout. If you find something like that you can add the INFORMAT modifier ? , to just suppress printing the invalid data note, or ?? to suppress the note, data line and does not set the _ERROR_ varaible

Example:

input

<other variables>

ADM_DT ??

<other variables on input>

;

You really should only use the ? or ?? when you know there is a specific form of invalid data occurring as you might not get appropriate notice of simple data entry errors that have crept into the data file (such as a 67NOV1988 I ran into once).

One other thing you might try. The code you show was originally written by Proc Import. I might try proc import with a very large value for guessingrows, at least the number of rows in the file, and see if a different informat gets assigned. This might happen if the date or datetime layout is mixed between 01JAN2019 and 01/01.2019 for some reason.

Be aware that the variable names might differ if the structure of the file has changed.

Also since you already have notes about changes to the data file, perhaps someone snuck in another one without notice and you are not reading the values you think you are.

[Ranjeeta]

ok thankyou the file imported why would i get 1 record in the log?

NOTE: The infile "\\ccnfs\Company\KNOWLEDGE MANAGEMENT\MOH Data\DAD_NACRS\FY1819Q3_DAD.csv" is:
Filename=\\ccnfs\Company\KNOWLEDGE MANAGEMENT\MOH Data\DAD_NACRS\FY1819Q3_DAD.csv,
RECFM=V,LRECL=32767,
File Size (bytes)=1620263710,
Last Modified=April 04, 2019 10:53:52,
Create Time=April 04, 2019 10:53:52

,,,,,,,,,,,,,,06SEP2018:00:00:00,,,,,,,,,,,,,,,,,,,,06SEP2018:12:53:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1NA13BAFA,2NK70BABL,1
IS53GRLF,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,PI,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,000000000000207,000000000000207,,,,,,,,,,,,,,,,,,,00015,00015,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,02,03,06,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,9,8,8,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,45,,,,,,,,,,,,,,,,,
,,,100,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,30,93,,,,,06SEP2018:00:00:00,07SEP2018:00:00:00,,,,,06SEP2018:09:53:00,07SEP2018:22:32:00,,,,,07SEP2018:00:00:00,10SEP2018:00
:00:00,,,,,07SEP2018:22:32:00,10SEP2018:15:30:00,,,,,37,65,,,,,M0004,M0004,4,4,0,M,2,,,,,,,000000000020075,000000000020060,,,,,,,00010,00010,,,,,,,06,231,S,4,2,1,0,01,2
0.3,1,1.7175,,,,,,,2018,00000001.00,06,231,00,I,4,0003.0234,S,2,1,0,1.7175,20.3,79,01,1,0.967,3,65,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,231,01,1.4,7.7,S,01,0,1,0,20.8,00,0,00,00,3508,

NOTE: 927295 records were read from the infile "\\ccnfs\Company\KNOWLEDGE MANAGEMENT\MOH Data\DAD_NACRS\FY1819Q3_DAD.csv".
The minimum record length was 1371.
The maximum record length was 4748.
NOTE: The data set WORK.DAD1819Q3 has 927295 observations and 908 variables.
NOTE: DATA statement used (Total process time):
real time 18:01.22
cpu time 45.29 seconds

[ballardw]

---

@Ranjeeta wrote:

ok thankyou the file imported why would i get 1 record in the log?

---

If you modified the code then that may have addressed a common layout issue that occurred for most of the cases you had before but could not handle some value in the record shown

Please post code, data and log entries in a code box opened on the forum with either the {I} or "running man" icon. The main message windows reformat text terribly and we can't quite be sure the diagnostic information provided in the invalid data method is layout out properly.

We also need the complete Invalid data line indicating the variables and positions.

For example running a smaller code with a problem my log looks like this:

2089  data example;
2090     input name $ firstname$ sale x datetime20.;
2091  datalines;

NOTE: Invalid data for x in line 2092 20-39.
RULE:       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-
2092        Smith John 1234567 36SEP2018:00:00:00
name=Smith firstname=John sale=1234567 x=. _ERROR_=1 _N_=1
NOTE: The data set USER.EXAMPLE has 1 observations and 4 variables.

This is simpler than yours as there was not enough text to wrap the line but you can see that the result is different.

So for something simple I can go to the position of the error using the RULER included

RULE:       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-
                               ^
                           position 20

So I start looking in the data and see the date in my case is 36Sep. And September can't have 36 days. So we know the 6 is causing the problem.

When the data is long enough to wrap there will be a number at the start of the line. That is the character count for the first position. The 2 in the ruler would then be that number plus 20 characters. Repeat until you can determine the listed variable position is. Then closely examine the values.

In the example you show I can't tell 1) which variable(s) 2) which positions anything is in or 3) if you even started with the first bit of the data line.

---

,,,,,,,,,,,,,,06SEP2018:00:00:00,,,,,,,,,,,,,,,,,,,,06SEP2018:12:53:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1NA13BAFA,2NK70BABL,1
IS53GRLF,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,PI,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,000000000000207,000000000000207,,,,,,,,,,,,,,,,,,,00015,00015,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,02,03,06,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,9,8,8,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,45,,,,,,,,,,,,,,,,,
,,,100,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,30,93,,,,,06SEP2018:00:00:00,07SEP2018:00:00:00,,,,,06SEP2018:09:53:00,07SEP2018:22:32:00,,,,,07SEP2018:00:00:00,10SEP2018:00
:00:00,,,,,07SEP2018:22:32:00,10SEP2018:15:30:00,,,,,37,65,,,,,M0004,M0004,4,4,0,M,2,,,,,,,000000000020075,000000000020060,,,,,,,00010,00010,,,,,,,06,231,S,4,2,1,0,01,2
0.3,1,1.7175,,,,,,,2018,00000001.00,06,231,00,I,4,0003.0234,S,2,1,0,1.7175,20.3,79,01,1,0.967,3,65,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,231,01,1.4,7.7,S,01,0,1,0,20.8,00,0,00,00,3508,

---

If the value I highlighted above in blue is supposed to be a DATETIME variable like the others then that would be a cause because there is insufficient information to assign anything resembling a TIME component to the value and may be the cause.

[ErikLund_Jensen]

Hi @Ranjeeta 

In addition to all the good advices you have already got, there is a simple way to avoid comma-counting and let SAS help with identifying the strings that causes trouble. Note that this works only if we are talking bad data values in an otherwise well-formatted delimited file. There is only the hard way if the problem is caused by broken lines, embedded line-feeds or delimiters or other junk often found in export files. 

Change the informat/format for the 4 variables and rerun with an obs count that includes the error. 

from

...
informat ADM_DT DATETIME20. ;
...
FORMAT ADM_DT DATETIME20. ;

To

...
informat ADM_DT $char20. ;
...
/* FORMAT ADM_DT DATETIME20. */;

Then you get the bad value in in the row/variable as given in the log note and can easily identify it. 

You must also consider what should happen with bad values. If it os OK to set them missing, then use the ? informat modifier. Otherwise read them as character and use a following data step to recode and/or report:

if charvar ne '' then do;
	numvar = input(numvar,?format.);
	if numvar = . then do;
		something
	end;
end;