AVG Function

[parmis]

Hello,

Can anyone help me with the following?

I have the following data set and I'm trying to get the average by Id for the entire year.

dataset:

date	id	amount
jan	a1	10
jan	a2	4
jan	a3	2
feb	a1	6
feb	a2	4
feb	a3	8
march	a1	6
march	a2	5
march	a3	1

what I'm trying to get:

id	average
a1	7.3
a2	4.3
a3	3.6

Thanks!

[PaigeMiller]

PROC MEANS/PROC SUMMARY

Example:

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p070bkysj4l...

[novinosrin · Accepted solution]

proc sql;

create table want as

select id, avg(amount) as average

from have

group by id;

quit;