I'm importing this data and there's supposed to be 1 error in there, but I'm getting 2. data CarVROOM;
infile "E:\...VROOM.txt" firstobs=9 missover;
input Manufacturer$ Model$ Type$ Min_Price Price Max_Price MPG_city MPG_highway DriveTrain$ Cylinders;
run; This is the log report: NOTE: Invalid data for Cylinders in line 70 45-50.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9--
70 Mazda RX-7 Sporty 32.5 32.5 32.5 17 25 Rear rotary 50
Manufacturer=Mazda Model=RX-7 Type=Sporty Min_Price=32.5 Price=32.5 Max_Price=32.5 MPG_city=17
MPG_highway=25 DriveTrain=Rear Cylinders=. _ERROR_=1 _N_=57
NOTE: Invalid data for MPG_highway in line 93 36-38.
93 Subaru Justy Small 7.3 8.4 9.5 33 4WD 3 40
Manufacturer=Subaru Model=Justy Type=Small Min_Price=7.3 Price=8.4 Max_Price=9.5 MPG_city=33
MPG_highway=. DriveTrain=3 Cylinders=. _ERROR_=1 _N_=80 It looks like the errors are to do with the values being "." instead of numbers in the dataset, are there any options to add to the infile statement to reduce one of these errors?
... View more