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.
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.