Help using Base SAS procedures

Column Width Formatting in Proc Export to Excel

Reply
N/A
Posts: 1

Column Width Formatting in Proc Export to Excel

Would someone please help me? I am using a PROC EXPORT to export a file to excel. But, the column widths are are using the default excel width. How do I either specify a column width or do an auto width?

PROC EXPORT DATA= WORK.temp
OUTFILE= "&output"
DBMS=EXCEL REPLACE;
SHEET="KEY";
RUN;

Thank you very much for any help!
-jen
Valued Guide
Posts: 2,174

Re: Column Width Formatting in Proc Export to Excel

probably need to use something other than proc export, as the formatting of what arrives in excel, is controlled by excel.
To control how excel formats a cell, (and there are a lot of controls .. see http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html ) you need something like ODS TAGSETS.EXCELXP. There are links to lots of examples in http://support.sas.com/rnd/base/ods/odsmarkup and a whole ODS and reporting discussion forum to search for ( EXCElxp and column_WIDTH ) at http://support.sas.com/forums/forum.jspa?forumID=6 .

good luck

peterC
Ask a Question
Discussion stats
  • 1 reply
  • 1348 views
  • 0 likes
  • 2 in conversation