https://communities.sas.com/t5/SAS-Programming/compare-rows-in-dataset-and-deleting/m-p/755659#M238509 <TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Event</TD><TD>Code</TD><TD>value</TD></TR><TR><TD>1</TD><TD>A</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>6</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>7</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>8</TD></TR><TR><TD>2</TD><TD>A</TD><TD>5</TD><TD>7</TD></TR><TR><TD>2</TD><TD>B</TD><TD>6</TD><TD>8</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>want</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Event</TD><TD>Code</TD><TD>Value</TD></TR><TR><TD>1</TD><TD>A</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>6</TD></TR><TR><TD>2</TD><TD>A</TD><TD>5</TD><TD>7</TD></TR><TR><TD>2</TD><TD>B</TD><TD>6</TD><TD>8</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is just an example, but for my dataset, I need to be able to compare ID and code.</P><P>If the ID and code are the same, then I want to only retain one row and delete all the other rows.</P><P>&nbsp;</P><P>Can you please suggest?</P> Wed, 21 Jul 2021 15:12:04 GMT Nrjn7 2021-07-21T15:12:04Z https://communities.sas.com/t5/SAS-Programming/compare-rows-in-dataset-and-deleting/m-p/755659#M238509 <TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Event</TD><TD>Code</TD><TD>value</TD></TR><TR><TD>1</TD><TD>A</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>6</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>7</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>8</TD></TR><TR><TD>2</TD><TD>A</TD><TD>5</TD><TD>7</TD></TR><TR><TD>2</TD><TD>B</TD><TD>6</TD><TD>8</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>want</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Event</TD><TD>Code</TD><TD>Value</TD></TR><TR><TD>1</TD><TD>A</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>B</TD><TD>1</TD><TD>6</TD></TR><TR><TD>2</TD><TD>A</TD><TD>5</TD><TD>7</TD></TR><TR><TD>2</TD><TD>B</TD><TD>6</TD><TD>8</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is just an example, but for my dataset, I need to be able to compare ID and code.</P><P>If the ID and code are the same, then I want to only retain one row and delete all the other rows.</P><P>&nbsp;</P><P>Can you please suggest?</P> Wed, 21 Jul 2021 15:12:04 GMT https://communities.sas.com/t5/SAS-Programming/compare-rows-in-dataset-and-deleting/m-p/755659#M238509 Nrjn7 2021-07-21T15:12:04Z https://communities.sas.com/t5/SAS-Programming/compare-rows-in-dataset-and-deleting/m-p/755675#M238516 <P>Easiest might be</P> <P>&nbsp;</P> <P>Proc sort data=have out=want nodupkey;</P> <P>&nbsp;&nbsp; by Id code;</P> <P>run;</P> <P>&nbsp;</P> <P>Create a new output data set Want so you don't accidentally delete things you want. This way your original data set remains.</P> <P>&nbsp;</P> <P>If EVENT plays any role in this process, which you did not mention, then you may want to sort by ID Event Code; Maybe.</P> Wed, 21 Jul 2021 15:54:27 GMT https://communities.sas.com/t5/SAS-Programming/compare-rows-in-dataset-and-deleting/m-p/755675#M238516 ballardw 2021-07-21T15:54:27Z