Examining the spread of Ebola in different countries using SAS

Examining the spread of Ebola in different countries using SAS

Data source : Sub-national time series data on Ebola cases and deaths in Guinea, Liberia, Sierra Leone, Nigeria, Senegal and Mali since March 2014

https://data.hdx.rwlabs.org/dataset/rowca-ebola-cases

Google data sets provides you with current information on the extent of spread of Ebola. We will work on this data set and learn how to

1. import excel file into SAS  
2. write a basic SAS sql program

• Program to import excel file in SAS

proc import DBMS=xls out=work.ebola

datafile="/folders/myfolders/ebola/Ebola1.xls";

run;

After we are done importing the file into SAS, we want to find which country has maximum outbreak of Ebola area-wise .

• The following sql lists the extent of spread of Ebola in different countries. The result gives us country name and the count of different localites affected by ebola.

the output is as follows