Output file using proc sql

[Lani]

I have a data set bill_cnts with the followings
id name count
123 John Sample 23
123 John Sample 23
888 Jane Smith 40
888 Jane Smith 40

I'd like to create an output to show like the followings
id name count
123 John Sample 46
888 Jane Smith 80

But, the output I have is
id name count
123 John Sample 46
123 John Sample 46
888 Jane Smith 80
888 Jane Smith 80

Here is my code
proc sql;
create table bill as
select id,name,sum(count)
from bill_cnts
group by id
order by id;
quit;
run;

Please advise what I did wrong. Thanks for your help.

Lani

[milts]

Hi Lani,

add distinct on your select statement

Milton

[Lani]

Thanks Milton. It works.

-Lani