BookmarkSubscribeRSS Feed
BLT2023
Calcite | Level 5

I am working on a project for school, and I have written the following code:

Spoiler
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: 

Spoiler
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? 

1 REPLY 1
Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

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.

Discussion stats
  • 1 reply
  • 293 views
  • 0 likes
  • 2 in conversation