topic Re: how to calculate average in data step block in SAS Programming

how to calculate average in data step block

thanikondharish — Tue, 14 Aug 2018 11:19:17 GMT

data s ;
input a1-a3 ;
cards ;
5 10 5
10 20 10
;

proc sql ;
select avg(a1) as average from s ;
quit;

proc sql ;
select avg(of a1-a3) as average from s ;
quit;

by using proc sql i got average either column wise or row wise .

how to calculate average in datastep block?

Re: how to calculate average in data step block

andreas_lds — Tue, 14 Aug 2018 11:50:54 GMT

@thanikondharish wrote:

data s ;
input a1-a3 ;
cards ;
5 10 5
10 20 10
;

proc sql ;
select avg(a1) as average from s ;
quit;

or

proc sql ;
select avg(of a1-a3) as average from s ;
quit;

by using proc sql i got average either column wise or row wise .

how to calculate average in datastep block?

The syntax for calculating row-wise average is not that different from the proc sql code. If you need to calculate column-wise average, using proc summary is most-times more efficient.

Re: how to calculate average in data step block

thanikondharish — Tue, 14 Aug 2018 13:01:22 GMT

proc summary gives mean value.

there is difference between average and mean value i think so.
is there any difference between average and mean value?

Re: how to calculate average in data step block

andreas_lds — Tue, 14 Aug 2018 13:19:23 GMT

At least in FedSQL functions avg and mean are the same:

Re: how to calculate average in data step block

ballardw — Tue, 14 Aug 2018 14:49:14 GMT

@thanikondharish wrote:
proc summary gives mean value.

there is difference between average and mean value i think so.
is there any difference between average and mean value?

Only difference in general is spelling and how pedantic some users may be for vocabulary choices. Some uses of "average" have an interpretation of "typical" but in calculations average=mean for SAS. Of course "mean" can be used for "unkind".

Unless you are discussing geometric mean compared to arithmetic mean.

Re: how to calculate average in data step block

Reeza — Tue, 14 Aug 2018 14:58:17 GMT

@thanikondharish wrote:

is there any difference between average and mean value?

NO.