topic Re: Adding a sum to the top of dataset in SAS Programming

Adding a sum to the top of dataset

CDR — Mon, 18 Dec 2017 09:03:34 GMT

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

Re: Adding a sum to the top of dataset

RW9 — Mon, 18 Dec 2017 09:17:38 GMT

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;

Re: Adding a sum to the top of dataset

andreas_lds — Mon, 18 Dec 2017 09:18:02 GMT

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;