Proc SQL - Column labels

[hwangnyc]

Hi everyone,

I'm looking for unique counts by a certain group. So when I use this code:

proc sql;
select count(distinct(childid)) as UniqueFam
from ResearchAsthmaEvent5
where programtypeid = 1 
group by casedisposition_coll;
run; 

I get this results:

UniqueFam

130

56

11

What I would like is this:

casedisposition_coll	UniqueFam
1	130
2	56
3	11

Thanks in advance!

[hwangnyc · Accepted solution]

Doh!, I figured it out! 

proc sql;
select casedisposition_coll, count(distinct(childid)) as UniqueFam
from ResearchAsthmaEvent5
where programtypeid = 1 
group by casedisposition_coll;
run;