Desktop productivity for business analysts and programmers

Orientation of the words in a Proc Tabulate Heading

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 130
Accepted Solution

Orientation of the words in a Proc Tabulate Heading

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:

 

 

CurrentOuput.GIF

 

Required output:

 

WantedOutput.GIF

 

 

 

 Cheers

 

Dean

 

 

 

 

 

 


Accepted Solutions
Solution
‎12-05-2017 04:36 PM
Super User
Posts: 10,860

Re: Orientation of the words in a Proc Tabulate Heading

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

View solution in original post


All Replies
Super User
Posts: 10,860

Re: Orientation of the words in a Proc Tabulate Heading

Ckeck 

ods tagesets.msoffice2k_m 

Frequent Contributor
Posts: 130

Re: Orientation of the words in a Proc Tabulate Heading

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

Solution
‎12-05-2017 04:36 PM
Super User
Posts: 10,860

Re: Orientation of the words in a Proc Tabulate Heading

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

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 163 views
  • 0 likes
  • 2 in conversation