topic Re: Orientation of the words in a Proc Tabulate Heading in SAS Enterprise Guide

Orientation of the words in a Proc Tabulate Heading

DME790 — Thu, 09 Nov 2017 05:04:19 GMT

Hi All,

I have a proc tabulate that has long names as the headers. I want to change the orientation of the words to be vertical in the header so the table fits to one page and is easier to read.

Proc Tabulate data=work.warra_trans_vq format=comma.;
	Class origin_cd target_cd;
	VAR TRANSFER_CNT;

	Table
		Origin_CD = " " All = " "
		,Target_CD = "Target" * transfer_cnt=" " 
		/Box="Transfers"
	;
		Keylabel SUM=" ";
Run;

Current output looks like this:

Required output:

Cheers

Dean

Re: Orientation of the words in a Proc Tabulate Heading

Ksharp — Thu, 09 Nov 2017 12:26:59 GMT

Ckeck

ods tagesets.msoffice2k_m

Re: Orientation of the words in a Proc Tabulate Heading

DME790 — Tue, 05 Dec 2017 00:49:23 GMT

Hi @Ksharp

Still working on this one. Seems in a proc tabulate there is no style to rotate the heading text.

I can't seem to find anything within ods tagesets.msoffice2k_m that helps me either.

Any other suggestions?

Cheers

Dean

Re: Orientation of the words in a Proc Tabulate Heading

Ksharp — Tue, 05 Dec 2017 12:35:38 GMT

Yes. It doesn't work for PROC TABULATE ,but work for PROC REPORT .

You can find the detail info about tagset.msoffic2k at support.sas.com

Or Calling @Reeza