topic Re: Do mean calculation based on 2nd data time range in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/Do-mean-calculation-based-on-2nd-data-time-range/m-p/12239#M170 You could solve this programmatically by<BR /> <BR /> a) putting DATA1 into a hash with TIME as key<BR /> b) iterate over DATA2 using both time values to find the relevant hash elements and doing the mean calculation<BR /> <BR /> Others having SAS at their hands might chime in with some ready-to-use code.<BR /> <BR /> (Note that this solution largely depends on the size of DATA1. If it is a very big dataset consider defining/using DATA1 as a dataset indexed on TIME). Wed, 06 Oct 2010 08:41:45 GMT Robert_Bardos 2010-10-06T08:41:45Z Do mean calculation based on 2nd data time range https://communities.sas.com/t5/Statistical-Procedures/Do-mean-calculation-based-on-2nd-data-time-range/m-p/12238#M169 Data1<BR /> <BR /> time x y<BR /> 11:00 2 3 <BR /> 11:03 4 5<BR /> 11:07 10 30<BR /> 12:00 30 20<BR /> 12:03 21 4<BR /> ..............<BR /> <BR /> Data2<BR /> TimeStart TimeEnd<BR /> 11:00 11:07<BR /> 11:03 12:00<BR /> 12:00 12:03<BR /> ....................<BR /> <BR /> Want to get results<BR /> TimeStart TimeEnd MeanX meanY<BR /> 11:00 11:07 ? ?<BR /> 11:03 12:00 ? ?<BR /> 12:00 12:03 ? ?<BR /> ............................ Tue, 05 Oct 2010 19:10:31 GMT https://communities.sas.com/t5/Statistical-Procedures/Do-mean-calculation-based-on-2nd-data-time-range/m-p/12238#M169 JeffNCSU 2010-10-05T19:10:31Z Re: Do mean calculation based on 2nd data time range https://communities.sas.com/t5/Statistical-Procedures/Do-mean-calculation-based-on-2nd-data-time-range/m-p/12239#M170 You could solve this programmatically by<BR /> <BR /> a) putting DATA1 into a hash with TIME as key<BR /> b) iterate over DATA2 using both time values to find the relevant hash elements and doing the mean calculation<BR /> <BR /> Others having SAS at their hands might chime in with some ready-to-use code.<BR /> <BR /> (Note that this solution largely depends on the size of DATA1. If it is a very big dataset consider defining/using DATA1 as a dataset indexed on TIME). Wed, 06 Oct 2010 08:41:45 GMT https://communities.sas.com/t5/Statistical-Procedures/Do-mean-calculation-based-on-2nd-data-time-range/m-p/12239#M170 Robert_Bardos 2010-10-06T08:41:45Z