EXCEL LIBNAME option and DBMAX_TEXT not working as expected

[LawrenceHW]

Hi,

I am trying to read in an Excel workbook using the LIBNAME statement with the EXCEL option. This normally works just fine but one of the columns in my workbook contain data >1024 in length. So I used the DBMAX_TEXT option to increase the available size of the data imported and when I run a PROC CONTENTS the variable (Body) shows up as a Character of length 5494.

However when I try to use this dataset (proc print or via a data step) I get the warning in the log: 

WARNING: During read: Data truncated for column Body

Has anyone else managed to successfully use this option?

I'm running SAS v9.4 TS4 on a Grid using EG (and Studio) to run programs.

Cheers,

Lawrence

[Kurt_Bremser]

Save to a csv file and use proc import once with guessingrows=max to determine the needed size for the column. Then use the resulting data step for future imports.

[Tom]

Did you try using the XLSX engine instead of EXCEL engine?