Adding a sum to the top of dataset

[CDR]

Hi

I'm trying to add a sum to my data set. I want it to be in the first line - just under the lables.

I have:

                   Num1       Num2

name1             12           10

name1              8             6

name1              9            11

I want:

                   Num1       Num2

Total                29           27

name1             12           10

name1              8             6

name1              9            11

Thanks in advance 🙂

/Christine

[RW9 · Accepted solution]

proc sql;
  create table WANT as 
  select  "Total" as NAME,
          sum(NUM1) as NUM1,
          sum(NUM2) as NUM2
  from    HAVE
  union all
  select  NAME,
          NUM1,
          NUM2
  from    HAVE;
quit;

[andreas_lds]

Do you want the sums in a dataset or report?

Proc report and proc tabulate allow sum-rows before and after details-rows.

proc tabulate data=sashelp.class;    
   var height weight;
   class sex / order=unformatted missing;
   table 
      all={label="Total"} sex='',
      height weight
   ;
   keylabel sum= ' ';
run;