topic Simple Question: Proc Export dbmax_text in SAS Programming

Simple Question: Proc Export dbmax_text

Anotherdream — Thu, 14 Feb 2013 19:16:16 GMT

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

Re: Simple Question: Proc Export dbmax_text

Anotherdream — Tue, 26 Feb 2013 18:35:11 GMT

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

Re: Simple Question: Proc Export dbmax_text

xxformat_com — Thu, 24 Aug 2023 14:18:31 GMT

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;