11-29-2016 08:15 PM
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.
PROC IMPORT DATAFILE="D:\Book1.xlsx"
dbms=excel replace out=mydata;
11-30-2016 03:13 AM
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.
11-30-2016 04:46 AM
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;