Coronavirus (COVID-19) Deaths

Data Death_due_covid;
set work. Import;
run;
Proc sql; Select 
location,date,population,total_cases, New_cases,total_deaths
from Death_due_covid (obs = 2000);
order by date and location;
quit;
Proc sql; Select 
location,date,total_cases,total_deaths, (total_deaths/total_cases)*100 as percentagedeathrate
from Death_due_covid;
order by location and date;
quit;
proc sql;
select location,date ,population Max(total_cases)as HighestinfectionCount, (total_cases/population)*100
as deathpercentage
from US_Covid;
order by location,date;
quit;
Proc sql; Select 
location,date,new_cases,total_cases, (new_cases/total_cases)*100 as PercentageofNewUS_infection_rate
from US_Covid;
order by location ,date;
quit;
proc sql;
select location ,date ,total_deaths_per_million,population
from US_Covid
order by location, total_deaths_per_million desc ;
proc sql;
select location ,date ,total_cases_per_million,population
from US_Covid
order by location, total_cases_per_million desc ;

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store