Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: reshaping a data file: cell frequency = number of rows in the new data set


From   "Scott Merryman" <[email protected]>
To   <[email protected]>
Subject   st: RE: reshaping a data file: cell frequency = number of rows in the new data set
Date   Thu, 16 Dec 2004 20:27:20 -0600

> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of G. ter Riet
> Sent: Thursday, December 16, 2004 6:12 PM
> To: [email protected]
> Subject: st: reshaping a data file: cell frequency = number of rows in the
> new data set
> 
> Dear List members,
> In the context of a diagnostic meta-analysis, I have data from 2x2
> tables (cells a thru' d, signifying true positives, false positives,
> etc). My file has a wide format and is perfectly suited for a meta-
> analytic command like <metan a b c d, or>.
> As a hypothetical example, suppose one of my studies (rows) contained
> the cell frequencies 1 2 3 4, for variables a, b, c, d, respectively.
> How could I efficiently create another file (long format), based on
> these data, that looked like
> 1 1
> 1 0
> 1 0
> 0 1
> 0 1
> 0 1
> 0 0
> 0 0
> 0 0
> 0 0
> where the 1st column signified a binary test result, and the 2nd
> column a binary outcome according to a reference standard (gold
> standard test).
> Any help would be much appreciated.
> 
> Gerben ter Riet, Amsterdam
> 

For those, like me, unfamiliar with meta-analysis and its data structure, it
might make it easier if we know what your (hypothetical) data looks like
now.

Scott



*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index