title: Merge cells horizontally in RTF output using proc report
body: <p>I am trying to create a summary row above each group in my data. I have 2 questions:</p>
  
  <ol>
  <li>How do I merge the first 2 cells horizontally (the ones in red below) in the summary rows. </li>
  <li>How do I remove the duplicated F and M in the Sex column (at the moment I can work around this by changing only those cell's text colours to white, but hopefully there's a better way)</li>
  </ol>
  
  <p>The output is an RTF file, and I'm using SAS 9.4 - the desktop version.</p>
  
  <p>Is this possible using proc report?</p>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>options missing=' ';
  proc report data=sashelp.class nowd;
      columns sex name age weight;
      define sex / order;
      break before sex / summarize;
  run;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/HLdeQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HLdeQ.png" alt="enter image description here"></a></p>