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
FYI - I have updated your subject line to be more descriptive of your question. In the future please use an appropriate subject line.
I see you've provided input data, what do you want as output?
One function of interest is the DIF() function. It will calculate the difference between the current row and previous row. So if you calculate the dif for the date column you can then check if the dates are increasing or decreasing.
You may also want to make sure your example data is representative of your problem. Do you have multiple patients for example? The code will change if you need to do it for multiple or just one. I'll leave that to you for now. An example of a possible solution is below:
data want;
set have;
days_diff = dif(visit_date);
if days_diff <0 then flag="ERROR";
run;
@sunilsan wrote:
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-2020requirement is the date entered is wrong,
the visit 1 date always smaller than visit 2 , same way visit 2 dae smaller than visit 3but 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
If PT was group variable.
data want; set have; days_diff = dif(visit_date); if pt=lag(pt) and days_diff <0 then flag="ERROR"; run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.