statguru
Historic Mortality Data
By Antony Paul, Adam Langley, Rashidi Ramazani & Ghanem Nasser
Aims and Objectives
Analyse the data
Present the data (SAS/ODS Graphics)
Trends in the data
Identifying key stakeholders
Introduction
Importing the data
Results of the data
Creating tables
Potential stakeholders
Key stakeholders
NHS (Patient records, research, CQC)
Councils (Records, burial records, council tax)
Lawyers/Solicitors (Referrals, wills, attorneys)
Insurance companies (Premium & rates, trends)
Funeral directors/providers (Resource management, location)
Care Quality Commission
National Audit Office (Census)
World Health Organisation
How to import a dataset *Using codes ()
libname home 'U:\Historic Mortality data\Historic Mortality data';
run;
proc import out=home
datafile='U:\Historic Mortality data\Historic Mortality data\PDH7484.csv'
dbms=csv replace;
run;
proc print;
run;
Result
How to Import data without coding
Go file - select import data
How to import data without using Code
-Select a data source
-click next
How to import data without using Code
Select Browse.
Select the file you want to import
How to import data without using Code
-Choose your library.
-Add member name.
-Click next / then click finish.
Merging datasets
Result
Rename Variables
Proc Means Statement
Year from 1963 - 1984
Proc Tabulate Statement
Creating group chart
Create a small dataset
2. PROC CHART
3. RESULT
Comparing gender mortality for ages 10 to 14 years from 1901 to 1910 England and Wales.
FACT: There was a
decrease in death rates by over 1,000