http://www.askmehelpdesk.com en Sun, 22 Nov 2009 02:02:12 GMT vBulletin 60 http://www.askmehelpdesk.com/amhd_imgs/misc/rss.jpg http://www.askmehelpdesk.com http://www.askmehelpdesk.com/other-programming/sas-intervals-between-two-dates-fixed-variable-417722.html Fri, 20 Nov 2009 09:24:16 GMT Hey There, I am trying to count the number of actual days between two dates for a fixed variable i.e. mr x buys a bag of chips on 01jan2009 then again on 05jan2009 and again on 25jan2009 and again on 27 jan2009 and so on. I am trying to get the number of days elapsed between each purchase for... Hey There,
I am trying to count the number of actual days between two dates for a fixed variable i.e.
mr x buys a bag of chips on 01jan2009 then again on 05jan2009 and again on 25jan2009 and again on 27 jan2009 and so on. I am trying to get the number of days elapsed between each purchase for each customer in a table containing mulitple customers, multiple dates.
DATDIF needs a start and end date so if more than two dates appear, this would not work. Please can someone help with the applied script that would return variables:
01jan2009 = 0
05Jan2009 = 4
25jan2009 = 20
27jan2009 = 2
Thanks :eek: ]]> Other Programming skappy http://www.askmehelpdesk.com/other-programming/sas-intervals-between-two-dates-fixed-variable-417722.html