SAS ON DEMAND

You are working with the federal government. Your project manager asks you to write a script that counts failed banks by each state. You will then present the list in the sorted format (descending order).

You need to create a SAS script that should produce following output by using the banklist.csv file

1. Count number of failed bank by state.

2. Display output in descending order.

3. Follow all the best practices for script development process.

(banklist.csv file example)

BankName	City	ST	CERT	AcquiringInstitution	ClosingDate	UpdatedDate
Proficio Bank	Cottonwood Heights	UT	35495	Cache Valley Bank	3-Mar-17	13-Apr-17
Seaway Bank and Trust Company	Chicago	IL	19328	State Bank of Texas	27-Jan-17	17-Feb-17
Harvest Community Bank	Pennsville	NJ	34951	First-Citizens Bank & Trust Company	13-Jan-17	13-Apr-17
Allied Bank	Mulberry	AR	91	Today's Bank	23-Sep-16	17-Nov-16
The Woodbury Banking Company	Woodbury	GA	11297	United Bank	19-Aug-16	17-Nov-16