Thanks so much for your response, Linlin. When I copy and paste your code into SAS (9.0, Windows Version) and press the running man, I receive the following message: NOTE: No observations in data set WORK.WANT. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Perhaps I am doing something wrong--very likely since I am a newbie to SAS. Also, I will need to import an excel file "C:\Test.xls", which has two columns [one named time and the other named temp] time temp 8/20/2009 18:35 24.6 8/20/2009 18:36 24.8 8/20/2009 18:37 24.8 8/20/2009 18:38 24.9 8/20/2009 18:39 24.9 8/20/2009 18:40 24.9 8/20/2009 18:46 25.4 8/20/2009 18:47 25.4 8/20/2009 18:48 25.4 8/20/2009 18:49 25.4 8/20/2009 18:50 25.6 8/20/2009 18:51 25.6 8/20/2009 18:52 25.7 8/20/2009 18:53 25.7 8/20/2009 18:54 25.8 I made rows bold where I am missing data and would like to insert new values at 1-minute intervals. And yes, your code for inserting new temp values as 0 when y=. looks to be on the right track for what I am hoping to accomplish. Also, when I import my excel file using the File>Import Data option, my data set appears to be imported without the the time (i.e. only the date value is imported, but the column was formated as dd/mm/yy hh:mm in excel prior to importing). Thank you again for your feedback, but I still need more HELP on this one! Cheers, james
... View more