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
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
                                  META-SPSS


***** The link to the META-SPSS.ZIP archive is at the bottom of this page. *****



DISCLAIMER
----------

META-SPSS is provided "as is" without warranty of any kind. The entire risk
as to the quality, performance, and fitness for intended purpose is with you.
You assume responsibility for the selection of the program and for the use of
results obtained from that program.


DESCRIPTION
-----------

This collection of files adds meta-analytic facilities to SPSS:

1. Meta-analysis of P values (see 'MetaPValues-Info.txt' for technical details).

2. Meta-analysis of binary outcomes: RD, OR and RR, with both fixed & random
   effects (DerSimonian-Laird) models. Raw data (counts) or summary data
   (adjusted OR, RR or RD) can be used as input. Different fixed effects models:
   inverse variance (Woolf method), Mantel-Haenszel and Peto (this last only
   for OR) are available for raw data (counts); for summary data only the first.

3. Meta-analysis of continuous outcomes: unstandardised & standardised (Hedges,
   Cohen & Glass) mean differences, with both fixed (inverse variance) & random
   effects (DerSimonian-Laird) methods. Means, SD & N or Cohen's d can be used
   for input (except for Glass method, which requires means, SD & N).
   Orwin's Fail Safe N is computed for significant results. 

4. Meta-analysis of correlation coefficients: Hedges-Olkin fixed & random
   effects models (inverse variance & Dersimonian-Laird).
   Orwin's Fail Safe N is computed for significant results.

5. Meta-analysis of correlation coefficients: Schmidt-Hunter method (simplified,
   unreliability or range departure correction methods are not included). See
   Larry Lyons paper & website (details in folder "Documents") for details.

For methods 1 to 4, Higgins' I2 with its 95%CI is calculated
(see 'Higgins I2 formula.txt' for details and a reference).

For methods 2, 3 & 4, forest plots are also included (see below for a limitation). 

You must know meta-analysis before using them, although some short documents with
meta-analysis theory & formulae are included in the folder "Documents". I recommend
reading Andy Field's papers (Meta1.pdf, Metar.pdf & Metad.pdf)and taking a look at
his website. A text file with useful references (mainly from British Medical Journal)
and tutorials is also included.

A very good book on the topic is 'Systematic Reviews in Health Care' Edited by
Mathias Egger, George Davey Smith & Douglas G Altman. BMJ Books, 2nd Ed (2001).
(ISBN: 0-7279-1488-X).

Feel free to edit & modify every file. If you improve the code, I would like to
have a copy.

Questions can be sent to me: Marta Garcia-Granero (biostatistics@terra.es).


SPSS files included:
-------------------

- MetaDatasets.SPS: creates in drive A: a collection of datasets from published
  meta-analysis, mainly from British Medical Journal. Must be run once to obtain
  the datasets that MetaTests.SPS requires.

- MetaAnalysisOfxxxxxxx.SPS: Syntax files for meta-analytic methods 1 to 5.
  The name, a bit long, it's related to the method:

     Method           File
   ----------------------------------------------------------
   Odds Ratio:
     Peto           MetaAnalysisOfBinOutcomes(OR-Peto).SPS
     M-H            MetaAnalysisOfBinOutcomes(OR-MH).SPS
     Inv Var        MetaAnalysisOfBinOutcomes(OR-IV).SPS
     DerS-Laird     MetaAnalysisOfBinOutcomes(OR-DL).SPS
     Summary data   MetaAnalysisOfBinOutcomes(SumOR-IV).SPS
                    MetaAnalysisOfBinOutcomes(SumOR-DL).SPS

   Risk Ratio:
     M-H            MetaAnalysisOfBinOutcomes(RR-MH).SPS
     Inv Var        MetaAnalysisOfBinOutcomes(RR-IV).SPS
     DerS-Laird     MetaAnalysisOfBinOutcomes(RR-DL).SPS
     Summary data   MetaAnalysisOfBinOutcomes(SumRR-IV).SPS
                    MetaAnalysisOfBinOutcomes(SumRR-DL).SPS

   Risk Diff:
     M-H            MetaAnalysisOfBinOutcomes(RD-MH).SPS
     Inv Var        MetaAnalysisOfBinOutcomes(RD-IV).SPS
     DerS-Laird     MetaAnalysisOfBinOutcomes(RD-DL).SPS
     Summary data   MetaAnalysisOfBinOutcomes(SumRD-IV).SPS
                    MetaAnalysisOfBinOutcomes(SumRD-DL).SPS

  Mean Difference:
     Inv Var        MetaAnalysisOfContOutcomes(WM-IV).SPS
     DerS-Laird     MetaAnalysisOfContOutcomes(WM-DL).SPS

  Hedges G (Stand. Mean Difference):
     Inv Var        MetaAnalysisOfContOutcomes(G-IV).SPS
     DerS-Laird     MetaAnalysisOfContOutcomes(G-DL).SPS
     Summary data   MetaAnalysisOfContOutcomes(SumG-IV).SPS
                    MetaAnalysisOfContOutcomes(SumG-DL).SPS

  Cohen d (Stand. Mean Difference):
     Inv Var        MetaAnalysisOfContOutcomes(D-IV).SPS
     DerS-Laird     MetaAnalysisOfContOutcomes(D-DL).SPS
     Summary data   MetaAnalysisOfContOutcomes(SumD-IV).SPS
                    MetaAnalysisOfContOutcomes(SumD-DL).SPS

  Glass delta (Stand. Mean Difference):
     Inv Var        MetaAnalysisOfContOutcomes(Delta-IV).SPS
     DerS-Laird     MetaAnalysisOfContOutcomes(Delta-DL).SPS

  Correlation (Hedges-Olkin):
     Inv Var        MetaAnalysisOfCorrCoef(HO-IV).SPS
     DerS-Laird     MetaAnalysisOfCorrCoef(HO-DL).SPS

  Correlation (Schmidt-Hunter):
                    MetaAnalysisOfCorrCoef(SH).SPS

  P Values:
                    MetaAnalysisOfPvalues.SPS
  ----------------------------------------------------------

- ForOR.SPS:  For binary outcomes the information included assumes that RR
  and RD are the summary data of interest. This syntax has to be run after
  loading binary outcomes files if OR is the summary measure of interest.
  ForOR.SPS creates 4 extra variables, called: caex, canex, coex & conex.

- MetaTests.SPS: a syntax file that shows the use of the different method
  files.

- XXXXXX.sct: several chart templates that work with SPSS 11.5 or older.

- Two SAV files in "Temp" folder: they are created by files of methods 2-4.
  They were originally included in the ZIP file to be sure that the "Temp"
  folder is created during installation, because several syntax files store
  information in Temp and it must exist to avoid errors.


INSTALLATION
------------

- Download META-SPSS.ZIP and unzip its contents to a floppy disk (drive A:).
- Run MetaDatasets.SPS once to create the 12 example datasets.
- Open MetaTests.SPS and run it to see how the files work.


ACCURACY OF THE METHODS
-----------------------

I have tried to check the output with published datasets and other programs
(Review Manager, Meta, Easy Meta Analysis, Combine...) and, to my knowledge,
everything is OK.

An extra check was performed comparing META-SPSS output with tables 15.4 & 15.6
of 'Systematic Reviews in Health Care' (p 303-306), using the same datasets.
If you want to check that results with META-SPSS are correct, the datasets are
included as 'MetaDataset(XII).sav' (binary outcomes) & 'MetaDataset(XIII).sav'
(continuous outcomes).

                           Table 15.4
 Method         Estimate (95% CI)        Sig of effect(*)  Heterogeneity
 ---------------------------------------------------------------------------
 Odds Ratio:
   Peto         0.59 (0.51 to 0.69)      z=7.05 (p<0.001)  X2=38.5 (p<0.001)
   M-H          0.59 (0.51 to 0.69)      z=6.98 (p<0.001)  X2=38.9 (p<0.001)
   Inv Var      0.60 (0.52 to 0.70)      z=6.70 (p<0.001)  X2=38.8 (p<0.001)
   DerS-Laird   0.54 (0.34 to 0.85)      z=2.64 (p=0.008)

 Risk Ratio:
   M-H          0.79 (0.74 to 0.85)      z=6.95 (p<0.001)  X2=29.8 (p<0.001)
   Inv Var      0.80 (0.75 to 0.85)      z=7.14 (p<0.001)  X2=29.7 (p<0.001)
   DerS-Laird   0.77 (0.64 to 0.92)      z=2.93 (p=0.003)

 Risk Diff:
   M-H         -0.117 (-0.149 to -0.085) z=7.13 (p<0.001)  X2=33.1 (p<0.001)
   Inv Var     -0.127 (-0.158 to -0.095) z=7.86 (p<0.001)  X2=32.7 (p<0.001)
   DerS-Laird  -0.124 (-0.211 to -0.038) z=2.81 (p=0.005)
 ---------------------------------------------------------------------------

                           Table 15.6
 Method         Estimate (95% CI)        Sig of effect(*)  Heterogeneity
 ---------------------------------------------------------------------------
 Fixed effect models:
   Cohen's d   -0.16 (-0.41 to 0.08)     z=1.29 (p=0.20)   X2=2.34 (p=0.31)
   Hedges' g   -0.16 (-0.41 to 0.08)     z=1.29 (p=0.20)   X2=2.31 (p=0.32)
   Glass's d   -0.16 (-0.40 to 0.09)     z=1.24 (p=0.21)   X2=2.28 (p=0.32)

 Random effects models:
   Cohen's d   -0.15 (-0.42 to 0.12)     z=1.12 (p=0.26)
   Hedges' g   -0.15 (-0.42 to 0.11)     z=1.12 (p=0.26)
   Glass's d   -0.15 (-0.42 to 0.12)     z=1.10 (p=0.27)
---------------------------------------------------------------------------
 (*) META-SPSS gives a X2 test, mathematically equivalent (X2=(Z)2).
---------------------------------------------------------------------------

LIMITATIONS & KNOWN BUGS
------------------------

Cumulative meta-analysis is not possible... yet (I'm working on that). Check
this website from time to time to see if I have updated META-SPSS.

The syntax files assume that everything runs from a floppy disk (A:). You will
have to edit every 'Meta...SPS' file (including MetaTests.SPS & MetaDatasets.SPS)
and replace every "A:" by a suitable drive&path if you want to run them from
other location.

This code was developed before SPSS 12 was released, and the chart templates
included will only work with SPSS 11.5 or older. The graphs will need formatting
if SPSS 12 is used (good luck, I never succeeded trying to apply chart templates
in v12, and some options, available in older versions, have dissapeared).