Dear All, I was asked this question (here). The data set is
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long stkcd int year str27(ask answer)
2 2011 "2012-03-14 15:07:26.0" "2012-03-14 16:04:47.0"
2 2011 "2012-03-14 15:01:06.0" "2012-03-14 16:11:49.0"
2 2011 "2012-03-14 15:31:47.0" "2012-03-14 17:19:47.0"
2 2011 "2012-03-14 15:51:37.0" "2012-03-14 16:51:15.0"
2 2011 "2012-03-14 15:10:38.0" "2012-03-14 17:09:33.0"
2 2011 "2012-03-14 16:07:33.0" "2012-03-14 17:10:51.0"
2 2012 "2013-02-28 17:59:19.0" "2013-03-01 15:15:41.0"
2 2012 "2013-02-28 17:57:00.0" "2013-03-01 15:26:34.0"
2 2012 "2013-03-01 16:19:46.0" "2013-03-01 16:37:47.0"
2 2012 "2013-03-01 16:18:07.0" "2013-03-01 16:53:24.0"
2 2012 "2013-03-01 15:30:16.0" "2013-03-01 16:15:12.0"
2 2012 "2013-03-01 15:29:27.0" "2013-03-01 15:48:58.0"
2 2012 "2013-03-01 15:45:07.0" "2013-03-01 17:05:37.0"
2 2012 "2013-02-28 17:55:00.0" "2013-03-01 15:17:39.0"
2 2012 "2013-03-01 15:51:23.0" "2013-03-01 16:20:44.0"
2 2012 "2013-03-01 15:46:06.0" "2013-03-01 16:05:06.0"
2 2012 "2013-03-01 15:28:15.0" "2013-03-01 16:45:33.0"
2 2012 "2013-02-28 18:10:48.0" "2013-03-01 15:33:13.0"
2 2012 "2013-03-01 15:15:54.0" "2013-03-01 16:03:28.0"
2 2012 "2013-03-01 15:29:49.0" "2013-03-01 16:05:44.0"
end
The question is to obtain the difference between "ask" and "answer" times. Any suggestions are appreciated.