Date:         Tue, 13 Apr 2004 12:23:59 -0400
Reply-To:     harry.droogendyk@RBC.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Harry Droogendyk <harry.droogendyk@RBC.COM>
Subject:      Re: summery of only one variable
Content-Type: text/plain; charset=iso-8859-1

Presumably the means are to be by hour within date?  If not, drop the
references to datestamp

data a;
  do datestamp = '20jan2004'd to '25jan2004'd ;
      do timestamp = '00:00:00't to '23:59:59't;
         count = floor(ranuni(1)*100);
             output;
          end;
  end;
run;

proc summary data=a ;
  by datestamp timestamp;
  var count ;
  output out=summarized ( drop = _: ) mean=Average_Count;
  format datestamp yymmdds10.
         timestamp hour.;
run;

proc print data=summarized;
run;


 -----Original Message-----
From:   vickey [mailto:vickey_d@REDIFFMAIL.COM]
Sent:   Tuesday, April 13, 2004 11:46 AM
To:     SAS-L@LISTSERV.UGA.EDU
Subject:        summery of only one variable

Hi friends!

I am in trouble&#8230;
I have a dataset having only one variable but the dataset is very big.
Actually it is an observation taken at every second so number of
observation is (60x60x24x7=60,280)
Now we need a summery report which shows only the mean of the
observation taken in an hour (3600).
That is now the new table will be having only (60x24x7) observations.
Can we do that without using the macro, and by using some statistical
procedure.

Thank you
vickey

------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying of
this e-mail or the information it contains by other than an intended recipient
is unauthorized. If you received this e-mail in error, please advise me (by
return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce
pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation
ou copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez
ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par
retour de courrier électronique ou par un autre moyen.

============================================================