selecting observations

[meetagupta]

Below is the dataset and I have to pick customer_id who have submitted ADDRESS and ID proof but not submitted INCOME proof. How can I choose those obs? For example, Custome_id 3 is the only one who have not submitted income proof.

Thanks.

customer_id     proof

    1                     income

    1                      id

    1                      id

    2                     address

    2                      income

   2                         id

   3                       address

    3                      address

    3                        id

[Reeza · Accepted solution]

proc sql;
create table want as
select distinct ID
from have
where id not in (select distinct ID from have where proof = 'income');
quit;

You can use SQL for this nicely. 

Remember that text comparisons are case sensitive.

---

@meetagupta wrote:

Below is the dataset and I have to pick customer_id who have submitted ADDRESS and ID proof but not submitted INCOME proof. How can I choose those obs? For example, Custome_id 3 is the only one who have not submitted income proof.

Thanks.

customer_id     proof

    1                     income

    1                      id

    1                      id

    2                     address

    2                      income

   2                         id

   3                       address

    3                      address

    3                        id

---

[meetagupta]

Thank you very much. it worked.

[novinosrin]

CustomerID  1 doesn't seem to have submitted ADDRESS proof either?

So 1 shouldn't qualify right?

[meetagupta]

I only wanted customers who have not submitted Income proof. thanks