topic Re: selecting observations in SAS Programming

selecting observations

meetagupta — Wed, 09 Oct 2019 19:34:56 GMT

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

2 address

2 income

2 id

3 address

3 id

Re: selecting observations

Reeza — Wed, 09 Oct 2019 20:01:55 GMT

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

Re: selecting observations

novinosrin — Wed, 09 Oct 2019 20:04:33 GMT

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

So 1 shouldn't qualify right?

Re: selecting observations

meetagupta — Wed, 09 Oct 2019 20:12:58 GMT

Thank you very much. it worked.

Re: selecting observations

meetagupta — Wed, 09 Oct 2019 20:14:24 GMT

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