I've started moving doing more of my own coding vs using enterprise guide and I have a puzzling issue. I have the same input statement, that works just great with the input in a datalines, but when I try and use a and INFILE, sas complains about data format issues. I'm running SAS 9.2 on AIX. I am doing all my edits on the unix box so I doubt it's some sort of unix/dos formatting issue. I'm a little puzzled. If I read it all in as strings and convert it also seems to work fine, but that's more work when I have 500 or so fields. This works fine: OPTIONS DATESTYLE=MDY; data &TEMP_DS; format timeStamp dateampm22. ; input tdate mmddyy11. hourStamp adjCount comma8.; timeStamp=dhms(tdate,hourStamp,30,0); keep timeStamp hourStamp adjCount; label timeStamp = "TimeStamp" adjCount = "Adjucation Count" ; datalines; 01/01/2010 3 321 01/01/2010 4 335 01/01/2010 5 376 01/01/2010 6 383 01/01/2010 7 385 ; But when this same data is in a file and try to use: INFILE "/user_data/adjdata.txt" MISSOVER DSD ; I get: NOTE: Invalid data for hourStamp in line 1 12-19. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 01/01/2010 3 321 19 timeStamp=. dateStamp=. tdate=18263 hourStamp=. adjCount=. _ERROR_=1 _N_=1
... View more
