SAS Import xlsx file

[scb]

I tried to import the attached xlsx file; in the HOLNO column, most of the data were imported except the last row which is in character format. 

I would like to import the HOLNO column as character format wihout modifying the excel file. 

Anyone can help? Thanks.

My code:

PROC IMPORT DATAFILE="D:\Book1.xlsx"
dbms=excel replace out=mydata;
GETNAMES=yes;
RUN;

[Jagadishkatam]

Please try mixed = yes option

PROC IMPORT DATAFILE="D:\Book1.xlsx"
dbms=excel replace out=mydata;
GETNAMES=yes;
MIXED=yes;
RUN;

[scb]

I have tried but still got the same answer.

[Kurt_Bremser]

Export to a csv file from Excel and write a data step to read that; that way you have full control over the variables and are not subject to the idiosyncrasies of the Excel file format and the guessing of proc import.

[Ksharp]

Add MIXED='yes' ;  option

Or not sure if the following could work.

libname xx excel "/folders/myfolders/Book1.xlsx";
data have;
set xx.'Sheet1'n(dbsastype=(holno='char(100)'));
RUN;