RE: Altair personal slc analysis of fdic failed bamk list using excel database
community.altair.com
https://community.altair.com/discussion/39058
1 Create table work.banks table
libname xls excel "d:/xls/FDIC Failed Bank List.xlsx";
data banks;
set xls.'FDIC Failed Bank List$'n;
run;quit;
libname xls clear;
2 Which year had the most number of bank failures?
YEAR COUNT_BANKS
---------------------
2010 157
proc sql;
reset outobs=1;
select
year(closing_date) as year
,count(*) as count_banks
from
banks
group
by year(closing_date)
order
by count_banks descending
;quit;
3 Which state has had the most number of bank failures?
State COUNT_STATE
-------------------
GA 93
proc sql;
reset outobs=1;
select
state
,count(*) as count_state
from
banks
group
by state
order
by count_state descending
;quit;
4 Which bank has acquired the most failed banks?
Altair SLC
Acquiring Institution COUNT_AQUIRING
----------------------------------------------
No Acquirer 31
State Bank and Trust Company 12
proc sql;
reset outobs=2;
select
Acquiring_Institution
,count(*) as count_aquiring
from
banks
group
by Acquiring_Institution
order
by count_aquiring descending
;quit;
