topic Re: Deleting the second duplicate row in SAS Programming

Deleting the second duplicate row

altijani — Wed, 12 Sep 2018 18:44:19 GMT

Hi,

I have the following data:

customer_id	customer_name	visit
456A	John	1
123B	Smith	3
123B	Smith	4
987D	David	2
654H	Haydar	4

I need to delete the second row for Smith, because customer_id and customer_name are the same. In other words: only keep the first instance of visit. What I want is like this:

customer_id	customer_name	visit
456A	John	1
123B	Smith	3
987D	David	2
654H	Haydar	4

Thanks

Re: Deleting the second duplicate row

novinosrin — Wed, 12 Sep 2018 18:49:20 GMT

data want;
set have;
by  customer_id	customer_name notsorted;
if first.customer_id and first.customer_name;
run;

Re: Deleting the second duplicate row

Tom — Wed, 12 Sep 2018 18:54:10 GMT

@novinosrin wrote:

data want;
set have;
by  customer_id	customer_name notsorted;
if first.customer_id and first.customer_name;
run;

You don't need to reference both of those FIRST. variables. If you want to keep multiple names per CUSTOMER_ID then just use FIRST.CUSTOMER_NAME. If you just want one name per customer_id the just use use FIRST.CUSTOMER_ID. Note that FIRST.CUSTOMER_NAME will always be true when FIRST.CUSTOMER_ID is true.

Re: Deleting the second duplicate row

novinosrin — Wed, 12 Sep 2018 18:54:59 GMT

Oh yes of course. Thank you

Re: Deleting the second duplicate row

altijani — Wed, 12 Sep 2018 19:23:59 GMT

I need to keep the first observation of the same customer_id and customer_name