SAS Code

[umar_milanzi]

i have a dataset that looks like

customer_id      cellphone

deeee                 0897777

deesss                65788

reeesss              7866

(not real values)

I want to check which of the customer_id has the same cellphone value

[Kurt_Bremser]

From the hip:

proc sql;
select
  a.customer_id as cust1,
  b.customer_id as cust2,
  a.cellphone as cell
from have as a, have as b
where a.cellphone = b.cellphone and a.customer_id ne b.customer_id
;
quit;

[LinusH · Accepted solution]

or

proc sql;
select *
from have
group by cellphone
having count(*) > 1
;
quit;