Date:         Wed, 28 Aug 1996 10:57:56 -0500
Reply-To:     larryc@okway.okstate.edu
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Larry D. Clendenen" <larryc@OKWAY.OKSTATE.EDU>
Organization: Oklahoma State University - Department of Forestry
Subject:      Question: how to add a theoretical obs for a given time value?

I have very little experience with datastep programming and I am asking
for help.
 
I have data based on changes in streamflow and not time.
 
ws   flow (cfs)       datetime
 
1     10.00        25SEP1979:22:00:00
1     14.00        26SEP1979:00:01:00
 
I would like to have..
 
1     10.00        25SEP1979:22:00:00
1     12.67        26SEP1979:00:00:00
1     14.00        26SEP1979:00:01:00
 
Specifically, I would like to have an additional observation at 0:00:00
time.
 
I need to have the change in flow from the last observation of a day to
the first observation of the next day divided by the change in time.
(sometimes positive sometimes negative)  This would give average flow
per time unit that could then be multiplied by the time to or from
0:00:00 to give the theoretical average flow at 0:00:00.
 
I am having trouble getting started with this task.  I would greatly
appreciate any pointers to the solution.
 
Additionally my data are in Excel as a date mmddyy8. And time in hours
and tenths of hours.  I could not find an informat in SAS to handle the
tenths of hours.  I had to format the time in Excel to hhmmss8. Then
infile and create the datetime20.
 
Advice on this would also be appreciated.
 
Thanks
 
     -Larry
 
larryc@okway.okstate.edu