LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 26 Feb 2002 14:21:32 -0800
Reply-To:     Shan Putnam <shan8299@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shan Putnam <shan8299@HOTMAIL.COM>
Organization: http://groups.google.com/
Subject:      exposure duration calculations
Content-Type: text/plain; charset=ISO-8859-1

Here's a good one...

I have a dataset which contains 2 dates (date1 & date2). I want to calculate an average exposure (data provided in a different dataset - dataset 2) for the duration between the 2 dates. The final dataset should have [date1 date2 avgexp1 avgexp2 avgexp3 avgexp4]

for example, date1=16jan2000 and date2= 8Aug2000, average exposure(s) (exp1 exp2 exp3 exp4) would be.. (82.6667 + 80.8333+ ....67.3333)/8

dataset 1 date1 date2 AVGEXP1 AVEEXP2 01/16/00 08/15/00 (82.6667 + 80.8333+ ....67.3333)/8 07/23/00 08/15/00 (74.5833 + 67.333)/2 06/30/00 12/15/00 etc... 07/14/00 12/15/00

dataset 2 month exp1 exp2 exp3 exp4 01/15/00 82.6667 50.0000 63.8333 53.0833 02/15/00 80.8333 49.2500 62.2500 51.9167 03/15/00 80.7500 48.9167 63.0833 51.7500 04/15/00 80.5833 49.5833 63.0000 51.9167 05/15/00 80.0000 50.0833 63.3333 51.7500 06/15/00 79.2500 47.0000 61.2500 49.2500 07/15/00 74.5833 43.9167 58.0833 44.6667 08/15/00 67.3333 38.3333 51.6667 38.9167 09/15/00 70.0000 39.4167 54.3333 38.9167 10/15/00 67.5833 37.6667 53.0000 38.8333 11/15/00 64.4167 37.2500 53.8333 40.1667 12/15/00 64.1667 36.5000 53.8333 40.0000

thanks

Shan


Back to: Top of message | Previous page | Main SAS-L page