How can I calculate the result of the sum of a column /3

[Siennayun]

How can I get a result of the sum(c)/3



data a;

input c e;

datalines;

3 2

4 2

5 3;
Run;

[Shmuel]

Why do you divide the sum into 3 ? 

Do you want to compute the mean value of C ?

If positive  - use proc means:

proc means data=a;
 class;
 var a;
run;

[Siennayun]

I understand that I can use
proc means a sum;
Variable;
To get the sum,
But how can I get the Sum(c)/3 ?

[ghosh · Accepted solution]

data want;
	set a end=eof;
	retain cc;
	if _n_=1 then
		cc=c;
	else
		cc+c;
	if eof then
		sum_c=cc/_N_;
Run;

[Shmuel]

proc means data=a;
 class;
 var a;
 output out=want mean=new_var;
run;

[PaigeMiller]

---

@Siennayun wrote:
I understand that I can use
proc means a sum;
Variable;
To get the sum,
But how can I get the Sum(c)/3 ?

---

Always divide the sum by 3? Or divide by 3 because there are three observations (and so you would always divide by the number of non missing values)?

[Ksharp]

data a;
input c e;
datalines;
3 2
4 2
5 3
;
Run;
proc sql;
select sum(c)/count(c) as x from a;
quit;

[andreas_lds]

---

@Siennayun wrote:
How can I get a result of the sum(c)/3



data a;

input c e;

datalines;

3 2

4 2

5 3;
Run;

---

please post what you expect as result. What should happen to variable e?

[ballardw]

Please show exactly how you want the output data set to appear.

And do something about all of the extra blank rows in your code. Easiest to copy code from your SAS editor and paste into a code box on the forum that is opened with the </> or "running man" icon. Anything else is likely to have the forum windows reformat text removing spaces and inserting html tags that make for ugly code.