topic How to create a dataset whose last row is summation of specified variables? in SAS Procedures

How to create a dataset whose last row is summation of specified variables?

George_S — Mon, 16 Apr 2012 20:40:07 GMT

I prefer this could be done by using proc report,

Thanks a lot!

data have;

input x y;

cards;

1 2

1 1

5 2

0 3

3 1

1 3

0 1

6 5

1 0

4 2

1 4

0 1

;

data want(in SAS or excel format )

1 2

1 1

5 2

0 3

3 1

1 3

0 1

6 5

1 0

4 2

1 4

0 1

Re: How to create a dataset whose last row is summation of specified variables?

FriedEgg — Mon, 16 Apr 2012 20:51:03 GMT

filename tmp temp;

ods tagsets.excelxp file=tmp style=minimal;

data have;

input x y;

cards;

1 2

1 1

5 2

0 3

3 1

1 3

0 1

6 5

1 0

4 2

1 4

0 1

;

run;

proc print data=have noobs;

var x y;

sum y;

run;

Re: How to create a dataset whose last row is summation of specified variables?

rtritz — Mon, 16 Apr 2012 21:44:58 GMT

Hi George S.,

Below is some very basic proc report code to do what you asked.

data have;

input x y;

cards;

1 2

1 1

5 2

0 3

3 1

1 3

0 1

6 5

1 0

4 2

1 4

0 1

;

proc report data = have nowd out=want(drop=_:);

columns x y;

define x / display;

define y / analysis;

rbreak after / summarize;

run;

Re: How to create a dataset whose last row is summation of specified variables?

FriedEgg — Mon, 16 Apr 2012 21:49:34 GMT

I somehow missed the desire to use proc report. My mistake.