Proc SQL - Column labels

hwangnyc — Mon, 19 Mar 2018 14:14:27 GMT

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

What I would like is this:

casedisposition_coll	UniqueFam
1	130
2	56
3	11

Thanks in advance!

Re: Proc SQL - Column labels

hwangnyc — Mon, 19 Mar 2018 14:15:52 GMT

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;

topic Re: Proc SQL - Column labels in SAS Programming

Proc SQL - Column labels

Re: Proc SQL - Column labels