Help using Base SAS procedures

Getting lots of totals/statistics at once

Reply
Contributor
Posts: 20

Getting lots of totals/statistics at once

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

Super User
Posts: 19,861

Re: Getting lots of totals/statistics at once

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;

Ask a Question
Discussion stats
  • 1 reply
  • 160 views
  • 1 like
  • 2 in conversation