topic How To Take The Mean Of the Days ? in SAS Programming

How To Take The Mean Of the Days ?

Midi — Mon, 28 Oct 2019 14:25:55 GMT

Hello Everyone , I have this Dataset:

regions	cities	Dates
1	FGG	25/01/1998
1	HGT	26/01/1998
1	HJK	27/01/1998
2	LOI	.
2	DCF	25/01/2001
2	VG	26/01/2001
2	BBVB	28/01/2001
3	DFR	11/07/2005
3	ZAS	12/07/2005

And What I want to do is , to take the mean of the Dates , when I have multiple Dates for the same region , like my output would be something like this :

regions	cities	Dates
1	FGG	26/01/1998
1	HGT	26/01/1998
1	HJK	26/01/1998
2	LOI	26/01/2001
2	DCF	26/01/2001
2	VG	26/01/2001
2	BBVB	26/01/2001
3	DFR	11/07/2005
3	ZAS	11/07/2005
3	EWS	16/02/2010
3	WE	16/11/2010

Any Suggestion On how to do that would be much appreciated , thank you.

Re: How To Take The Mean Of the Days ?

novinosrin — Mon, 28 Oct 2019 14:33:49 GMT



data have;
input regions	cities $	Dates :ddmmyy10.;
format dates ddmmyy10.;
cards;
1	FGG	25/01/1998
1	HGT	26/01/1998
1	HJK	27/01/1998
2	LOI	.
2	DCF	25/01/2001
2	VG	26/01/2001
2	BBVB	28/01/2001
3	DFR	11/07/2005
3	ZAS	12/07/2005
;


proc sql;
create table want1 as
select regions, cities,mean(dates) as dates format=ddmmyy10.
from have
group by regions;
quit;

Re: How To Take The Mean Of the Days ?

ballardw — Mon, 28 Oct 2019 14:32:05 GMT

First thing, is your "date" and actual SAS date value? From what you show it should be a numeric variable with format of ddmmyy10. or similar.

If not then you need to get date values and we would need to see what you have to accomplish that.

Re: How To Take The Mean Of the Days ?

Midi — Mon, 28 Oct 2019 14:34:51 GMT

In my real Dataset my dates are in Date9. Format

Re: How To Take The Mean Of the Days ?

PeterClemmensen — Mon, 28 Oct 2019 14:44:34 GMT

Your want data set has 2 obs more than your input? How does that happen?

Re: How To Take The Mean Of the Days ?

PaigeMiller — Mon, 28 Oct 2019 14:45:02 GMT

proc summary data=have;
    class regions;
    var dates;   
    output out=_means_ mean=;
urn;

Re: How To Take The Mean Of the Days ?

Midi — Mon, 28 Oct 2019 14:58:15 GMT

Thank's a Lot.