Wrapping long row headers in tabulate

BruceBrad — Fri, 10 Oct 2014 05:38:29 GMT

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.

Re: Wrapping long row headers in tabulate

BrunoMueller — Fri, 10 Oct 2014 12:11:16 GMT

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;

topic Wrapping long row headers in tabulate in SAS Procedures

Wrapping long row headers in tabulate

Re: Wrapping long row headers in tabulate