https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-export-data-to-excel/m-p/245448#M17441 <P>I am using SAS enterprise guide to export a dataset into excel. however the columns are wrapped to fit&nbsp;'column name's' length showing data values as ###,</P> <P>&nbsp;</P> <P>obviously our users can manually expand column length. I wonder if there is a simple way to fix this.</P> <P>&nbsp;</P> <P>Tried creating a column alias with a lot of empty spaces to expand the length but the effort proved futile</P> Fri, 22 Jan 2016 14:53:22 GMT arunmmw 2016-01-22T14:53:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-export-data-to-excel/m-p/245448#M17441 <P>I am using SAS enterprise guide to export a dataset into excel. however the columns are wrapped to fit&nbsp;'column name's' length showing data values as ###,</P> <P>&nbsp;</P> <P>obviously our users can manually expand column length. I wonder if there is a simple way to fix this.</P> <P>&nbsp;</P> <P>Tried creating a column alias with a lot of empty spaces to expand the length but the effort proved futile</P> Fri, 22 Jan 2016 14:53:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-export-data-to-excel/m-p/245448#M17441 arunmmw 2016-01-22T14:53:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-export-data-to-excel/m-p/245451#M17442 <P>Quite possibly its using proc export behind the scenes. &nbsp;If you want nice output to Excel use ods tagsets.excelxp and proc report to generate XML output which can be interpreted in Excel. &nbsp;Whats the output used for? &nbsp;If its data transfer, I would suggest CSV, XML etc. &nbsp;For review purposes, the above ods tagset, or PDF/RTF etc.</P> Fri, 22 Jan 2016 15:01:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-export-data-to-excel/m-p/245451#M17442 RW9 2016-01-22T15:01:07Z