https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42764#M11135 Dear forum members,<BR /> <BR /> I have a data set with three columns. One is series of times. The second is a column which is mainly missing values. The third is also numeric.<BR /> <BR /> What I need to do is, for every non-missing value in the second column, create a data set with the mean value of the third column for every observation before the time of the non-missing value that is within three hours of that observation. <BR /> <BR /> Grateful for any suggestions,<BR /> <BR /> Paul J Thu, 01 Jul 2010 07:57:11 GMT deleted_user 2010-07-01T07:57:11Z https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42764#M11135 Dear forum members,<BR /> <BR /> I have a data set with three columns. One is series of times. The second is a column which is mainly missing values. The third is also numeric.<BR /> <BR /> What I need to do is, for every non-missing value in the second column, create a data set with the mean value of the third column for every observation before the time of the non-missing value that is within three hours of that observation. <BR /> <BR /> Grateful for any suggestions,<BR /> <BR /> Paul J Thu, 01 Jul 2010 07:57:11 GMT https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42764#M11135 deleted_user 2010-07-01T07:57:11Z https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42765#M11136 Are the times unique in the dataset? Thu, 01 Jul 2010 12:43:35 GMT https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42765#M11136 DBailey 2010-07-01T12:43:35Z https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42766#M11137 Dear DBailey,<BR /> <BR /> The times are unique, that is no two rows should have exactly the same time,<BR /> <BR /> Thanks<BR /> <BR /> Paul Thu, 01 Jul 2010 12:55:21 GMT https://communities.sas.com/t5/SAS-Procedures/Data-processing-problem/m-p/42766#M11137 deleted_user 2010-07-01T12:55:21Z