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

[George_S]

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

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

1         3

0         1

6         5

1        0

4        2

1        4

0        1

          28

[FriedEgg]

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

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;

[rtritz]

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

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;

[FriedEgg]

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