I have a dataset A which has temporary studyID:
ID studyID Fit Grow Date
1 T2345 10 22 02232022
2 T4568 12 23 04162021
3 T5674 10 . 04172022
daily the above dataset gets updated. If the ID, FIT and GROW is same then the StudyID gets permanent studyID
ID studyID Fit Grow Date
1 34567 10 22 03292023
2 45678 12 23 03292023
3 T5674 10 . 03292023
3 45673 10 21 03292023
I see there are duplicates in todays update. this happened because Grow variable is different now. Whenever I get these kind duplicates I need to automate the code on how to check this daily and receive an email if there are duplicates in daily run
Can I do this in SAS?
thanks in advance.