Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | P C <calicep@yahoo.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: stata results - reshape |
Date | Mon, 13 Dec 2010 06:48:11 -0800 (PST) |
Hi I have stata results that look like this (a subset of a very long list presented here): svyset psuscid [pweight=gswgt1], strata(region) svy, subpop(w1subsplflg): mean w1rbwtgrm, over (w1biomomagebbn) -------------------------------------------------------------- | Linearized Over | Mean Std. Err. [95% Conf. Interval] -------------+------------------------------------------------ w1rbwtgrm | 7 | 3909.966 8.61e-14 3909.966 3909.966 14 | 1360.777 1.17e-13 1360.777 1360.777 15 | 3574.094 131.4519 3313.994 3834.194 16 | 2973.076 241.0919 2496.034 3450.117 The above is estimated using survey methods. I want to transform the results into the format like this: 7 14 15 16 3909.966 1360.777 3574.094 2973.076 The first line represents biological mother's age when her baby was born; the second line represents baby's birth weight. I want to put the transformed result into MS excel, and plot it with age on the X axis and birth weight on the Y axis. Can anyone help me with this? Or Stata can directly plot it for survey analysis. Thanks! * * 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/ * * 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/