BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DME790
Pyrite | Level 9

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

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

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

3 REPLIES 3
Ksharp
Super User

Ckeck 

ods tagesets.msoffice2k_m 

DME790
Pyrite | Level 9

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

Ksharp
Super User

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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