Hi Everyone

I have two problems I need help with.

1. I have hourly data that I want to aggregate into a 24hr mean. That part is no problem, but I want to aggregate only the hours from 8am to 5pm. I want the mean for the hours 8am to 5pm (8.00 to 17.00 hrs) to be the aggregated mean, how can I do that. The variables are as follows. Var1 is the time (24hr clock) and Var2 is the value recorded at each time slot. VAR1(time) VAR2(Value) 1.00 4 2.00 8 to etc 24.00

2. I want to delete cases that fit a particular condition. For example, if a particular variable equals a particular value I want to delete that case from the data set. Say I want to delete cases that have a value of 3 in the variable labelled 'home', how do I do this.

Thanks in advance for any help. Cheers Craig