I am trying to write an INFILE statement in SAS that can read the data below. I was able to read this exact data without the commas in the last column. How do I incorporate that there is a comma into my code? Here is what I have tried.
data m2_d1;
INFILE '/home/u62211166/STAT674/M2/m2_d1.txt';
INPUT Car $ 1-9 Location $ 11-22 Type $ 24-28 Number 30-32;
RUN;
Sample data:
Dodge Philadelphia truck 1,491
Dodge Philadelphia car 1,840
Dodge Philadelphia SUV 8,759
Ford Wilmington truck 1,270
Ford Wilmington car 3,934
Ford Wilmington SUV 873
Ford Camden truck 4,016
Ford Camden car 5,714
Ford Camden SUV 1,996
Chevrolet Philadelphia truck 1,140
Chevrolet Philadelphia car 4,276
Chevrolet Philadelphia SUV 1,984
Toyota Wilmington truck 1,807
Toyota Wilmington car 699
Toyota Wilmington SUV 1,722

