The SAS Output Delivery System and reporting techniques

Proc report : How can i display column name in 90 degree angle by using proc report?

Reply
New Contributor
Posts: 2

Proc report : How can i display column name in 90 degree angle by using proc report?

 
SAS Employee
Posts: 20

Re: Proc report : How can i display column name in 90 degree angle by using proc report?

The only way I can think of is to use the SPLIT= option and then insert the split character into the column headers.

Example:

proc report data=sashelp.class nowd split='*';
  column name age height;
	define name / order 'N*a*m*e';
	define age / 'A*g*e' format=3.;
	define height / 'H*e*i*g*h*t' format=8.2 ;
quit;
SAS Super FREQ
Posts: 8,645

Re: Proc report : How can i display column name in 90 degree angle by using proc report?

Hi:

  Using SPLIT with PROC REPORT will work. PROC PRINT has an option that does the equivalent automatically, without using SPLIT.

 

  However, the challenge with this approach is that for vision-impaired people who use a screen reader, putting a line feed between every character in a header causes the header to be read incorrectly. So you have to be very sure of your audience and whether they need assistive technology before you use this approach.

 

  Some destinations will support rotation for output like Excel: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/#rotate showing rotated headers for MSOFFICE2K_X. and the new ODS EXCEL supports rotate with TAGATTR, as shown here: https://support.sas.com/rnd/base/ods/odsmarkup/TipSheet_ods_xl_xp.pdf.

 

cynthia

Post a Question
Discussion Stats
  • 2 replies
  • 87 views
  • 0 likes
  • 3 in conversation