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
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.
Did you try using the XLSX engine instead of EXCEL engine?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.