how to count time interval for each customer?
have:
id | time |
103 | 07MAR2015:09:13:02.00 |
102 | 07DEC2015:10:42:19.00 |
102 | 07DEC2015:10:43:39.00 |
101 | 07MAY2015:09:13:30.00 |
102 | 07DEC2015:10:43:51.00 |
101 | 07MAY2015:09:13:41.00 |
103 | 07MAR2015:09:13:05.00 |
101 | 07MAY2015:09:13:55.00 |
want:
id | time | interval |
101 | 07MAY15:09:13:30 | . |
101 | 07MAY15:09:13:41 | 11 |
101 | 07MAY15:09:13:55 | 14 |
102 | 07DEC15:10:42:19 | . |
102 | 07DEC15:10:43:39 | 80 |
102 | 07DEC15:10:43:51 | 12 |
103 | 07MAR15:09:13:02 | . |
103 | 07MAR15:09:13:05 | 3 |
Yes having the seconds included makes it clear how the value is to be determined.
This problem has been solve by PG Stats at this link. You might have to do a little work with the code so that the variables reference your case information.
https://communities.sas.com/t5/SAS-Programming/count-average-time-interval/m-p/487616#M127080
How does interval get assigned? your sample reflects that interval is char based on the sample being left justified.
You appear to want to do 2 things:
Yes having the seconds included makes it clear how the value is to be determined.
This problem has been solve by PG Stats at this link. You might have to do a little work with the code so that the variables reference your case information.
https://communities.sas.com/t5/SAS-Programming/count-average-time-interval/m-p/487616#M127080
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.