st: stata results - reshape

[P C <calicep@yahoo.com>]

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/