I am working on a project for school, and I have written the following code:
DATA CoImpt; INFILE "&CourseRoot/CDPHE Study/Data/1_Source/Depression.txt" DSD TRUNCOVER FIRSTOBS=2; INPUT county $10. Depressive_Disorder_Census_Tract Dep_95CI $21. Dep_Quintile $16. CT $48.; PROC CONTENTS DATA=CoImpt.Depression; RUN; DATA CoImpt; INFILE "&CourseRoot/CDPHE Study/Data/1_Source/lowbirthweight.csv"; INPUT OBJECTID COUNTY_NAME $10. COUNTY_FIPS LWB_ADJRATE LWB_L95CI LWB_U95CI LWB_STATEADJRATE LWB_SL95CI LWB_SU95CI LWB_DISPLAY $32. POD_DEATH_SL95CI POD_DEATH_SU95CI POD_DEATH_DISPLAY $32.; PROC CONTENTS DATA=CoImpt.lowbirthweight; RUN;
When I run this code, I get the following in my log:
253 *4.2 - Depression*; 254 DATACoImpt; 255 INFILE"&CourseRoot/CDPHE Study/Data/1_Source/Depression.txt" DSD TRUNCOVER FIRSTOBS=2; 256 INPUTcounty$10. 257 Depressive_Disorder_Census_Tract 258 Dep_95CI$21. 259 Dep_Quintile$16. 260 CT$48.; 261 262 NOTE: The infile "/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/Depression.txt" is: Filename=/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/Depression.txt, Owner Name=u63571562,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=25Sep2023:12:38:24, File Size (bytes)=94763 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 2 11-74. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2 Fremont 20.1 "95% C.I.: 18.9 - 21.4" "Middle Quintile" "Census Tract 9790" 74 county=Fremont 20 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=1 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 3 11-75. 3 Garfield 15.9 "95% C.I.: 14.8 - 17.1" "Fourth Quintile" "Census Tract 9516" 75 county=Garfield 1 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=2 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 4 11-76. 4 Larimer 19.7 "95% C.I.: 19.2 - 20.2" "Highest Quintile" "Census Tract 28.03" 76 county=Larimer 19 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=3 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 5 11-68. 5 Yuma 10.2 "95% C.I.: 8.7 - 13" "Lowest Quintile" "Census Tract 9632" 68 county=Yuma 10.2 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=4 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 6 11-73. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 6 Larimer 17.4 "95% C.I.: 16.8 - 18" "Lowest Quintile" "Census Tract 24.01" 73 county=Larimer 17 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=5 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 7 11-75. 7 Larimer 16.6 "95% C.I.: 16.1 - 17.1" "Lowest Quintile" "Census Tract 24.02" 75 county=Larimer 16 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=6 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 8 11-73. 8 "Rio Blanco" 9 "95% C.I.: 7.3 - 12" "Lowest Quintile" "Census Tract 9512" 73 county="Rio Blanc Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=7 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 9 11-75. 9 "Rio Blanco" 9.6 "95% C.I.: 8 - 12.5" "Lowest Quintile" "Census Tract 9511" 75 county="Rio Blanc Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=8 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 10 11-72. 10 Grand 15.1 "95% C.I.: 13.4 - 16.9" "Fourth Quintile" "Census Tract 2.01" 72 county=Grand 15.1 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=9 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 11 11-71. 11 Grand 18 "95% C.I.: 15.9 - 20.2" "Highest Quintile" "Census Tract 2.02" 71 county=Grand 18 " Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=10 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 12 11-70. 12 Grand 16.6 "95% C.I.: 14.2 - 18.8" "Highest Quintile" "Census Tract 1" 70 county=Grand 16.6 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=11 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 13 11-71. 13 Moffat 15.9 "95% C.I.: 14.2 - 18.2" "Highest Quintile" "Census Tract 6" 71 county=Moffat 15. Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=12 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 14 11-70. 14 Moffat 15.3 "95% C.I.: 13.6 - 17.6" "Fourth Quintile" "Census Tract 5" 70 county=Moffat 15. Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=13 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 15 11-69. 15 Moffat 16.8 "95% C.I.: 15 - 19.2" "Highest Quintile" "Census Tract 4" 69 county=Moffat 16. Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=14 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 16 11-71. 16 Moffat 15.9 "95% C.I.: 14.2 - 17.8" "Highest Quintile" "Census Tract 3" 71 county=Moffat 15. Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=15 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 17 11-70. 17 Jackson 12 "95% C.I.: 10.4 - 17" "Middle Quintile" "Census Tract 9556" 70 county=Jackson 12 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=16 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 18 11-77. 18 Washington 15.3 "95% C.I.: 12.8 - 18.2" "Second Quintile" "Census Tract 9241" 77 county=Washington Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=17 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 19 11-68. 19 Routt 11.1 "95% C.I.: 9.7 - 12.9" "Second Quintile" "Census Tract 8" 68 county=Routt 11.1 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=18 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 20 11-69. 20 Routt 12.9 "95% C.I.: 11.4 - 14.6" "Fourth Quintile" "Census Tract 7" 69 county=Routt 12.9 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=19 NOTE: Invalid data for Depressive_Disorder_Census_Tract in line 21 11-67. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 Routt 12.2 "95% C.I.: 10.9 - 14" "Middle Quintile" "Census Tract 5" 67 county=Routt 12.2 Depressive_Disorder_Census_Tract=. Dep_95CI= Dep_Quintile= CT= _ERROR_=1 _N_=20 NOTE: 1249 records were read from the infile "/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/Depression.txt". The minimum record length was 46. The maximum record length was 83. NOTE: The data set WORK.COIMPT has 1249 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 935.93k OS Memory 23460.00k Timestamp 09/27/2023 05:43:12 PM Step Count 148 Switch Count 2 Page Faults 0 Page Reclaims 131 Page Swaps 0 Voluntary Context Switches 15 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 536 262 ! PROC CONTENTS DATA=CoImpt.Depression; ERROR: Couldn't find range or sheet in spreadsheet ERROR: File COIMPT.Depression.DATA does not exist. 263 RUN; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2888.43k OS Memory 25588.00k Timestamp 09/27/2023 05:43:12 PM Step Count 149 Switch Count 0 Page Faults 0 Page Reclaims 660 Page Swaps 0 Voluntary Context Switches 3 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 NOTE: The SAS System stopped processing this step because of errors. 264 265 *4.3 - Low Birth Weight*; 266 DATACoImpt; 267 INFILE"&CourseRoot/CDPHE Study/Data/1_Source/lowbirthweight.csv"; 268 INPUTOBJECTID 269 COUNTY_NAME$10. 270 COUNTY_FIPS 271 LWB_ADJRATE 272 LWB_L95CI 273 LWB_U95CI 274 LWB_STATEADJRATE 275 LWB_SL95CI 276 LWB_SU95CI 277 LWB_DISPLAY$32. 278 POD_DEATH_SL95CI 279 POD_DEATH_SU95CI 280 POD_DEATH_DISPLAY$32.; 281 NOTE: The infile "/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv" is: Filename=/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv, Owner Name=u63571562,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=25Sep2023:12:38:24, File Size (bytes)=7466 NOTE: Invalid data for OBJECTID in line 1 1-167. NOTE: Invalid data for COUNTY_FIPS in line 2 11-47. NOTE: Invalid data for LWB_ADJRATE in line 2 49-52. NOTE: Invalid data for LWB_L95CI in line 2 54-58. NOTE: Invalid data for LWB_U95CI in line 2 60-80. NOTE: Invalid data for LWB_STATEADJRATE in line 2 82-90. NOTE: Invalid data for LWB_SL95CI in line 2 92-95. NOTE: Invalid data for LWB_SU95CI in line 2 97-101. NOTE: Invalid data for POD_DEATH_SL95CI in line 3 33-49. NOTE: Invalid data for POD_DEATH_SU95CI in line 3 51-59. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 3 2,LAS ANIMAS,71,8.24,6.12,10.37,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Not Differe 101 nt Than State Average 121 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=1,LARIMER, COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=2,LAS ANIMAS,71,8.24,6.12,10.37, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,Not _ERROR_=1 _N_=1 NOTE: Invalid data for OBJECTID in line 4 1-45. NOTE: Invalid data for COUNTY_FIPS in line 4 57-60. NOTE: Invalid data for LWB_ADJRATE in line 4 62-66. NOTE: Invalid data for LWB_L95CI in line 4 68-88. NOTE: Invalid data for LWB_U95CI in line 4 90-98. NOTE: Invalid data for LWB_STATEADJRATE in line 4 100-103. NOTE: Invalid data for LWB_SL95CI in line 4 105-109. NOTE: Invalid data for LWB_SU95CI in line 4 111-117. NOTE: Invalid data for POD_DEATH_SL95CI in line 5 33-46. NOTE: Invalid data for POD_DEATH_SU95CI in line 5 48-56. 5 4,GUNNISON,51,9.13,6.96,11.3,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or D 101 ata Suppressed 114 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=4,GUNNISON,51,9.13,6.96,11.3,7.1 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,No _ERROR_=1 _N_=2 NOTE: Invalid data for OBJECTID in line 6 1-50. NOTE: Invalid data for COUNTY_FIPS in line 6 63-86. NOTE: Invalid data for LWB_ADJRATE in line 6 88-91. NOTE: Invalid data for LWB_L95CI in line 6 93-97. NOTE: Invalid data for LWB_U95CI in line 6 99-105. NOTE: Invalid data for LWB_STATEADJRATE in line 7 1-43. NOTE: Invalid data for LWB_SL95CI in line 7 45-53. NOTE: Invalid data for LWB_SU95CI in line 7 55-58. NOTE: Invalid data for POD_DEATH_SL95CI in line 7 92-93. NOTE: Invalid data for POD_DEATH_SU95CI in line 7 95-99. 8 7,OTERO,89,7.33,5.73,8.93,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Not Different Tha 101 n State Average 115 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=State Average,8.24,8.93,Lower Th POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=7,OTERO,89,7.33,5.73,8.93,7.19,7 _ERROR_=1 _N_=3 NOTE: Invalid data for OBJECTID in line 9 1-4. NOTE: Invalid data for COUNTY_FIPS in line 9 16-46. NOTE: Invalid data for LWB_ADJRATE in line 9 48-56. NOTE: Invalid data for LWB_L95CI in line 9 58-61. NOTE: Invalid data for LWB_U95CI in line 9 63-67. NOTE: Invalid data for LWB_STATEADJRATE in line 9 69-91. NOTE: Invalid data for LWB_SL95CI in line 9 93-96. NOTE: Invalid data for LWB_SU95CI in line 9 98-102. NOTE: Invalid data for POD_DEATH_SL95CI in line 10 33-50. NOTE: Invalid data for POD_DEATH_SU95CI in line 10 52-55. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 10 9,SUMMIT,117,11.16,9.47,12.85,7.19,7.1,7.28,Higher Than State Average,8.24,8.93,Not Different Than S 101 tate Average 112 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=PLATA,67,6 COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=9,SUMMIT,117,11.16,9.47,12.85,7. POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=State Average,8.24,8.93,Not Diff _ERROR_=1 _N_=4 NOTE: Invalid data for OBJECTID in line 11 1-50. NOTE: Invalid data for COUNTY_FIPS in line 11 63-82. NOTE: Invalid data for LWB_ADJRATE in line 11 84-89. NOTE: Invalid data for LWB_L95CI in line 11 91-92. NOTE: Invalid data for LWB_U95CI in line 11 94-97. NOTE: Invalid data for LWB_STATEADJRATE in line 11 99-108. NOTE: Invalid data for LWB_SL95CI in line 12 1-45. NOTE: Invalid data for LWB_SU95CI in line 12 47-55. NOTE: Invalid data for POD_DEATH_SL95CI in line 12 89-94. NOTE: Invalid data for POD_DEATH_SU95CI in line 12 96-97. 13 12,CROWLEY,25,9.7,5.18,14.21,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or D 101 ata Suppressed 114 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=Than State Average,8.24,8.93,No POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=12,CROWLEY,25,9.7,5.18,14.21,7.1 _ERROR_=1 _N_=5 NOTE: Invalid data for OBJECTID in line 14 1-48. NOTE: Invalid data for COUNTY_FIPS in line 14 61-80. NOTE: Invalid data for LWB_ADJRATE in line 14 82-87. NOTE: Invalid data for LWB_L95CI in line 14 89-90. NOTE: Invalid data for LWB_U95CI in line 14 92-95. NOTE: Invalid data for LWB_STATEADJRATE in line 14 97-106. NOTE: Invalid data for LWB_SL95CI in line 15 1-41. NOTE: Invalid data for LWB_SU95CI in line 15 43-51. NOTE: Invalid data for POD_DEATH_SL95CI in line 15 85-90. NOTE: Invalid data for POD_DEATH_SU95CI in line 15 92-93. 16 15,ADAMS,1,7.39,7.11,7.66,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Higher Than State 101 Average 108 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=Than State Average,8.24,8.93,No POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=15,ADAMS,1,7.39,7.11,7.66,7.19,7 _ERROR_=1 _N_=6 NOTE: Invalid data for OBJECTID in line 17 1-45. NOTE: Invalid data for COUNTY_FIPS in line 17 57-60. NOTE: Invalid data for LWB_ADJRATE in line 17 62-66. NOTE: Invalid data for LWB_L95CI in line 17 68-87. NOTE: Invalid data for LWB_U95CI in line 17 89-94. NOTE: Invalid data for LWB_STATEADJRATE in line 17 96-97. NOTE: Invalid data for LWB_SL95CI in line 17 99-102. NOTE: Invalid data for LWB_SU95CI in line 17 104-113. NOTE: Invalid data for POD_DEATH_SL95CI in line 18 33-44. NOTE: Invalid data for POD_DEATH_SU95CI in line 18 46-54. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 18 17,YUMA,125,5.99,4.21,7.76,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or Dat 101 a Suppressed 112 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=17,YUMA,125,5.99,4.21,7.76,7.19, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,No _ERROR_=1 _N_=7 NOTE: Invalid data for OBJECTID in line 19 1-43. NOTE: Invalid data for COUNTY_FIPS in line 19 55-58. NOTE: Invalid data for LWB_ADJRATE in line 19 60-64. NOTE: Invalid data for LWB_L95CI in line 19 66-85. NOTE: Invalid data for LWB_U95CI in line 19 87-92. NOTE: Invalid data for LWB_STATEADJRATE in line 19 94-95. NOTE: Invalid data for LWB_SL95CI in line 19 97-100. NOTE: Invalid data for LWB_SU95CI in line 19 102-111. NOTE: Invalid data for POD_DEATH_SL95CI in line 20 33-44. NOTE: Invalid data for POD_DEATH_SU95CI in line 20 46-54. 20 19,DELTA,29,7.43,6.07,8.79,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Lower Than State 101 Average 108 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=19,DELTA,29,7.43,6.07,8.79,7.19, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,Low _ERROR_=1 _N_=8 NOTE: Invalid data for OBJECTID in line 21 1-52. NOTE: Invalid data for COUNTY_FIPS in line 21 65-84. NOTE: Invalid data for LWB_ADJRATE in line 21 86-91. NOTE: Invalid data for LWB_L95CI in line 21 93-94. NOTE: Invalid data for LWB_U95CI in line 21 96-99. NOTE: Invalid data for LWB_STATEADJRATE in line 21 101-110. NOTE: Invalid data for LWB_SL95CI in line 22 1-46. NOTE: Invalid data for LWB_SU95CI in line 22 48-56. NOTE: Invalid data for POD_DEATH_SL95CI in line 22 91-99. NOTE: Invalid data for POD_DEATH_SU95CI in line 22 101-104. 23 22,MORGAN,87,5.03,4.09,5.97,7.19,7.1,7.28,Lower Than State Average,8.24,8.93,Not Different Than Stat 101 e Average 109 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=Than State Average,8.24,8.93,Not POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=22,MORGAN,87,5.03,4.09,5.97,7.19 _ERROR_=1 _N_=9 NOTE: Invalid data for OBJECTID in line 24 1-46. NOTE: Invalid data for COUNTY_FIPS in line 24 58-61. NOTE: Invalid data for LWB_ADJRATE in line 24 63-67. NOTE: Invalid data for LWB_L95CI in line 24 69-89. NOTE: Invalid data for LWB_U95CI in line 24 91-99. NOTE: Invalid data for LWB_STATEADJRATE in line 24 101-104. NOTE: Invalid data for LWB_SL95CI in line 24 106-110. NOTE: Invalid data for LWB_SU95CI in line 24 112-118. NOTE: Invalid data for POD_DEATH_SL95CI in line 25 33-52. NOTE: Invalid data for POD_DEATH_SU95CI in line 25 54-57. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 25 24,MONTEZUMA,83,8.72,7.28,10.17,7.19,7.1,7.28,Higher Than State Average,8.24,8.93,Not Different Than 101 State Average 114 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=24,MONTEZUMA,83,8.72,7.28,10.17, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=State Average,8.24,8.93,Not Diff _ERROR_=1 _N_=10 NOTE: Invalid data for OBJECTID in line 26 1-33. NOTE: Invalid data for COUNTY_FIPS in line 26 45-48. NOTE: Invalid data for LWB_ADJRATE in line 26 50-72. NOTE: Invalid data for LWB_L95CI in line 26 74-79. NOTE: Invalid data for LWB_U95CI in line 26 81-82. NOTE: Invalid data for LWB_STATEADJRATE in line 26 84-87. NOTE: Invalid data for LWB_SL95CI in line 26 89-98. NOTE: Invalid data for LWB_SU95CI in line 27 1-46. NOTE: Invalid data for POD_DEATH_SL95CI in line 27 80-88. NOTE: Invalid data for POD_DEATH_SU95CI in line 27 90-95. 28 27,JEFFERSON,59,6.75,6.46,7.04,7.19,7.1,7.28,Lower Than State Average,8.24,8.93,Not Different Than S 101 tate Average 112 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Events or COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=Different Than State Average,8.2 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=27,JEFFERSON,59,6.75,6.46,7.04,7 _ERROR_=1 _N_=11 NOTE: Invalid data for OBJECTID in line 29 1-6. NOTE: Invalid data for COUNTY_FIPS in line 29 18-50. NOTE: Invalid data for LWB_ADJRATE in line 29 52-60. NOTE: Invalid data for LWB_L95CI in line 29 62-65. NOTE: Invalid data for LWB_U95CI in line 29 67-71. NOTE: Invalid data for LWB_STATEADJRATE in line 29 73-93. NOTE: Invalid data for LWB_SL95CI in line 29 95-103. NOTE: Invalid data for LWB_SU95CI in line 29 105-108. NOTE: Invalid data for POD_DEATH_SL95CI in line 30 33-49. NOTE: Invalid data for POD_DEATH_SU95CI in line 30 51-59. 30 29,SEDGWICK,115,6.03,2.45,11.07,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events o 101 r Data Suppressed 117 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=BLANCO,103 COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=29,SEDGWICK,115,6.03,2.45,11.07, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,No _ERROR_=1 _N_=12 NOTE: Invalid data for OBJECTID in line 31 1-6. NOTE: Invalid data for COUNTY_FIPS in line 31 18-48. NOTE: Invalid data for LWB_ADJRATE in line 31 50-58. NOTE: Invalid data for LWB_L95CI in line 31 60-63. NOTE: Invalid data for LWB_U95CI in line 31 65-69. NOTE: Invalid data for LWB_STATEADJRATE in line 31 71-90. NOTE: Invalid data for LWB_SL95CI in line 31 92-97. NOTE: Invalid data for LWB_SU95CI in line 31 99-100. NOTE: Invalid data for POD_DEATH_SL95CI in line 32 33-46. NOTE: Invalid data for POD_DEATH_SU95CI in line 32 48-56. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 32 31,ALAMOSA,3,8.93,7.19,10.66,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Not Different 101 Than State Average 118 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=MIGUEL,113 COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=31,ALAMOSA,3,8.93,7.19,10.66,7.1 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,Not _ERROR_=1 _N_=13 NOTE: Invalid data for OBJECTID in line 33 1-47. NOTE: Invalid data for COUNTY_FIPS in line 33 59-62. NOTE: Invalid data for LWB_ADJRATE in line 33 64-68. NOTE: Invalid data for LWB_L95CI in line 33 70-89. NOTE: Invalid data for LWB_U95CI in line 33 91-96. NOTE: Invalid data for LWB_STATEADJRATE in line 33 98-99. NOTE: Invalid data for LWB_SL95CI in line 33 101-104. NOTE: Invalid data for LWB_SU95CI in line 33 106-115. NOTE: Invalid data for POD_DEATH_SL95CI in line 34 33-45. NOTE: Invalid data for POD_DEATH_SU95CI in line 34 47-55. 34 33,OURAY,91,9.29,4.48,14.09,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or Da 101 ta Suppressed 113 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=33,OURAY,91,9.29,4.48,14.09,7.19 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,No _ERROR_=1 _N_=14 NOTE: Invalid data for OBJECTID in line 35 1-43. NOTE: Invalid data for COUNTY_FIPS in line 35 55-58. NOTE: Invalid data for LWB_ADJRATE in line 35 60-64. NOTE: Invalid data for LWB_L95CI in line 35 66-86. NOTE: Invalid data for LWB_U95CI in line 35 88-96. NOTE: Invalid data for LWB_STATEADJRATE in line 35 98-101. NOTE: Invalid data for LWB_SL95CI in line 35 103-107. NOTE: Invalid data for LWB_SU95CI in line 35 109-115. NOTE: Invalid data for POD_DEATH_SL95CI in line 36 33-53. NOTE: Invalid data for POD_DEATH_SU95CI in line 36 55-58. 36 35,SAGUACHE,109,11.63,8.24,15.02,7.19,7.1,7.28,Higher Than State Average,8.24,8.93,No Events or Data 101 Suppressed 111 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=35,SAGUACHE,109,11.63,8.24,15.02 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=State Average,8.24,8.93,No Event _ERROR_=1 _N_=15 NOTE: Invalid data for OBJECTID in line 37 1-47. NOTE: Invalid data for COUNTY_FIPS in line 37 60-82. NOTE: Invalid data for LWB_ADJRATE in line 37 84-87. NOTE: Invalid data for LWB_L95CI in line 37 89-93. NOTE: Invalid data for LWB_U95CI in line 37 95-101. NOTE: Invalid data for LWB_STATEADJRATE in line 38 1-47. NOTE: Invalid data for LWB_SL95CI in line 38 49-57. NOTE: Invalid data for LWB_SU95CI in line 38 59-62. NOTE: Invalid data for POD_DEATH_SL95CI in line 38 96-96. NOTE: Invalid data for POD_DEATH_SU95CI in line 38 98-99. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 39 38,RIO GRANDE,105,9.11,6.87,11.34,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Not Diffe 101 rent Than State Average 123 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=State Average,8.24,8.93,No Event POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=38,RIO GRANDE,105,9.11,6.87,11.3 _ERROR_=1 _N_=16 NOTE: Invalid data for OBJECTID in line 40 1-49. NOTE: Invalid data for COUNTY_FIPS in line 40 62-85. NOTE: Invalid data for LWB_ADJRATE in line 40 87-90. NOTE: Invalid data for LWB_L95CI in line 40 92-96. NOTE: Invalid data for LWB_U95CI in line 40 98-104. NOTE: Invalid data for LWB_STATEADJRATE in line 41 1-6. NOTE: Invalid data for LWB_SL95CI in line 41 8-48. NOTE: Invalid data for LWB_SU95CI in line 41 50-58. NOTE: Invalid data for POD_DEATH_SL95CI in line 41 93-101. NOTE: Invalid data for POD_DEATH_SU95CI in line 41 103-106. 42 41,BACA,9,2.2,0.58,4.82,7.19,7.1,7.28,Lower Than State Average,8.24,8.93,No Events or Data Suppresse 101 d 101 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=Than State Average,8.24,8.93,Not POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=41,BACA,9,2.2,0.58,4.82,7.19,7.1 _ERROR_=1 _N_=17 NOTE: Invalid data for OBJECTID in line 43 1-45. NOTE: Invalid data for COUNTY_FIPS in line 43 57-60. NOTE: Invalid data for LWB_ADJRATE in line 43 62-66. NOTE: Invalid data for LWB_L95CI in line 43 68-88. NOTE: Invalid data for LWB_U95CI in line 43 90-98. NOTE: Invalid data for LWB_STATEADJRATE in line 43 100-103. NOTE: Invalid data for LWB_SL95CI in line 43 105-109. NOTE: Invalid data for LWB_SU95CI in line 43 111-117. NOTE: Invalid data for POD_DEATH_SL95CI in line 44 33-43. NOTE: Invalid data for POD_DEATH_SU95CI in line 44 45-53. 44 43,LOGAN,75,6.33,4.9,7.75,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,Lower Than State 101 Average 107 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Different COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=43,LOGAN,75,6.33,4.9,7.75,7.19,7 POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,Low _ERROR_=1 _N_=18 NOTE: Invalid data for OBJECTID in line 45 1-8. NOTE: Invalid data for COUNTY_FIPS in line 45 20-49. NOTE: Invalid data for LWB_ADJRATE in line 45 51-59. NOTE: Invalid data for LWB_L95CI in line 45 61-64. NOTE: Invalid data for LWB_U95CI in line 45 66-70. NOTE: Invalid data for LWB_STATEADJRATE in line 45 72-92. NOTE: Invalid data for LWB_SL95CI in line 45 94-102. NOTE: Invalid data for LWB_SU95CI in line 45 104-107. NOTE: Invalid data for POD_DEATH_SL95CI in line 46 33-44. NOTE: Invalid data for POD_DEATH_SU95CI in line 46 46-54. 46 45,MOFFAT,81,7.56,5.82,9.3,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or Dat 101 a Suppressed 112 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=CREE,19,6. COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=45,MOFFAT,81,7.56,5.82,9.3,7.19, POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=Than State Average,8.24,8.93,No _ERROR_=1 _N_=19 NOTE: Invalid data for OBJECTID in line 47 1-51. NOTE: Invalid data for COUNTY_FIPS in line 47 64-84. NOTE: Invalid data for LWB_ADJRATE in line 47 86-94. NOTE: Invalid data for LWB_L95CI in line 47 96-99. NOTE: Invalid data for LWB_U95CI in line 47 101-105. NOTE: Invalid data for LWB_STATEADJRATE in line 47 107-113. NOTE: Invalid data for LWB_SL95CI in line 48 1-48. NOTE: Invalid data for LWB_SU95CI in line 48 50-53. NOTE: Invalid data for POD_DEATH_SL95CI in line 48 87-88. NOTE: Invalid data for POD_DEATH_SU95CI in line 48 90-94. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 49 48,KIOWA,61,7.32,2.72,13.91,7.19,7.1,7.28,Not Different Than State Average,8.24,8.93,No Events or Da 101 ta Suppressed 113 NOTE: Invalid data errors for file '"/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. OBJECTID=. COUNTY_NAME=Than State COUNTY_FIPS=. LWB_ADJRATE=. LWB_L95CI=. LWB_U95CI=. LWB_STATEADJRATE=. LWB_SL95CI=. LWB_SU95CI=. LWB_DISPLAY=State Average,8.24,8.93,Lower Th POD_DEATH_SL95CI=. POD_DEATH_SU95CI=. POD_DEATH_DISPLAY=48,KIOWA,61,7.32,2.72,13.91,7.19 _ERROR_=1 _N_=20 NOTE: LOST CARD. NOTE: 65 records were read from the infile "/home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/lowbirthweight.csv". The minimum record length was 98. The maximum record length was 167. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.COIMPT has 26 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 867.78k OS Memory 23460.00k Timestamp 09/27/2023 05:43:12 PM Step Count 150 Switch Count 2 Page Faults 0 Page Reclaims 95 Page Swaps 0 Voluntary Context Switches 19 Involuntary Context Switches 0 Block Input Operations 16 Block Output Operations 320 281 ! PROC CONTENTS DATA=CoImpt.lowbirthweight; ERROR: Couldn't find range or sheet in spreadsheet ERROR: File COIMPT.lowbirthweight.DATA does not exist. 282 RUN; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2888.93k OS Memory 25844.00k Timestamp 09/27/2023 05:43:12 PM Step Count 151 Switch Count 0 Page Faults 0 Page Reclaims 662 Page Swaps 0 Voluntary Context Switches 2 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 NOTE: The SAS System stopped processing this step because of errors. 283
Why am I getting ERROR: Couldn't find range or sheet in spreadsheet, ERROR: File does not exist, and WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed messages?
Look at the Excel file used in the LIBNAME COIMPT statement to see which spreadsheets are contained.
The WARNING is the result of improper use of INFILE and INPUT; we will deal with that in your other thread.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.