This encoding will be used to process the file. 1 /********************************************************************** 2 * PRODUCT: SAS 3 * VERSION: 9.4 4 * CREATOR: External File Interface 5 * DATE: 11MAR24 6 * DESC: Generated SAS Datastep Code 7 * TEMPLATE SOURCE: (None Specified.) 8 ***********************************************************************/ 9 data WORK.lab ; 10 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 11 infile 13 informat encounter_study_id $6. ; 14 informat specimen_collected_timestamp anydtdtm40. ; 15 informat lab_base_name $5. ; 16 informat lab_component_name $44. ; 17 informat numeric_value best32. ; 18 informat string_value best32. ; 19 informat units $15. ; 20 format patient_study_id $6. ; 21 format encounter_study_id $6. ; 22 format specimen_collected_timestamp datetime. ; 23 format lab_base_name $5. ; 24 format lab_component_name $44. ; 25 format numeric_value best12. ; 26 format string_value best12. ; 27 format units $15. ; 28 input 29 patient_study_id $ 30 encounter_study_id $ 31 specimen_collected_timestamp 32 lab_base_name $ 33 lab_component_name $ 34 numeric_value 35 string_value 36 units $ 37 ; 38 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 39 run; NOTE: A byte-order mark in the file NOTE: Invalid data for string_value in line 69 87-90. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9-- 69 GJYXY2,GN3PV2,2012-10-05 10:29:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJYXY2 encounter_study_id=GN3PV2 specimen_collected_timestamp=05OCT12:10:29:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=68 NOTE: Invalid data for string_value in line 188 87-90. 188 GJYWZS,GL6NQU,2013-05-06 09:25:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJYWZS encounter_study_id=GL6NQU specimen_collected_timestamp=06MAY13:09:25:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=187 NOTE: Invalid data for string_value in line 201 80-98. 201 GJZCP1,GL9ILP,2013-04-19 12:58:00,UMACR,ALB/CRET RATIO URINE (UWHC),10000000.0,Calculation I 93 nvalid,mg/g cret 108 patient_study_id=GJZCP1 encounter_study_id=GL9ILP specimen_collected_timestamp=19APR13:12:58:00 lab_base_name=UMACR lab_component_name=ALB/CRET RATIO URINE (UWHC) numeric_value=10000000 string_value=. units=mg/g cret _ERROR_=1 _N_=200 NOTE: Invalid data for string_value in line 202 80-99. 202 GJZFJD,GLYUUA,2014-12-05 11:08:00,UMACR,ALB/CRET RATIO URINE (UWHC),10000000.0,Unable to cal 93 culate.,mg/g cret 109 patient_study_id=GJZFJD encounter_study_id=GLYUUA specimen_collected_timestamp=05DEC14:11:08:00 lab_base_name=UMACR lab_component_name=ALB/CRET RATIO URINE (UWHC) numeric_value=10000000 string_value=. units=mg/g cret _ERROR_=1 _N_=201 NOTE: Invalid data for string_value in line 480 79-82. 480 GJZ4NH,GKG3FF,2017-06-13 08:44:00,UMA,"MICROALBUMIN, URINE (UWMF)",10000000.0,<5.0,mg/L 87 patient_study_id=GJZ4NH encounter_study_id=GKG3FF specimen_collected_timestamp=13JUN17:08:44:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=479 NOTE: Invalid data for string_value in line 481 78-79. 481 GJZ8XU,GJPLFT,2020-06-15 10:20:00,UMA,"MICROALBUMIN, URINE (UWH)",10000000.0,<5,mg/L 84 patient_study_id=GJZ8XU encounter_study_id=GJPLFT specimen_collected_timestamp=15JUN20:10:20:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWH) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=480 NOTE: Invalid data for string_value in line 500 87-90. 500 GJZ95J,GMMH3E,2012-07-26 12:16:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJZ95J encounter_study_id=GMMH3E specimen_collected_timestamp=26JUL12:12:16:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=499 NOTE: Invalid data for string_value in line 547 78-79. 547 GJZ5BE,GL81B5,2021-12-14 10:23:00,UMA,"MICROALBUMIN, URINE (UWH)",10000000.0,<5,mg/L 84 patient_study_id=GJZ5BE encounter_study_id=GL81B5 specimen_collected_timestamp=14DEC21:10:23:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWH) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=546 NOTE: Invalid data for string_value in line 614 87-90. 614 GJZ5VF,GJIGU7,2011-01-03 08:16:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJZ5VF encounter_study_id=GJIGU7 specimen_collected_timestamp=03JAN11:08:16:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=613 NOTE: Invalid data for string_value in line 833 76-77. 833 GJZ0N5,GJIWHW,2015-02-17 09:11:00,UMA,MICROALBUMIN URINE (UWHC),10000000.0,<5,mg/L 82 patient_study_id=GJZ0N5 encounter_study_id=GJIWHW specimen_collected_timestamp=17FEB15:09:11:00 lab_base_name=UMA lab_component_name=MICROALBUMIN URINE (UWHC) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=832 NOTE: Invalid data for string_value in line 854 78-79. 854 GJZE5W,GNB0CL,2023-07-17 08:25:00,UMA,"MICROALBUMIN, URINE (UWH)",10000000.0,<5,mg/L 84 patient_study_id=GJZE5W encounter_study_id=GNB0CL specimen_collected_timestamp=17JUL23:08:25:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWH) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=853 NOTE: Invalid data for string_value in line 863 80-98. 863 GJYXGO,GM9EHO,2014-02-18 14:31:00,UMACR,ALB/CRET RATIO URINE (UWHC),10000000.0,Calculation I 93 nvalid,mg/g cret 108 patient_study_id=GJYXGO encounter_study_id=GM9EHO specimen_collected_timestamp=18FEB14:14:31:00 lab_base_name=UMACR lab_component_name=ALB/CRET RATIO URINE (UWHC) numeric_value=10000000 string_value=. units=mg/g cret _ERROR_=1 _N_=862 NOTE: Invalid data for string_value in line 890 78-79. 890 GJZ9HH,GLCQ2I,2022-02-10 16:13:00,UMA,"MICROALBUMIN, URINE (UWH)",10000000.0,<5,mg/L 84 patient_study_id=GJZ9HH encounter_study_id=GLCQ2I specimen_collected_timestamp=10FEB22:16:13:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWH) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=889 NOTE: Invalid data for string_value in line 1083 76-85. 1083 GJZENA,GKXVLB,2014-11-09 12:30:00,LDL,LDL CHOLESTEROL (OUTSIDE),10000000.0,Not Tested,mg/dL 91 patient_study_id=GJZENA encounter_study_id=GKXVLB specimen_collected_timestamp=09NOV14:12:30:00 lab_base_name=LDL lab_component_name=LDL CHOLESTEROL (OUTSIDE) numeric_value=10000000 string_value=. units=mg/dL _ERROR_=1 _N_=1082 NOTE: Invalid data for string_value in line 1103 87-90. 1103 GJZ8Q1,GLUYEK,2015-06-28 11:22:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9-- 93 g/L 95 patient_study_id=GJZ8Q1 encounter_study_id=GLUYEK specimen_collected_timestamp=28JUN15:11:22:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=1102 NOTE: Invalid data for string_value in line 1354 87-90. 1354 GJYY34,GLKCPR,2015-06-04 08:14:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJYY34 encounter_study_id=GLKCPR specimen_collected_timestamp=04JUN15:08:14:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=1353 NOTE: Invalid data for string_value in line 1386 78-79. 1386 GJYZ61,GLHF4L,2022-05-18 08:56:00,UMA,"MICROALBUMIN, URINE (UWH)",10000000.0,<5,mg/L 84 patient_study_id=GJYZ61 encounter_study_id=GLHF4L specimen_collected_timestamp=18MAY22:08:56:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE (UWH) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=1385 NOTE: Invalid data for string_value in line 1529 87-90. 1529 GJZ1SW,GKHA62,2011-03-08 08:46:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJZ1SW encounter_study_id=GKHA62 specimen_collected_timestamp=08MAR11:08:46:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=1528 NOTE: Invalid data for string_value in line 1650 87-90. 1650 GJZ57M,GLXKGE,2012-01-02 09:04:00,UMA,"MICROALBUMIN, URINE OLYMPUS (UWMF)",10000000.0,<5.0,m 93 g/L 95 patient_study_id=GJZ57M encounter_study_id=GLXKGE specimen_collected_timestamp=02JAN12:09:04:00 lab_base_name=UMA lab_component_name=MICROALBUMIN, URINE OLYMPUS (UWMF) numeric_value=10000000 string_value=. units=mg/L _ERROR_=1 _N_=1649 NOTE: Invalid data for string_value in line 1738 71-90. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 1738 GJZMIA,GJRRKF,2015-09-05 05:12:00,LDL,EST. LDL CHOL (UWHC),10000000.0,Unable to calculate.,m 93 g/dL 96 patient_study_id=GJZMIA encounter_study_id=GJRRKF specimen_collected_timestamp=05SEP15:05:12:00 lab_base_name=LDL lab_component_name=EST. LDL CHOL (UWHC) numeric_value=10000000 string_value=. units=mg/dL _ERROR_=1 _N_=1737 NOTE: 2167731 records were read from the infile 'R:\WI_EMR_DM_vision_loss_V2\Channa_RITM1118036_2023_11_02\CHANNA_RITM1118036_FILE04_2023_11_02_ subbed_2023_11_02.csv'. The minimum record length was 33. The maximum record length was 179. NOTE: The data set WORK.LAB has 2167731 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 1:30.71 cpu time 3.67 seconds Errors detected in submitted DATA step. Examine log. ERROR: Import unsuccessful. See SAS Log for details. How I can fix it. I see the error is "string value" and I should ask sas that read it as character, not numerical value
... View more
