topic check the duplicate and receive an email in New SAS User https://communities.sas.com/t5/New-SAS-User/check-the-duplicate-and-receive-an-email/m-p/867037#M38354 <P>I have a dataset A which has temporary studyID:</P><P>ID&nbsp; studyID&nbsp; &nbsp; Fit&nbsp; &nbsp; &nbsp; Grow&nbsp; &nbsp;Date</P><P>1&nbsp; &nbsp; T2345&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp;02232022</P><P>2&nbsp; &nbsp; T4568&nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp;04162021</P><P>3&nbsp; &nbsp; T5674&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; 04172022</P><P>&nbsp;</P><P>daily the above dataset gets updated. If the ID, FIT and GROW is same then the StudyID gets permanent studyID</P><P>ID&nbsp; &nbsp; studyID&nbsp; &nbsp; &nbsp; &nbsp;Fit&nbsp; &nbsp; Grow&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;34567&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03292023</P><P>2&nbsp; &nbsp; &nbsp; &nbsp;45678&nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03292023</P><P>3&nbsp; &nbsp; &nbsp; &nbsp;T5674&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03292023</P><P>3&nbsp; &nbsp; &nbsp; &nbsp;45673&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; 03292023</P><P>&nbsp;</P><P>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</P><P>Can I do this in SAS?</P><P>&nbsp;</P><P>&nbsp;</P><P>thanks in advance.</P> Wed, 29 Mar 2023 14:48:27 GMT Smitha9 2023-03-29T14:48:27Z check the duplicate and receive an email https://communities.sas.com/t5/New-SAS-User/check-the-duplicate-and-receive-an-email/m-p/867037#M38354 <P>I have a dataset A which has temporary studyID:</P><P>ID&nbsp; studyID&nbsp; &nbsp; Fit&nbsp; &nbsp; &nbsp; Grow&nbsp; &nbsp;Date</P><P>1&nbsp; &nbsp; T2345&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp;02232022</P><P>2&nbsp; &nbsp; T4568&nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp;04162021</P><P>3&nbsp; &nbsp; T5674&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; 04172022</P><P>&nbsp;</P><P>daily the above dataset gets updated. If the ID, FIT and GROW is same then the StudyID gets permanent studyID</P><P>ID&nbsp; &nbsp; studyID&nbsp; &nbsp; &nbsp; &nbsp;Fit&nbsp; &nbsp; Grow&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date</P><P>1&nbsp; &nbsp; &nbsp; &nbsp;34567&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03292023</P><P>2&nbsp; &nbsp; &nbsp; &nbsp;45678&nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03292023</P><P>3&nbsp; &nbsp; &nbsp; &nbsp;T5674&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03292023</P><P>3&nbsp; &nbsp; &nbsp; &nbsp;45673&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp; &nbsp; 03292023</P><P>&nbsp;</P><P>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</P><P>Can I do this in SAS?</P><P>&nbsp;</P><P>&nbsp;</P><P>thanks in advance.</P> Wed, 29 Mar 2023 14:48:27 GMT https://communities.sas.com/t5/New-SAS-User/check-the-duplicate-and-receive-an-email/m-p/867037#M38354 Smitha9 2023-03-29T14:48:27Z Re: check the duplicate and receive an email https://communities.sas.com/t5/New-SAS-User/check-the-duplicate-and-receive-an-email/m-p/867084#M38355 <P>Yes, this can be done in SAS. For sending email, check out his video:<BR /><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F3jARA84Pwck%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D3jARA84Pwck&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F3jARA84Pwck%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" width="200" height="112" scrolling="no" title="SAS Tutorial | How to Automate Emails Using SAS" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture" allowfullscreen="true"></iframe></div><BR />If rows are added to&nbsp;<SPAN>dataset A&nbsp;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?</SPAN></P> Wed, 29 Mar 2023 17:55:49 GMT https://communities.sas.com/t5/New-SAS-User/check-the-duplicate-and-receive-an-email/m-p/867084#M38355 SASJedi 2023-03-29T17:55:49Z