title: SPSS - How to create a 'Totals' row (not a column)
body: <p>I have a dataset like this:</p>
  
  <p>Program       Timely_Count           Total_Count</p>
  
  <p>PROG1       51,761               53,356</p>
  
  <p>PROG2   232,371     235,769</p>
  
  <p>PROG3   100,756     110,859</p>
  
  <p>PROG4   25,713      36,309</p>
  
  <p>PROG5   17,985      18,995</p>
  
  <p>PROG6   24,673      24,732</p>
  
  <p>I want to create a "Total" row (not a column) so when I save this into Excel I will have a table that looks like this:</p>
  
  <p>Program Timely_Count    Total_Count</p>
  
  <p>PROG1   51,761      53,356</p>
  
  <p>PROG2   232,371     235,769</p>
  
  <p>PROG3   100,756     110,859</p>
  
  <p>PROG4   25,713      36,309</p>
  
  <p>PROG5   17,985      18,995</p>
  
  <p>PROG6   24,673      24,732</p>
  
  <p>TOTAL   453,259     480,020</p>
  
  <p>I know I can use the AGGRAGATE function to add a TOTALS column, but that does not format the dataset the way I need for this report.</p>
  
  <p>I also need this in syntax since it is run multiple times per day on multiple datasets. I have SPSS version 22. (If any of that helps.) – </p>