Hello all. Sorry for the simple question, but I can't for the life of me remember the option, and searching online has been un-helpful this far.
When you export a dataset to Excel from within sas, it will truncate your character values to 1024 (which is the default dbmax_text setting). I know there is a way to increase this setting, however I cannot remember where you specify the option.
If I remember correctly, I believe you use text_size, or something similar within proc export itself, but that does not seem to be working.
If anyone can help, it would be appreciated!
Brandon
Does anyone know if there is a global option I can specify to not truncate character columns at 1024 when exporting to excel?
If so I can also specify that option right before the read in!
Thanks
dbmax_text= can be used in a libname statement using an excel engine when reading data from an excel file.
libname demo excel '.../myexcelfile.xlsx' dbmax_text=3000;
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: