I don't know why this isn't working. Is seems to be related to the delimiter. If I change the delimiter to something else, it works fine. I'd really like to get this working for tab delimited records. Am I missing something?
This works fine:
[pre]
data filelist;
infile cards dlm='#';
input Size :comma8. FileName :$50.;
cards;
123,345#C:\GFF\Denver File.txt
54,332,000#d:\FTR\Mars File.pdf
;
run;
[/pre]
This doesn't:
[pre]
data filelist;
infile cards dlm='09'X;
input Size :comma8. FileName :$50.;
cards;
123,345 C:\GFF\Denver File.txt
54,332,000 d:\FTR\Mars File.pdf
;
run;
[/pre]
This is the error I get:
[pre]
NOTE: Invalid data for Size in line 460 1-80.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
461 54332 d:\FTR\Mars File.pdf
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Size=. FileName=54332 d:\FTR\Mars File.pdf _ERROR_=1 _N_=1
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.FILELIST has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
[/pre]