Help using Base SAS procedures

Output file using proc sql

Reply
Contributor
Posts: 22

Output file using proc sql

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
Super Contributor
Posts: 318

Re: Output file using proc sql

Hi Lani,

add distinct on your select statement

Milton
Contributor
Posts: 22

Re: Output file using proc sql

Thanks Milton. It works.

-Lani
Ask a Question
Discussion stats
  • 2 replies
  • 123 views
  • 0 likes
  • 2 in conversation