When importing excel files how do I prevent truncation of columns?

Issue:

When importing Excel files on Windows when the following WARNING is given

"WARNING: Truncating column COMMENTS to DBMAX_TEXT(1024)".

Solution:

You can change the dbmax_text value using the DBLIBOPTS statement of PROC IMPORT, for example:

PROC IMPORT
DATAFILE="demo.xlsx"
OUT=test
DBMS=EXCEL2007
REPLACE;
SHEET="customers";
GETNAMES=YES;
DBLIBOPTS="DBMAX_TEXT=4096";
RUN;