02-14-2013 02:16 PM
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!
02-26-2013 01:35 PM
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!