I have two dates.. and i am trying to find the number of days
i was trying two methods and get contrasting results for each
Which of these is the right method????????
date1 (discharge date) date2( surgery date)
03MAY2012:13:39:00.000 02MAY12:15:30:00
/*METHOD1*/
days=date1-date2
days_1=datepart(days); /* gives me days_1= 0 */ post surgery days
/*METHOD2*/
days=datepart(date1)-datepart(date2) /* gives me days= 1 */ post surgery days
Thanks
For most processes that is 1 calendar day, which usually isn't an overestimation and you mentioned finding days. If you need 24 hour periods instead of calendar days you'll probably need to use the INTCK function to count specified intervals of time.
Method 2 is what I would be using generally.
A third approach if were to make sense for your use would be to get the time interval, such as total hours and turn that into 24-hour periods.
Why Method2: ??????it isnt it over estimating the days?????
For most processes that is 1 calendar day, which usually isn't an overestimation and you mentioned finding days. If you need 24 hour periods instead of calendar days you'll probably need to use the INTCK function to count specified intervals of time.
Hi,
Thanks for the reply,
I also wanted to correct the usage..Is the extra braces needed as in the second case?or firstone is perfectly fine?
days=datepart(date1)-datepart(date2);
days=(datepart(date1)-datepart(date2));
Thanks
Both lines return the same result. The only time you would need the extra braces is in a more complex computation where you need to control the order of operations.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.