Date:         Fri, 11 Nov 2005 08:41:50 -0800
Reply-To:     Peter <crawfordsoftware@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter <crawfordsoftware@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Looking for Efficient way to create hour counts based on time
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

consider
 data a /view=a ;
   set ;
   do hour = hour(st_dttm) to hour( end_dttm );
       output ;
   end;
 run;
  proc means data= a ;
    class hour ;
    var     ........... ;
    output out= counts sum= ;
  run ;
 proc print data= counts; run;