SAS cannot read file cannot read properly the data

Question

The imported data is full value,but in coding there,it will eat one character.Example that my data is RM800-RM1201,but the output just only RM800-RM120.The Data file format is xlsx

DATA WANT;
    SET WORK.IMPORT2;
    WHERE SHOEPURCHASEMETHOD = "Online";
RUN;

Answer 1

Try setting

guessingrows=MAX;

in proc import.