04-23-2014 05:27 PM
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???
04-23-2014 06:56 PM
If you want unique counts I recommend 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
group by station;