Date: Tue, 4 Jul 2006 21:25:32 -0400
Reply-To: Kijoeng Nam <kijoeng@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Kijoeng Nam <kijoeng@GMAIL.COM>
Subject: Programming Help (sum of every two row's)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi,
I have following data set.
03/23/2006 00:00:00 0 03/24/2006 00:00:00 29 03/25/2006 00:00:00 0
03/23/2006 00:00:30 0 03/24/2006 00:00:30 36 03/25/2006 00:00:30 0
03/23/2006 00:01:00 0 03/24/2006 00:01:00 23 03/25/2006 00:01:00 0
03/23/2006 00:01:30 0 03/24/2006 00:01:30 24 03/25/2006 00:01:30 0
03/23/2006 00:02:00 0 03/24/2006 00:02:00 768 03/25/2006 00:02:00 0
03/23/2006 00:02:30 56 03/24/2006 00:02:30 280 03/25/2006 00:02:30 0
03/23/2006 00:03:00 0 03/24/2006 00:03:00 34 03/25/2006 00:03:00 0
03/23/2006 00:03:30 0 03/24/2006 00:03:30 0 03/25/2006 00:03:30 0
03/23/2006 00:04:00 0 03/24/2006 00:04:00 0 03/25/2006 00:04:00 0
03/23/2006 00:04:30 0 03/24/2006 00:04:30 0 03/25/2006 00:04:30 0
03/23/2006 00:05:00 0 03/24/2006 00:05:00 0 03/25/2006 00:05:00 0
03/23/2006 00:05:30 0 03/24/2006 00:05:30 0 03/25/2006 00:05:30 0
03/23/2006 00:06:00 0 03/24/2006 00:06:00 0 03/25/2006 00:06:00 0
03/23/2006 00:06:30 0 03/24/2006 00:06:30 0 03/25/2006 00:06:30 0
03/23/2006 00:07:00 0 03/24/2006 00:07:00 0 03/25/2006 00:07:00 0
03/23/2006 00:07:30 0 03/24/2006 00:07:30 0 03/25/2006 00:07:30 0
03/23/2006 00:08:00 0 03/24/2006 00:08:00 0 03/25/2006 00:08:00 0
03/23/2006 00:08:30 0 03/24/2006 00:08:30 0 03/25/2006 00:08:30 0
you will find that the first column is the day/time, the
second column is the score.
I'd like to compute the total score of every two rows - which is the total
of every minute
(each row's score was obtained in 30 seconds, that's why two
rows are one minute).
How can I do this?
Thanks in advance.
|