The SAS Output Delivery System and reporting techniques

Vertical column names in Excel report

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Vertical column names in Excel report

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.vertical.bmp


Accepted Solutions
Solution
‎04-02-2012 07:27 PM
SAS Super FREQ
Posts: 8,864

Re: Vertical column names in Excel report

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

View solution in original post


All Replies
Solution
‎04-02-2012 07:27 PM
SAS Super FREQ
Posts: 8,864

Re: Vertical column names in Excel report

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

Occasional Contributor
Posts: 14

Re: Vertical column names in Excel report

Posted in reply to Cynthia_sas

Thanks a lot Cynthia.It worked.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 562 views
  • 0 likes
  • 2 in conversation