statguru

profilestrength
Example.pptx

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