topic rotate column headers in ods pdf in SAS Programming

rotate column headers in ods pdf

Cristina_inet — Fri, 11 Aug 2023 11:05:23 GMT

hello everyone,
we are generating an ods pdf with tables. the tables have been generated with proc report and proc tabulate. we need this only for some tables, for others it is not necessary.
We need to rotate the column headers as follows:

now it is appearing like this:

How could it be done?

Thank you very much and greetings

Re: rotate column headers in ods pdf

Ksharp — Fri, 11 Aug 2023 12:05:03 GMT

Here is for Excel file,NOT pdf.

While mayb @Cynthia_sas knew the solution.

https://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

Re: rotate column headers in ods pdf

Cynthia_sas — Fri, 11 Aug 2023 19:29:33 GMT

Hi:

I do not know whether it is possible to use ODS Excel or ODS Word techniques to get rotated headers in a PDF output file. You may not be able to do this directly with ODS PDF, but may have to create your document and then use a different tool, such as print to PDF functionality to make it work. For example, with SAS out of the picture, if I generate THIS file in Microsoft Word (with rotated headers):

And then from inside Word, I do a Save AS PDF:

Then when I open the PDF file, I see that the rotated headers were retained in the PDF format:

So I would think that it might be possible to create an Excel or Word document using ODS and then from inside Excel or Word, do a SAVE AS PDF. In order to rotate the headers, you'd have to refer to the link that was posted or work with Tech Support.

Over time, I have stopped using rotated headers because reading software will not always read the headers correctly when they are rotated.

Cynthia