If this is as character variable, concatenate 01- at the beginning in both of the date then convert that in numeric and then find the difference using INTCK
solve this we have visit, visit_date, and pt (patient) variables or fields are there pt visit visit_date 10005 visit 1 01-jan-2020 10005 visit 2 09-jan-2020 10005 visit 3 11-jan-2020 10005 visit 4 02-jan-2020 10005 visit 5 03-jan-2020 requirement is the date entered is wrong, the visit 1 date always smaller than visit 2 , same way visit 2 dae smaller than visit 3 but here visit 4 date is date shd be gretaer than visit 3 .. how to find these type of patient information date information in our raw data
Very simplified way of teaching. Thanks sir
Thanks
Good good...
Thank you! Cheers!
Thank you for sharing! A quick additional question: how do I get absolute value of two dates ? Thank you!
can you give some example of what exactly you are looking for then possiblye I'll be able to help
Hi, I would like to know how could I calculate the time between purchases per client(same clientId) in a table with multiple clients.
Check out this video which will give idea
ua-cam.com/video/PQafLpOCj6g/v-deo.html
u can use intck to calculate the difference
wt abt if there are more observations in two variables
Thanks for giving it a watch, couldn't understand how is that a challenge, you can apply the same on that...
intck('month', var1, var2)
should work
How to calculate the difference between two dates if day is not given ....ie may2017 and June 2022
Please reply
I had replied at your another post
How to calculate the difference may-2017 and june-2022
If this is as character variable, concatenate 01- at the beginning in both of the date then convert that in numeric and then find the difference using INTCK
Superb
Glad you liked it
solve this
we have visit, visit_date, and pt (patient) variables or fields are there
pt visit visit_date
10005 visit 1 01-jan-2020
10005 visit 2 09-jan-2020
10005 visit 3 11-jan-2020
10005 visit 4 02-jan-2020
10005 visit 5 03-jan-2020
requirement is the date entered is wrong,
the visit 1 date always smaller than visit 2 , same way visit 2 dae smaller than visit 3
but here visit 4 date is date shd be gretaer than visit 3 ..
how to find these type of patient information date information in our raw data