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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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