Help using Base SAS procedures

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

Reply
Contributor
Posts: 35

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

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

Trusted Advisor
Posts: 1,300

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

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;

Contributor
Posts: 23

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

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=_Smiley Happy

columns x y; 

define x / display; 

define y / analysis; 

rbreak after / summarize;

run;

Trusted Advisor
Posts: 1,300

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 174 views
  • 0 likes
  • 3 in conversation