Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# st: need graph help

 From "Averett, Susan L" To statalist@hsphsun2.harvard.edu Subject st: need graph help Date Tue, 19 Apr 2011 11:37:13 -0400 (EDT)

```Hi all: I am trying to do something that should be easy but I haven't had any luck. I simply want to graph the mean obesity proportion in my data over time by gender. In Stata I have the following. How can I make this into a line graph where I am graphing the trend in proportion obese over time? I really just want to graph the means below with year on the X-axis and proportion obese on the Y by gender. So for 1987, 12 percent of females were obese and 11.9 percent of males were obese. that would be the data point for 1987 etc.
Can anyone help?
thanks,
Susan
bys male year: sum obese

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1987

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     18642    .1200515    .3250305          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1988

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     21035    .1196577    .3245686          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1989

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     24042    .1309791    .3373845          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1990

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     30193    .1412579    .3482932          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1991

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     31815    .1494578    .3565448          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1992

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     34753    .1541162    .3610653          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1993

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     47973    .1466033    .3537137          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1994

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     49118    .1548923    .3618057          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1995

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     52918    .1605503    .3671191          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1996

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     56520    .1685775    .3743816          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1997

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     61517    .1753824     .380297          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1998

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     67286    .1896531    .3920295          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 1999

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     71781    .1985484    .3989099          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2000

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     82714    .2096018    .4070269          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2001

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     92157    .2175961    .4126135          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2002

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    109993    .2233142    .4164691          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2003

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    120083     .239093    .4265314          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2004

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    141768    .2457536    .4305347          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2005

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    165126    .2617395    .4395829          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2006

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    164577    .2654198    .4415578          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2007

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    203739    .2776837    .4478576          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 0, year = 2008

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    197200    .2800862    .4490423          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1987

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     13410    .1111111    .3142814          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1988

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     14794    .1145059    .3184355          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1989

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     17409    .1214314    .3266374          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1990

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     20501    .1234574    .3289695          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1991

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     23050    .1321475    .3386584          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1992

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     25337    .1441765    .3512755          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1993

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     37200    .1413441    .3483808          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1994

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     36956    .1502598    .3573307          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1995

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     40289    .1602671    .3668581          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1996

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     42970    .1647428    .3709526          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1997

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     47021    .1750494    .3800134          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1998

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     50974    .1881547    .3908395          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 1999

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     53615    .2021822    .4016312          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2000

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     61648    .2116533    .4084836          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2001

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     69159    .2214896    .4152523          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2002

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     80422    .2298252    .4207229          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2003

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     85560    .2381954    .4259818          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2004

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |     97931    .2452033    .4302098          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2005

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    112038    .2605812    .4389537          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2006

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    111176    .2692218    .4435574          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2007

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    133048    .2802372    .4491167          0          1

------------------------------------------------------------------------------------------------------------------
-> male = 1, year = 2008

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
obese |    129781    .2848106    .4513259          0          1

.

Susan Averett
Dana Professor
Department of Economics
Lafayette College
Easton, PA 18042
phone: 610-330-5307
fax: 610-330-5715
email: averetts@lafayette.edu

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