check the duplicate and receive an email

[Smitha9]

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.

[SASJedi]

Yes, this can be done in SAS. For sending email, check out his video:

If rows are added to dataset A daily, then the duplicate rows you detected the day before are still in there - do you want to be notified for those again, or do you need some way of keeping track of where you left off?