Simple Question: Proc Export dbmax_text

Reply
Super Contributor
Posts: 418

Simple Question: Proc Export dbmax_text

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

Super Contributor
Posts: 418

Re: Simple Question: Proc Export dbmax_text

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

Ask a Question
Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 1 in conversation