Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Thaker, Anant" <athaker@mba2011.hbs.edu> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
Re: st: question on line graphs |

Date |
Mon, 19 Apr 2010 01:19:17 -0400 |

Dear Michael, Thanks so much. This was enormously helpful! Best, Anant Sent from my iPhone On Apr 19, 2010, at 1:17 AM, "Michael Norman Mitchell" <Michael.Norman.Mitchell@gmail.com > wrote: > Dear Anant > > You are most welcome! > > Note how the variable -rtax- was coded as 1 and 0. The -collapse- > command creates the proportion of people who had a response of -1- on > the outcome, broken down by cohort and year. So, that has replaced the > original dataset in memory. > > Indeed, you are right, that after that command has been issued, you > would need to return to the original dataset for other analyses. You > could, if you prefer, use the -preserve- command before -collapse- and > -restore- after the -graph- command to return back to the dataset when > the -preserve- command was issued. > > Best regards, > > Michael N. Mitchell > See the Stata tidbit of the week at... > http://www.MichaelNormanMitchell.com > > On 2010-04-18 10.06 PM, Thaker, Anant wrote: >> Dear Mitchell, >> >> Thank you! This worked very well. Just a question: could you >> briefly explain the purpose of 'collapse rtax , by(cohort year)'? >> If I want to repeat this procedure with other variables, I'd have >> to reload the full GSS dataset, correct? >> >> Thanks again, >> Anant >> >> Anant Thaker >> MBA Class of 2011 >> Harvard Business School >> athaker@mba2011.hbs.edu >> +1 646-964-7123 >> >> >> -----Original Message----- >> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner- >> statalist@hsphsun2.harvard.edu] On Behalf Of Michael Norman Mitchell >> Sent: Sunday, April 18, 2010 11:32 PM >> To: statalist@hsphsun2.harvard.edu >> Subject: Re: st: question on line graphs >> >> Dear Anant >> >> Will this do the trick... >> >> ****************************************** >> * CREATE FAKE DATASET >> clear >> set obs 10 >> generate year = 1995 + _n >> expand 4 >> sort year >> generate cohort = mod((_n-1),4)+1 >> tab year cohort >> expand 100 >> generate tax = int(uniform()*5)+1 >> tab tax >> recode tax (1 2=1 "1 or 2") (3 4 5=0 "3,4,5"), gen(rtax) >> tab tax rtax >> ****************************************** >> >> * Start of real code >> >> * collapse to get proportions >> collapse rtax , by(cohort year) >> * Convert to percentage >> replace rtax = rtax*100 >> * separate into four variables by cohort >> separate rtax, by(cohort) >> * graph it >> graph twoway (line rtax1 rtax2 rtax3 rtax4 year), /// >> xlabel(1996(1)2005, angle(45)) /// >> legend(label(1 "Cohort 1") label(2 "Cohort 2") label(3 "Cohort 3") >> label(4 "Cohort 4")) >> >> And here is the graph that it creates >> >> http://screencast.com/t/Y2FkZGQ0Y2U >> >> Hope that helps, >> >> Michael N. Mitchell >> See the Stata tidbit of the week at... >> http://www.MichaelNormanMitchell.com >> >> On 2010-04-18 8.06 PM, Thaker, Anant wrote: >> >>> I am a Stata 11/SE user. In my dataset, I have a cohort variable >>> coded 1-4 with the various subgroups (e.g. 1 =<1934, 2 = >>> 1934-1948, etc.), and an ordered variable that shows views on >>> progressive taxation (coded 1-5 in terms of relative support). >>> These data points are spread over a number of years (from the >>> General Social Survey). I'm trying to chart out the % of >>> respondents who selected 1 or 2 on the taxation variable, by >>> cohort subgroup, over time. So the x-axis would be year, the y- >>> axis would be "% who chose 1 or 2," and there would be four line >>> graph series (one for each cohort subgroup). Would really >>> appreciate some help! I can clarify as needed. Thanks! >>> >>> Note: data is currently coded as this example: >>> YEAR COHORT TAXATION >>> 2008 1965 1 >>> YEAR COHORT TAXATION >>> 1996 1975 3 >>> ... >>> >>> Best, >>> Anant >>> >>> >>> >>> * >>> * 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/ >> >> >> * >> * 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/ > * * 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/

**References**:**st: question on line graphs***From:*"Thaker, Anant" <athaker@mba2011.hbs.edu>

**Re: st: question on line graphs***From:*Michael Norman Mitchell <Michael.Norman.Mitchell@gmail.com>

**RE: st: question on line graphs***From:*"Thaker, Anant" <athaker@mba2011.hbs.edu>

**Re: st: question on line graphs***From:*Michael Norman Mitchell <Michael.Norman.Mitchell@gmail.com>

- Prev by Date:
**RE: st: question on line graphs** - Next by Date:
**Re: st: question on line graphs** - Previous by thread:
**Re: st: question on line graphs** - Next by thread:
**st: RE: question on line graphs** - Index(es):