06-24-2015 09:05 AM
I need to break down time into 1/4 hour groups to see when most people showed up at an event. Is there anyways to do this?
I am not sure how to include time into the code.
06-24-2015 09:53 AM
What does your starting data look like? What should the output look like? Provide some example of what you have and what the output should look like.
06-24-2015 09:59 AM
The time variable right now is:
I need it to break it down into quarter hours: so something like the following
There are a lot more observation than this. But i am thinking just dividing them into groups would be appropriate.
06-24-2015 10:24 AM
would it change anything if the dataset is already a dataset….this is like over a million time observations so I am not sure how to get around using a datelines; step.
06-24-2015 10:11 AM
informat time time8.;
format time time8.;
group = round(time / (60*15));
06-24-2015 10:16 AM
informat time time.;
format time time.;