topic Re: Proc report : How can i display column name in 90 degree angle by using proc report? in ODS and Base Reporting

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

dhrums28 — Wed, 01 Mar 2017 22:32:25 GMT

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

MichaelLarsen — Thu, 02 Mar 2017 12:14:31 GMT

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;

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

Cynthia_sas — Thu, 02 Mar 2017 15:29:55 GMT

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