topic Vertical column names in Excel report in ODS and Base Reporting

Vertical column names in Excel report

jshaik — Mon, 02 Apr 2012 19:22:04 GMT

Hi All,

I came across a requirement where orientation of the columns in the excel report should be -90 degrees.I was wondering if there is an option in proc report (I am using ODS and MSOFFICE2k tagset) for that.Below screenshot might help you in understanding what I am referring to.

Thanks in advance.

Re: Vertical column names in Excel report

Cynthia_sas — Mon, 02 Apr 2012 23:27:31 GMT

Hi:

I believe that the MSOFFICE2K_X tagset (NOT MSOFFICE2K) offers you a sub-option to rotate the column headers. It is not something that happens within PROC REPORT...you specify rotated headers in a sub-option like this:

ods tagsets.msoffice2k_x file="c:\temp\rotate.xls" style=normal

options( rotate_headers="45"

height="60" );

For information about using TAGSETS.MSOFFICE2K_X and to download the newest tagset template, visit this web site. The information shows how to ask for rotated headers.

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#intro

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#rotate

cynthia

Re: Vertical column names in Excel report

jshaik — Fri, 06 Apr 2012 21:03:18 GMT

Thanks a lot Cynthia.It worked.