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/