BookmarkSubscribeRSS Feed
Smitha9
Fluorite | Level 6

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.

1 REPLY 1
SASJedi
SAS Super FREQ

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?

Check out my Jedi SAS Tricks for SAS Users

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 529 views
  • 0 likes
  • 2 in conversation