https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500416#M72609 <P>Don't attach datasets. Post a data step with datalines.</P> Mon, 01 Oct 2018 14:44:46 GMT Kurt_Bremser 2018-10-01T14:44:46Z https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500414#M72608 <P>Hi,</P><P>&nbsp;</P><P>1. I want to find observations with same MRN's and same visit_id. Then i want to add the MMEdispense for them.</P><P>Ultimately want to end up with one row for that observation.</P><P>2. I want to find observations with same MRN and different visit visit_id. if proc_start is within one year then delete them and if proc_start</P><P>is more than one year then keep them.</P><P>&nbsp;</P><P>Thanks.</P><P>Part of my SAS dataset is attached.</P><P>&nbsp;</P> Mon, 01 Oct 2018 14:43:21 GMT https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500414#M72608 Kyra 2018-10-01T14:43:21Z https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500416#M72609 <P>Don't attach datasets. Post a data step with datalines.</P> Mon, 01 Oct 2018 14:44:46 GMT https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500416#M72609 Kurt_Bremser 2018-10-01T14:44:46Z https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500427#M72610 <P>Data red.opioid;</P><P>Input&nbsp; MRN &nbsp;VISIT_ID &nbsp;PROC_START &nbsp;MMEdispense;</P><P>Datalines;</P><P>&nbsp;</P><P>1020331 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48648679&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22APR2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75.0</P><P>1022198&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52165183&nbsp;&nbsp;&nbsp;&nbsp; 17APR2018 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>1024630 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 49793399&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19OCT2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240.0</P><P>1024630 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 49793399&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19OCT2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 480.0</P><P>1026419&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50195990&nbsp;&nbsp;&nbsp;&nbsp; 10MAR2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>1029297 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48962048&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23SEP2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>1029297&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;49174787&nbsp;&nbsp;&nbsp;&nbsp; 08JAN2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>1029297&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;49384901&nbsp;&nbsp;&nbsp;&nbsp; 14APR2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>1029297 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 49765729&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07OCT2015&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300.0</P><P>1029297&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50775972&nbsp;&nbsp;&nbsp;&nbsp; 01NOV2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225.0</P><P>;</P><P>Run;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P> Mon, 01 Oct 2018 15:01:48 GMT https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500427#M72610 Kyra 2018-10-01T15:01:48Z https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500434#M72611 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/186157">@Kyra</a>&nbsp;Did you run that code? Did it work for you?<BR />I think this works below:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas"> Data opioid; infile cards truncover; informat mrn $8. visit_ID $8. proc_start date9. mmedispense best12.; format proc_start yymmddd10.; Input MRN VISIT_ID PROC_START MMEdispense; Datalines; 1020331 48648679 22APR2014 75.0 1022198 52165183 17APR2018 225.0 1024630 49793399 19OCT2015 240.0 1024630 49793399 19OCT2015 480.0 1026419 50195990 10MAR2016 225.0 1029297 48962048 23SEP2014 225.0 1029297 49174787 08JAN2015 225.0 1029297 49384901 14APR2015 225.0 1029297 49765729 07OCT2015 300.0 1029297 50775972 01NOV2016 225.0 ; Run; </CODE></PRE> <P>&nbsp;</P> Mon, 01 Oct 2018 15:22:17 GMT https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500434#M72611 Reeza 2018-10-01T15:22:17Z https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500438#M72612 <P>Hi,</P><P>&nbsp;</P><P>i imported excel datasheet into SAS. Thus i did not need the data step with datalines.</P><P>&nbsp;</P><P>Thanks,<BR />prerna</P> Mon, 01 Oct 2018 15:25:28 GMT https://communities.sas.com/t5/SAS-Procedures/sas-code-for-finding-duplicates-and-adding-observations/m-p/500438#M72612 Kyra 2018-10-01T15:25:28Z