Column Width Formatting in Proc Export to Excel

jenwork — Wed, 02 Jun 2010 18:11:39 GMT

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

Re: Column Width Formatting in Proc Export to Excel

Peter_C — Wed, 02 Jun 2010 18:56:32 GMT

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

topic Re: Column Width Formatting in Proc Export to Excel in SAS Procedures

Column Width Formatting in Proc Export to Excel

Re: Column Width Formatting in Proc Export to Excel