topic Re: How can I calculate the result of the sum of a column /3 in SAS Programming

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

Siennayun — Sun, 07 Jun 2020 00:48:13 GMT

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

data a;

input c e;

datalines;

3 2

4 2

5 3;
Run;

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

Shmuel — Sun, 07 Jun 2020 02:40:13 GMT

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;

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

Siennayun — Sun, 07 Jun 2020 02:45:45 GMT

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

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

ghosh — Sun, 07 Jun 2020 03:15:03 GMT

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;

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

Shmuel — Sun, 07 Jun 2020 04:57:00 GMT

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

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

Ksharp — Mon, 08 Jun 2020 10:49:19 GMT

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;

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

andreas_lds — Sun, 07 Jun 2020 16:03:28 GMT

@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?

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

ballardw — Sun, 07 Jun 2020 18:13:20 GMT

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.

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

PaigeMiller — Sun, 07 Jun 2020 19:24:31 GMT

@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)?