Simple Question: Proc Export dbmax_text

[Anotherdream]

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

[Anotherdream]

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

[xxformat_com]

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;