topic Re: Getting lots of totals/statistics at once in SAS Procedures

Getting lots of totals/statistics at once

Marilyn — Wed, 23 Apr 2014 21:27:06 GMT

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???

Re: Getting lots of totals/statistics at once

Reeza — Wed, 23 Apr 2014 22:56:48 GMT

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;