Output file using proc sql

Lani — Wed, 17 Mar 2010 23:34:56 GMT

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

Re: Output file using proc sql

milts — Thu, 18 Mar 2010 01:14:43 GMT

Hi Lani,

add distinct on your select statement

Milton

Re: Output file using proc sql

Lani — Thu, 18 Mar 2010 19:59:13 GMT

Thanks Milton. It works.

-Lani

topic Re: Output file using proc sql in SAS Procedures

Output file using proc sql

Re: Output file using proc sql

Re: Output file using proc sql