BookmarkSubscribeRSS Feed
2 REPLIES 2
MichaelLarsen
SAS Employee

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;
Cynthia_sas
SAS Super FREQ

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

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1362 views
  • 0 likes
  • 3 in conversation