Create SAS table header flexibly

Question

I want to create a table head for a table, replacing the orignal table head.

The table head contains two rows:

head1 = !!!SS!FAS!PPS!

head2 = !Index!!(N=30)!(N=30)!(N=30)!

Here the ! meaning column delimiter. The head1 is the first row of table head .In head1, the first and second column are blank and the content of third, fourth and fifith are SS, FAS and PPS.

The head2 is the second row of table head, the content of the first column is index; the second is blank; the third to fifth are (N-30).

I want to form the following table head: enter image description here

Answer 1

You can use ods inline styling to place a newline in a columns label (which is used for the header in output). Inline styling is introduced using a special escapechar of your choosing. Also, during output, a blank label is replaced with the column name, so use a hard-space character (A0) to force a blank header.

data have;
  index = 1;
  blank = ' ';
  ss = 1;
  fas = 2;
  pps = 3;
run;

ods escapechar='^';

proc print noobs data=have label;
  var index blank ss fas pps blank;
  label 
    index = '^nIndex'
    blank = '0A'x
    ss = 'SS^n(N=30)'
    fas = 'FAS^n(N=30)'
    pps = 'PPS^n(N=30)'
  ;
run;