Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Obtaining proportion estimates in a stata data file after multiple imputation


From   Tim Evans <Tim.Evans@wmciu.nhs.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: Obtaining proportion estimates in a stata data file after multiple imputation
Date   Mon, 31 Oct 2011 10:43:17 +0000

Hi all,

I am obtaining proportion estimates from an mi dataset, currently this sits in the results window. Can anyone tell me how I return the results to a stata data file.

I am running the following code in Stata v11.2:

BEGIN CODE:

ice stage  morph grade i.icd10 sex yydx i.fxid i.fxage status, /*
 */ saving (impute,replace) cmd(stage grade: ologit) seed(123456) m(25) replace

use impute, replace


. mim: proportion stage if _mj>0, over(yydx)

OUTPUT OF CODE:

[note: using ice-style format variables _mi and _mj]

Multiple-imputation estimates (proportion)               Imputations =      25
Proportion estimation                                    Minimum obs =   70909
                                                         Minimum dof =    51.9

------------------------------------------------------------------------------
  Proportion |     Coef.  Std. Err.     t    P>|t|    [95% Conf. Int.]     FMI
-------------+----------------------------------------------------------------
_prop_1      |
        1985 |   .022055    .00379    5.82   0.000    .014508  .029602   0.566
        1986 |   .020703   .003733    5.55   0.000    .013268  .028138   0.574
        1987 |   .018713   .003597    5.20   0.000    .011552  .025874   0.563
        1988 |   .022556   .003529    6.39   0.000    .015574  .029539   0.437
        1989 |   .014867   .002918    5.10   0.000    .009095   .02064   0.438
        1990 |   .012352   .002774    4.45   0.000    .006851  .017853   0.491
        1991 |   .012645   .003011    4.20   0.000    .006647  .018643   0.575
        1992 |   .014356   .002824    5.08   0.000    .008761  .019951   0.465
        1993 |   .022948   .003902    5.88   0.000    .015211  .030685   0.489
        1994 |   .035661    .00507    7.03   0.000    .025579  .045743   0.544
        1995 |   .038542   .004816    8.00   0.000    .029029  .048055   0.401
        1996 |   .037689   .005221    7.22   0.000    .027307  .048071   0.545
        1997 |   .037221   .005182    7.18   0.000    .026922  .047519   0.533
        1998 |   .038863   .005748    6.76   0.000    .027403  .050323   0.589
        1999 |    .04579    .00509    9.00   0.000    .035741  .055839   0.384
        2000 |   .051865   .005378    9.64   0.000    .041251  .062478   0.374
        2001 |   .052264   .005871    8.90   0.000    .040632  .063895   0.468
        2002 |   .051469   .005781    8.90   0.000    .040031  .062907   0.438
        2003 |    .05477   .005876    9.32   0.000    .043159   .06638   0.407
        2004 |   .060442   .005714   10.58   0.000    .049178  .071705   0.344
        2005 |   .070209   .006365   11.03   0.000    .057661  .082758   0.344
        2006 |   .073847   .007101   10.40   0.000    .059793  .087902   0.446
        2007 |    .06947   .006243   11.13   0.000    .057142  .081798   0.392
        2008 |   .069523   .006789   10.24   0.000     .05606  .082987   0.491
        2009 |   .084467   .006607   12.78   0.000    .071427  .097506   0.377
-------------+----------------------------------------------------------------
_prop_2      |
        1985 |   .012082   .002478    4.88   0.000     .00718  .016984   0.433
        1986 |    .01373   .002933    4.68   0.000      .0079   .01956   0.537
        1987 |   .012543   .002949    4.25   0.000    .006673  .018412   0.562
        1988 |   .015688    .00296    5.30   0.000    .009832  .021543   0.440
        1989 |   .010133   .002641    3.84   0.000    .004884  .015382   0.534
        1990 |   .008675   .002007    4.32   0.000    .004722  .012628   0.307
        1991 |   .009047   .002321    3.90   0.000    .004445  .013648   0.483
        1992 |   .009656   .002947    3.28   0.002     .00375  .015563   0.674
        1993 |   .014054   .003063    4.59   0.000     .00798  .020129   0.488
        1994 |   .023774   .003843    6.19   0.000    .016164  .031384   0.461
        1995 |    .02376   .003942    6.03   0.000     .01596   .03156   0.442
        1996 |   .021106   .003249    6.50   0.000    .014706  .027507   0.320
        1997 |   .023123   .003491    6.62   0.000    .016242  .030004   0.342
        1998 |   .024966   .004226    5.91   0.000    .016582  .033351   0.500
        1999 |   .029734   .004504    6.60   0.000    .020804  .038664   0.484
        2000 |   .027391   .004445    6.16   0.000    .018568  .036214   0.508
        2001 |   .026802   .003951    6.78   0.000    .019004  .034601   0.378
        2002 |   .030359   .004338    7.00   0.000    .021791  .038928   0.397
        2003 |   .030805   .004624    6.66   0.000    .021652  .039958   0.450
        2004 |    .03441   .005001    6.88   0.000    .024486  .044333   0.504
        2005 |   .040164   .004965    8.09   0.000     .03037  .049959   0.364
        2006 |   .037496   .004725    7.94   0.000    .028184  .046808   0.336
        2007 |   .039125   .004743    8.25   0.000     .02976   .04849   0.388
        2008 |   .037074   .004635    8.00   0.000    .027922  .046227   0.393
        2009 |    .04532   .004486   10.10   0.000    .036502  .054138   0.239
-------------+----------------------------------------------------------------
_prop_3      |
        1985 |   .065537    .00651   10.07   0.000    .052563  .078512   0.583
        1986 |   .069408   .006586   10.54   0.000    .056297  .082519   0.563
        1987 |    .07441   .006395   11.64   0.000    .061736  .087085   0.478
        1988 |   .073028   .007732    9.44   0.000    .057558  .088497   0.646
        1989 |   .064019   .007336    8.73   0.000    .049345  .078692   0.643
        1990 |   .053333   .005803    9.19   0.000    .041808  .064859   0.520
        1991 |   .055141    .00661    8.34   0.000    .041927  .068355   0.634
        1992 |   .059276   .005872   10.09   0.000    .047617  .070936   0.514
        1993 |   .076437   .006629   11.53   0.000    .063321  .089553   0.441
        1994 |   .100886   .007119   14.17   0.000    .086833  .114939   0.383
        1995 |   .103487   .009612   10.77   0.000    .084275  .122698   0.630
        1996 |   .110448   .008098   13.64   0.000    .094393  .126503   0.485
        1997 |   .115888   .008253   14.04   0.000    .099536  .132241   0.471
        1998 |   .119761   .008191   14.62   0.000    .103567  .135954   0.420
        1999 |   .133708    .00861   15.53   0.000    .116678  .150737   0.431
        2000 |   .148091   .009298   15.93   0.000    .129673  .166508   0.466
        2001 |   .153492   .009413   16.31   0.000    .134853   .17213   0.457
        2002 |    .16325   .010383   15.72   0.000    .142633  .183867   0.515
        2003 |   .160416   .008883   18.06   0.000    .142916  .177917   0.322
        2004 |   .181021   .008708   20.79   0.000    .163897  .198144   0.259
        2005 |   .183967   .009787   18.80   0.000    .164661  .203274   0.363
        2006 |   .183284   .010699   17.13   0.000    .162089  .204478   0.467
        2007 |   .176641   .009244   19.11   0.000    .158397  .194884   0.376
        2008 |   .171097   .009702   17.64   0.000     .15189  .190304   0.452
        2009 |   .209331   .008614   24.30   0.000    .192412  .226251   0.209
-------------+----------------------------------------------------------------
_prop_4      |
        1985 |   .900326   .007762  115.99   0.000    .884869  .915783   0.570
        1986 |   .896159   .008083  110.87   0.000     .88005  .912267   0.583
        1987 |   .894334    .00866  103.27   0.000    .877043  .911626   0.614
        1988 |   .888728   .008568  103.72   0.000    .871659  .905797   0.576
        1989 |   .910981   .007707  118.20   0.000    .895644  .926319   0.558
        1990 |    .92564   .006737  137.39   0.000    .912263  .939016   0.514
        1991 |   .923168   .008365  110.36   0.000    .906381  .939954   0.691
        1992 |   .916712   .007711  118.88   0.000    .901312  .932111   0.618
        1993 |   .886561   .008309  106.69   0.000    .870079  .903043   0.495
        1994 |   .839679   .008972   93.59   0.000     .82194  .857419   0.425
        1995 |   .834212   .010986   75.93   0.000    .812327  .856097   0.576
        1996 |   .830756   .009742   85.27   0.000    .811436  .850077   0.491
        1997 |   .823768   .009992   82.45   0.000    .803955  .843581   0.489
        1998 |    .81641   .010633   76.78   0.000    .795297  .837522   0.514
        1999 |   .790768   .009968   79.33   0.000    .771084  .810452   0.392
        2000 |   .772654   .010076   76.68   0.000    .752777   .79253   0.363
        2001 |   .767443   .010623   72.24   0.000    .746447  .788438   0.412
        2002 |   .754922   .011054   68.29   0.000    .733072  .776772   0.417
        2003 |   .754009   .010373   72.69   0.000    .733578  .774439   0.315
        2004 |   .724128   .010161   71.26   0.000    .704142  .744114   0.267
        2005 |   .705659   .011731   60.15   0.000    .682497  .728821   0.387
        2006 |   .705373   .012006   58.75   0.000    .681647  .729099   0.410
        2007 |   .714765   .011243   63.57   0.000    .692547  .736982   0.410
        2008 |   .722305   .011206   64.46   0.000    .700154  .744457   0.418
        2009 |   .660882   .009771   67.64   0.000    .641704   .68006   0.167
------------------------------------------------------------------------------

I'd like to store these in a stata data file.

Best wishes

Tim

_DISCLAIMER:
This email and any attachments hereto contains proprietary information, some or all of which may be confidential or legally privileged. It is for the exclusive use of the intended recipient(s) only. If an addressing or transmission error has misdirected this e-mail and you are not the intended recipient(s), please notify the author by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this e-mail or any attachments, as this may be unlawful.


*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index