topic EXCEL LIBNAME option and DBMAX_TEXT not working as expected in SAS Programming

EXCEL LIBNAME option and DBMAX_TEXT not working as expected

LawrenceHW — Thu, 01 Mar 2018 13:25:02 GMT

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

Re: EXCEL LIBNAME option and DBMAX_TEXT not working as expected

Kurt_Bremser — Thu, 01 Mar 2018 13:46:52 GMT

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.

Re: EXCEL LIBNAME option and DBMAX_TEXT not working as expected

Tom — Thu, 01 Mar 2018 13:54:52 GMT

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