JeffNcsu
sorry you didn't understand:
examples you can find in the manual
examples you can find in online-doc
what you got with my posting was the sql you need
(apart from the top and tail
proc sql ;
create table results as
Select TimeStart, TimeEnd, mean(x) as meanX, mean(y) as meanY
from data1 a, data2 b
where a.time between TimeStart and TimeEnd
Group by TimeStart, TimeEnd
;
quit ;
That produced these work.RESULTS, based on your sample data[pre]+FSVIEW: WORK.RESULTS (B)-------------------------------+
| Obs TimeStart TimeEnd meanX meanY |
| |
| 1 11:00 11:07 5.75 11.5 |
| 2 11:03 12:00 14.666666667 18.333333333 |
| 3 12:00 12:03 25.5 12 |
| |
+--------------------------------------------------------+[/pre]since these are the results you seemed to be asking for, it is a bit disappointed you didn't try
peterC