Post log messages using a code box opened with the forum menu icon {i}. The positions of characters following
NOTE: Invalid data for ListDate in line 1 108-116. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+---
are critical for diagnosis but the forum message windows with reformat text changing character postions. I can tell that has happended because this line in your error message:
1 Kealy Rd Mt Wellington Auckland City Auckland
appears to show Mt Wellington starting at column 12 but your input statement is reading it starting at column 28. So your error message is incomplet.
how about copying about 5 lines of data from the text file and pasting that into a code box as well.
The code you are writing for your dates is going to fail because some of your dates will exceed 9 characters if you have any thing like
10/12/2005
Placing the format on the input statement as you are doing forces SAS to read exactly that and if the value does not start in the correct column (108 from your code) AND exactly match the layout you will get errors such as you are seeing. If column 108 contains a blank then the format is actually trying to read ' 4/11/200' (count the space as character 1 and the year ends before the last digit you want) and year 200 is invalid as far as SAS is concerned as the earliest date SAS will recognize is, IIRC, the English adoption of the Gregorian calendar.
@Reeza's suggestion for an informat using mmddyy10. will read dates that only have one digit month or day of month.
DATE9. would be used to read dates that look like 12OCT2005 so there is not wonder that did not work.
... View more