RE: Altair slc summarizing excel bank statements

Roger DeAngelis_21630

RE: Altair slc summarizing excel bank statements

Too long to post on listserve, see github for full solution

github
https://github.com/rogerjdeangelis/utl-altair-slc-summarizing-excel-bank-statements

community.altair.com
https://community.altair.com/discussion/19740

PROBLEM

select bank statement
group by: bank, type, industry
sum: amount, trans
count unique values: id, plastic

Given bank statements in an excel workbook add a summarization excel sheet
using the slc proc sql (same code works in R and Python)

proc sql;
create
table xls.sumary as
select
bank
,type
,industry
,sum(amount) as sum_amount
,sum(trans) as sum_trans
,count(distinct id) as unq_id
,count(distinct plastic) as unq_plastic
from
xls.banks
group
by bank, type, industry
;quit;