topic Re: Selecting distinct Combinations of two variables in SAS Programming

Selecting distinct Combinations of two variables

LisaYIN9309 — Tue, 24 Oct 2017 19:20:50 GMT

Hi I am thinking is it possible to count distinct combination of two variables, for example:

I know proc sql;

count(distinct (variable))

but it only count base on one criteria...

person_ID	condition_Id
1	1
1	2
1	1
2	2
3	1
3	1
4	2
4	1
4	2
5	1
5	2
6	1

this should give me a count of 9 (person 1 was count twice although it has 3 entries, person 3 count only 1 although it has 2 entries).

All ideas are welcome!

Re: Selecting distinct Combinations of two variables

PGStats — Tue, 24 Oct 2017 19:35:23 GMT

Distinct can also be used at the row level:

data test;
input person_ID condition_Id ;
datalines;
1 1 
1 2 
1 1 
2 2 
3 1 
3 1 
4 2 
4 1 
4 2 
5 1 
5 2 
6 1 
;

proc sql;
select count(*) as n
from
    (select distinct person_id, condition_id
     from test);
quit;

Re: Selecting distinct Combinations of two variables

Astounding — Tue, 24 Oct 2017 21:26:13 GMT

The SQL gurus may shoot me over this, but as long as both variables are numeric you could use:

proc sql;

select count (distinct(person_ID + condition_ID/10)) from have;

quit;

Re: Selecting distinct Combinations of two variables

LisaYIN9309 — Wed, 25 Oct 2017 00:29:16 GMT

This is great! Than you!