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.
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
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
Thanks a lot Cynthia.It worked.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.