I can use any of the following functionalities to achieve it loop with possibly many iterations and data retrievals. I am trying to create a report that shows a list of subjects, their date/time of first dose, date/time of last dose, and the difference between the two date/times
Sarah Marie - Sarah Marie added a new photo.
I am supposed to report the difference in the format d days:hh:mm
In other words, if the first dose date/time was 01jan2019:08:00 a.
For number of days between two sas dates, you can just subtract one from the other Behind the scenes, a sas date is just a number (# of days since jan How do i do this Hi all, i get dates in the is8601da
And i need to find number of days, years, months into different variables Working with date variables in sas visual analytics can be both enjoyable and a bit frustrating The challenge lies in the formatting of dates, especially given the variety of programming languages, format settings, file formats and databases Consequently, date variables can be uploaded in numerous.
The calculation of the number of business days between two dates would then reduce to a mere subtraction of two values retrieved from all_dates instead of the do date=date2 to date1