Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| 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/