-
Notifications
You must be signed in to change notification settings - Fork 0
/
FRS HBAI - master - public v3.sps
147 lines (123 loc) · 6.53 KB
/
FRS HBAI - master - public v3.sps
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
* Encoding: UTF-8.
dataset close all.
output close all.
*** FRS HBAI - master - public v3.sps.
*** v1 - Dec 2018.
*** v2 - Jul 2019: updated for 2017/18 data.
*** v3 - May 2020: updated for 2018/19 data.
*** GENERAL NOTES:
*** WRITTEN BY NICK BAILEY, UNIVERSITY OF GLASGOW.
***.
*** THIS SET OF SYNTAX FILES PRODUCED THE ANALYSIS FOR:
*** Bailey, Nick (2019) Poverty and the re-growth of private renting in the UK.
***
***
*** 0. INTRODUCTION
*** THE SYNTAX FILE REPRODUCES ALL THE FIGURES IN THE PAPER.
*** IT ALSO PRODUCES TWO .CSV FILES USED IN AN ON-LINE DATA VISUALISATION TOOL NOTED IN THE PAPER.
*** WHEN RUN ON MY PC, PRODUCES SOME WARNINGS BUT NO ERRORS.
*** THE CODE IS SHARED UNDER A GNU GENERAL PUBLIC LICENCE V3.
*** YOU ARE WELCOME TO USE IT AND ADAPT THE CODE BUT SHOULD GIVE CREDIT FOR THIS WORK
*** AND SHOULD MAKE ANY RESULTING PRODUCTS AVAILABLE ON THE SAME BASIS.
*** SHARING IS DONE IN THE SPIRIT OF COLLABORATION AND TO SUPPORT TRANSPARENCY AND REPRODUCIBILITY.
*** NO GUARANTEES ARE GIVEN THAT THIS CODE IS CORRECT AND NO SUPPORT WILL BE PROVIDED.
*** FEEDBACK ON THE CODE IS WELCOMED.
*** 1. DATA SOURCES
*** THE SYNTAX RUNS ON A SET OF FILES DOWNLOADED FROM THE UK DATA SERVICE.
*** THE DATA ARE FROM THE FAMILY RESOURCES SURVEY (FRS) AND AN ASSOCIATED SET
*** OF DERIVED DATA, THE HOUSEHOLDS BELOW AVERAGE INCOME (HBAI) DATASET.
*** THE PAPER CONTAINS THE FULL METHODOLOGICAL DETAILS.
*** FRS DATA FILES WERE DOWNLOADED FROM THE UK DATA SERVICE AS ZIP FILES FOR SPSS.
*** UKDS SERIES ID: 200017 [DATASET FOR EACH YEAR HAS ITS OWN DOI]
*** FRS DATA DOWNLOADED AUGUST 2018.
*** SPSS DATA FILES (.SAV) EXTRACTED AND SAVED TO A SEPARATE DIRECTORY FOR EACH YEAR.
*** NAMING DETAILS FOR FILES AND DIRECTORIES IN 2. BELOW.
*** 93/94 OMITTED AS NOT INCLUDED IN HBAI DATASET.
*** HBAI DATA FOR ALL YEARS DOWNLOADED FROM THE UK DATA SERVICE AS ONE ZIP FILE FOR SPSS.
*** UKDS STUDY NUMBER: 5828-9 [doi: 10.5255/UKDA-SN-5828-9].
*** SPSS DATA FILE FOR EACH YEAR EXTRACTED AND SAVED WITH FRS DATA FOR THAT YEAR.
*** DATA FILES FOR YEARS 2002/3 ON HAVE SUFFIX '_G4.SAV' IN THE ZIP FILE BUT SUFFIX DROPPED HERE.
*** HBAI DATASET IS FOR "BENEFIT UNITS" (SEE DOCUMENTATION FOR DEFINITIONS - SIMILAR TO HOUSEHOLD)
*** BUT THIS CODE CREATES FILE WITH ONE CASE FOR EACH ADULT/CHILD IN THE BENEFIT UNIT.
*** ANALYSIS DISTINGUISHES ADULTS WHO ARE HOUSEHOLDERS (OWNER/TENANT OR PARTNER OF SAME)
*** FROM OTHERS LIVING 'CARE OF' e.g. WITH FAMILY OR FRIENDS, OR LIVING 'RENT FREE'.
*** 2. FILE STRUCTURE AND SET UP
*** THE SYNTAX ASSUMES FILES ARE ORGANISED WITHIN A FOLDER CALLED 'FRS' WHICH HAS
*** A PATH NAME <pathname>, AND ARRANGED AS FOLLOWS:
*** <pathname>\FRS - all syntax files, chart format files (.sgt) are placed in this folder
*** <pathname>\FRS\FRS 9495 - three FRS files extracted from UKDS zip files for 1994/95 and named: adult.sav, child.sav, househol.sav
*** - one HBAI file for same year extracted from UKDS zip files and named: hbai.sav
*** <pathname>\FRS\FRS 9596 - files for 1995/96 ... and so on.
*** THE PATH TO "FRS" FOLDER NEEDS TO BE SET BY THE USER IN THE FIRST BLOCK BELOW.
*** 3. RUNNING THE SYNTAX AND OUTPUTS
*** 1. SET UP THE FILES AS DIRECTED
*** 2. SET THE FILE HANDLE IN THE FIRST BLOCK OF CODE BELOW,
*** 3. SELECT ALL LINES IN THIS SYNTAX FILE AND RUN.
*** - ALL TEMPORARY AND WORKING FILES ARE CREATED IN THE 'FRS' FOLDER
*** - OUTPUTS ARE CREATED IN 'FRS' FOLDER: CHARTS FOR THE PAPER AND .CSV FILES.
*** THIS FILE:
*** 1. RUNS 'CHANGE' SYNTAX TO PRODUCE WORKING DATA FILE;
*** 2. RUNS SYNTAX FILES WHICH USE WORKING DATA FILE TO PRODUCE AGGREGATED DATA FILES,
*** AS WELL AS LEXIS SURFACES AND OTHER CHARTS ASSOCIATED WITH PAPER.
*** SET FILE HANDLE FOR 'FRS' DIRECTORY.
file handle frs / name="K:/Data store/FRS".
cd frs.
* change file
* combines required data from all the UKDS files into single working file.
insert file = "FRS HBAI - change - public v3.sps".
* tables file.
* produces .csv file with data for the Poverty and Housing Tenure data explorer - on-line app.
* produces heatmaps: Figures 2 and 4.
insert file = "FRS HBAI - tables - public v3.sps".
* Figure 1a - Line chart - tenure by year - adults and children separately.
insert file = "FRS HBAI - Fig 1a - public v3.sps".
* Figures 5, 6 and 10 - heatmaps for adults.
insert file = "FRS HBAI - Fig 5 - public v3.sps".
insert file = "FRS HBAI - Fig 6 - public v3.sps".
insert file = "FRS HBAI - Fig 10 - public v3.sps".
* tables file - children.
* produces .csv file with data for the Poverty and Housing Tenure data explorer - on-line app - children.
* produces heatmaps: Figures 3 and 7.
insert file = "FRS HBAI - tables ch - public v3.sps".
* Figure 1b - Line chart - tenure by year - adults and children separately.
insert file = "FRS HBAI - Fig 1b - public v3.sps".
* Figures 8a/b/c and 9 - line charts for children.
insert file = "FRS HBAI - Fig 8a - public v3.sps".
insert file = "FRS HBAI - Fig 8b - public v3.sps".
insert file = "FRS HBAI - Fig 8c - public v3.sps".
insert file = "FRS HBAI - Fig 9 - public v3.sps".
* tables file - quintiles and deciles.
* produces .csv file with data for Dan Cookson to make gifs.
* also produces additional heatmaps.
insert file = "FRS HBAI - tables - quin dec v3.sps".
* various calcs/percents used in the paper.
* open file created by 'change' file.
get file='FRS HBAI working file.sav' .
DATASET NAME main.
* var levels.
variable level tenure4 (nominal).
formats yearcode (f4.0).
* age - 1yr bands.
compute age2=age80.
var labels age2 'Age'.
if (age2 le 16) age2=16.
if (age2 ge 80) age2=80.
value labels age2 80 '80+'.
formats age2 (f2.0).
* freq age2 .
** abstract and conclusion figs.
* ads under 40 - tenure.
weight by gs_newbu.
temp.
select if (ad=1 and age2 lt 40).
crosstabs yearcode by tenure3 by low60ahc /cells row.
* children- tenure.
weight by gs_newbu.
temp.
select if (ch=1).
crosstabs yearcode by tenure2 by low60ahc /cells row.
*** for fig quoted in text, children 5 or under.
weight by gs_newbu.
temp.
select if (ch=1 and age lt 6).
crosstabs yearcode by tenure2 /cells row.