Vertical column names in Excel report

[jshaik]

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.

[Cynthia_sas · Accepted solution]

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

[jshaik]

Thanks a lot Cynthia.It worked.