Wrapping long row headers in tabulate

[BruceBrad]

I'm tabulating something like:

class catvar1 catvar2;

var contvar;

label contvar "A very very very very long label";

table mean*contvar*catvar1,catvar2;

Can I get the long label to wrap? I'm currently outputing to ODS RTF, where it doesn't wrap. I know that I can output to ODS markup tagset=excelXP and open the sheet up in Excel (where the labels will wrap). However, I have a lot of tables, and would prefer to go (almost) straight from SAS to a Word (or RTF) file.

[BrunoMueller · Accepted solution]

Hi

Have a go at using inline formatting, see example below:

ods escapechar="~";
proc tabulate data=sashelp.cars;
  class origin type;
  table
    type, origin
  ;
  label
    type = "Type of the cars~{NEWLINE}as specified by~{NEWLINE}the car manufacturer"
    origin = "Origin of the cars~{NEWLINE}where most parts are~{NEWLINE}made and assembled"
  ;
run;