Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# RE: st: RE: Means for Metan

 From "Nick Cox" To Subject RE: st: RE: Means for Metan Date Mon, 12 Apr 2010 22:14:59 +0100

```That's a bit clearer. Thanks.

On the understanding that the first, second, ... observation contain information for 0, 1, ... mentions

gen wt = _n - 1
su j? [fw=wt]

Nick
n.j.cox@durham.ac.uk

Aggie Chidlow

Dear Nick (and others),
Sincerely Appologies.
It is not my intention for you to do any guess work...

I am working on a meta-analysis the data I have looks like this:

All Data Collection    | Name of the journal the article appeared
Procedures together  | J1 J2    J3 J4                             | Total
Not Mention             | 68 41    32 25                            | 166
One Step mention     | 17 14    17 12                            | 60
Two Steps mention    | 8    9     8 5                              | 30
Three Steps mention | 4     5    2 6                               | 17
Four Steps mention   | 1    2     1 1                              | 5
Five Steps mention    | 1  0 0 0                                  | 1
----------------------+--------------------------------------------+----------
Total                         | 99 71 60 49                            | 279

Today, it was suggested to me that I could calculate the mean number
of mentions, within each of 4 journals and then
perform metan to calculate a weighted average mean across the 4
journals. In order to do this I have to transpose the data from the table
above to this:

Data Collection Procedures j1   j2   j3   j4   total
> Not Mentioned              68   41   32   25   166
> One Step Mentioned      17   14   17   12    60
> Two Steps Mentioned     8    9    8    5    30
> Three Steps Mentioned    4    5    2    6    17
> Four Steps Mentioned     1    2    1    1     5
> Five Steps Mentioned     1    0    0    0     1

I am stuck at this point, because I am struggling to figure out how to
calculate the mean number of mentions with their standard errors for
this data.

On Mon, Apr 12, 2010 at 9:49 PM, Nick Cox <n.j.cox@durham.ac.uk> wrote:
> Please show us the data you want to work on.
> Please don't ask us to imagine, guess or work out what they looks like.
>
> Nick
> n.j.cox@durham.ac.uk
>
> Aggie Chidlow
>
>
> I have the following data:
>
> Steps                          j1   j2   j3   j4   total
> Not Mentioned              68   41   32   25   166
> One Step Mentioned      17   14   17   12    60
> Two Steps Mentioned     8    9    8    5    30
> Three Steps Mentioned    4    5    2    6    17
> Four Steps Mentioned     1    2    1    1     5
> Five Steps Mentioned     1    0    0    0     1
>
> I would very much appreciated if somebody could help me with the
> syntax to calculate the
> mean number of mentions with their standard error after  . keep j1 j2
> j3 j4 total       and
> . xpose,clear are used.
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```