Date as SAS Macro variable - common issues and solutions

[@popcorn7657]

THank you for showing and explaining common mistakes

[@udaychouhan622]

Thank you so much for uploading this video. Amazing explanation in a crisp video.

[@navk1000]

Thank You So much Kiran...

[@princysingla5084]

again Very nice video on Macros please make more such videos :)

[@ishwormaharjan6486]

Thank you so much for your excellent presentation.

[@modiramesh9245]

Very good explanation. Kindly make video on applying formats on Macro variables.

[@karnarajmahajan8861]

Thanks for your efforts.

[@sivaprasad5060]

Really good videos and nice explanation...Would it be possible to share the videos related to Format CNTLIN = and CNTLOUT= options.

[@sunilsan8221]

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

[@kiranvenna]

create a new variable and use lag(visit_date) and if it is first visit change the value of new variable to missing value. after this subtract visit_date with your lag(visit_date) variable and depending on difference you can identify whether your visit dates values are correct or not.