I was switching back and forth between a comma and a colon because I thought the delimiter was causing problems. Turns out changing it had no effect at all. I also tried changing the delimiter to ",;" while using a comma and a colon in the data. Neither method worked. Full log is as follows:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
76
77 DATA presidents;
78 INFILE '/folders/myshortcuts/SASScripts/RawData/aaaa.csv' DLMSTR=',' FIRSTOBS=2;
79 INPUT TookOffice DDMMYY10. LeftOffice DDMMYY10.;
80 RUN;
NOTE: The infile '/folders/myshortcuts/SASScripts/RawData/aaaa.csv' is:
Filename=/folders/myshortcuts/SASScripts/RawData/aaaa.csv,
Owner Name=root,Group Name=vboxsf,
Access Permission=-rwxrwx---,
Last Modified=14Jan2018:12:57:06,
File Size (bytes)=1041
NOTE: Invalid data for LeftOffice in line 2 11-20.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
2 30/04/1789,04/03/1797 21
TookOffice=-62336 LeftOffice=. _ERROR_=1 _N_=1
NOTE: Invalid data for LeftOffice in line 3 11-20.
3 04/03/1797,04/03/1801 21
TookOffice=-59471 LeftOffice=. _ERROR_=1 _N_=2
NOTE: Invalid data for LeftOffice in line 4 11-20.
4 04/03/1801,04/03/1809 21
TookOffice=-58011 LeftOffice=. _ERROR_=1 _N_=3
NOTE: Invalid data for LeftOffice in line 5 11-20.
5 04/03/1809,04/03/1817 21
TookOffice=-55089 LeftOffice=. _ERROR_=1 _N_=4
NOTE: Invalid data for LeftOffice in line 6 11-20.
6 04/03/1817,04/03/1825 21
TookOffice=-52167 LeftOffice=. _ERROR_=1 _N_=5
NOTE: Invalid data for LeftOffice in line 7 11-20.
7 04/03/1825,04/03/1829 21
TookOffice=-49245 LeftOffice=. _ERROR_=1 _N_=6
NOTE: Invalid data for LeftOffice in line 8 11-20.
8 04/03/1829,04/03/1837 21
TookOffice=-47784 LeftOffice=. _ERROR_=1 _N_=7
NOTE: Invalid data for LeftOffice in line 9 11-20.
9 04/03/1837,04/03/1841 21
TookOffice=-44862 LeftOffice=. _ERROR_=1 _N_=8
NOTE: Invalid data for LeftOffice in line 10 11-20.
10 04/03/1841,04/04/1841 21
TookOffice=-43401 LeftOffice=. _ERROR_=1 _N_=9
NOTE: Invalid data for LeftOffice in line 11 11-20.
11 04/04/1841,04/03/1845 21
TookOffice=-43370 LeftOffice=. _ERROR_=1 _N_=10
NOTE: Invalid data for LeftOffice in line 12 11-20.
12 04/03/1845,04/03/1849 21
TookOffice=-41940 LeftOffice=. _ERROR_=1 _N_=11
NOTE: Invalid data for LeftOffice in line 13 11-20.
13 04/03/1849,09/07/1850 21
TookOffice=-40479 LeftOffice=. _ERROR_=1 _N_=12
NOTE: Invalid data for LeftOffice in line 14 11-20.
14 09/07/1850,04/03/1853 21
TookOffice=-39987 LeftOffice=. _ERROR_=1 _N_=13
NOTE: Invalid data for LeftOffice in line 15 11-20.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
15 04/03/1853,04/03/1857 21
TookOffice=-39018 LeftOffice=. _ERROR_=1 _N_=14
NOTE: Invalid data for LeftOffice in line 16 11-20.
16 04/03/1857,04/03/1861 21
TookOffice=-37557 LeftOffice=. _ERROR_=1 _N_=15
NOTE: Invalid data for LeftOffice in line 17 11-20.
17 04/03/1861,15/04/1865 21
TookOffice=-36096 LeftOffice=. _ERROR_=1 _N_=16
NOTE: Invalid data for LeftOffice in line 18 11-20.
18 15/04/1865,04/03/1869 21
TookOffice=-34593 LeftOffice=. _ERROR_=1 _N_=17
NOTE: Invalid data for LeftOffice in line 19 11-20.
19 04/03/1869,04/03/1877 21
TookOffice=-33174 LeftOffice=. _ERROR_=1 _N_=18
NOTE: Invalid data for LeftOffice in line 20 11-20.
20 04/03/1877,04/03/1881 21
TookOffice=-30252 LeftOffice=. _ERROR_=1 _N_=19
NOTE: Invalid data for LeftOffice in line 21 11-20.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
21 04/03/1881,19/09/1881 21
TookOffice=-28791 LeftOffice=. _ERROR_=1 _N_=20
NOTE: 44 records were read from the infile '/folders/myshortcuts/SASScripts/RawData/aaaa.csv'.
The minimum record length was 21.
The maximum record length was 21.
NOTE: The data set WORK.PRESIDENTS has 44 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
81 TITLE "presidents.csv";
82 PROC PRINT Data=presidents;
83 RUN;
NOTE: There were 44 observations read from the data set WORK.PRESIDENTS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.10 seconds
cpu time 0.09 seconds
84
85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
98
... View more