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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1432 views
  • 0 likes
  • 3 in conversation