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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1537 views
  • 0 likes
  • 3 in conversation