topic Re: Recreate Table with Grouping Months and Average Price in New SAS User

Recreate Table with Grouping Months and Average Price

vitalam89 — Wed, 14 Aug 2019 11:02:11 GMT

New to SAS.

I currently need to summarize some data and know what is the average price of each month.

I have data like this:

Date / Price

19-05-23 50

19-05-23 80

19-05-24 50

19-05-25 ..........cont.

I would like to have a dataset like this:

Month / Average Price

May 2019 70

Jun 2019 90 ....

Please help! A million thanks!!

Re: Recreate Table with Grouping Months and Average Price

PeterClemmensen — Wed, 14 Aug 2019 11:12:20 GMT

Welcome to the SAS Community 🙂

Do something like this

data have;
input date :date9. price;
format dates date9.;
cards;
01jul1994 10
02may1995 15
10may1995 20
16jun1995 25
28jun1995 30
;

proc summary data=have nway;
  class date;
  format date monyy7.;
  var price;
  output out=want(drop=_TYPE_ _FREQ_) mean=;
run;

Re: Recreate Table with Grouping Months and Average Price

novinosrin — Wed, 14 Aug 2019 11:52:06 GMT

Hi @vitalam89

SQL is very simple too


data have;
input date :date9. price;
format date date9.;
cards;
01jul1994 10
02may1995 15
10may1995 20
16jun1995 25
28jun1995 30
;

proc sql;
create table want as
select put(date,monyy7.) as Month_year, avg(price) as Average_price
from have
group by Month_year;
quit;

Re: Recreate Table with Grouping Months and Average Price

vitalam89 — Wed, 14 Aug 2019 12:11:46 GMT

Thank you very much!

Re: Recreate Table with Grouping Months and Average Price

vitalam89 — Wed, 14 Aug 2019 12:12:11 GMT

thank you very much!