Getting lots of totals/statistics at once

[Marilyn]

I have the following fields and want a report at the end with a lot of counts and sums:

station, ssn, invoice number, line items, amounts.

I want a report with individual stations and count of unique ssn, count of unique invoice numbers, count of line items and total dollar amounts.

How can I do this???

[Reeza]

If you want unique counts I recommend proc sql.

proc sql;

create table want as

select station, count(distinct ssn) as unique_ssn, count(distinct invoice_number) as unique_invoice, count(*) as num_line, sum(amounts) as total_dollar

from have

group by station;

quit;