topic Re: AVG Function in SAS Programming

AVG Function

parmis — Tue, 05 Feb 2019 20:19:56 GMT

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:

what I'm trying to get:

Thanks!

PaigeMiller — Tue, 05 Feb 2019 20:21:39 GMT

PROC MEANS/PROC SUMMARY

Example:

novinosrin — Tue, 05 Feb 2019 20:23:41 GMT

proc sql;

create table want as

select id, avg(amount) as average

from have

group by id;

quit;