Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | keeler james <keelercalchas@hotmail.com> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: FW: Urgent: Stored Data after the calculation |
Date | Sun, 28 Mar 2010 17:15:45 +0100 |
Brilliant! Many thanks, Martin - have a good weekend! Cal > From: martin.weiss1@gmx.de > To: statalist@hsphsun2.harvard.edu > CC: keelercalchas@hotmail.com > Subject: st: FW: Urgent: Stored Data after the calculation > Date: Sun, 28 Mar 2010 16:02:07 +0200 > > > <> > > > Try this, and switch your mail program to text only... All of this is > discussed in [U], sect. 13.7... > > ******* > clear* > > input str7 Cohort int(Tot08 Tot09 A08) > "Group 1" 48 66 17 > "Group 2" 10 3 0 > "Group 3" 3 4 2 > "Group 4" 1 0 0 > "Group 5" 3 8 0 > "Group 6" 0 31 0 > "Group 7" 266 245 181 > end > > gen A09=round((A08/Tot08)*Tot09) > > list, noo > > di in r "First value of A09: " A09[1] > di in r "Second value of A09: " A09[2] > di in r "Double the first value of A09: " 2*A09[1] > > *store second value in a -local- > local second=A09[2] > di in r `second' > ******* > > > HTH > Martin > > From: keeler james [mailto:keelercalchas@hotmail.com] > Sent: Sonntag, 28. März 2010 15:10 > To: martin.weiss1@gmx.de; statalist@hsphsun2.harvard.edu > Subject: FW: Urgent: Stored Data after the calculation > > Hi Martin, > > Thanks for the prompt response. > > The message attached is my original request, which got bounced back: > > For Group1, the calculated value for A09 is 23.4; for Group2, the calculated > value is 0 and so on for the rest of the groups. But how can I reuse 23.4 > (Group 1, A09) in one specific (further) calculation and 0 (Group2, A09) in > a separate (further) calculation? > > I think it should be quite easy, but I just don't know how to do that. > > Calchas > ________________________________________ > From: keelercalchas@hotmail.com > To: statalist@hsphsun2.harvard.edu > Subject: FW: Urgent: Stored Data after the calculation > Date: Sat, 27 Mar 2010 00:06:41 +0000 > > Dear Statalist, > > I have the following table with column "A09" needed to be calculated. > > Cohort Tot08 Tot09 A08 A09 > > Group 1 48 66 17 ? > Group 2 10 3 0 ? > Group 3 3 4 2 ? > Group 4 1 0 0 ? > Group 5 3 8 0 ? > Group 6 0 31 0 ? > Group 7 266 245 181 ? > > I use the command: > > gen A09=round((A08/Tot08)*Tot09) > > This will work well for the missing column "A09", but how can I reuse the > calculated numbers to do further calculations? > > I know it is something relating to the command of stored data, i.e.: > > local missing=r(N) > > but this is only for a scalar value, what about saving and reusing the > entire column? Really stuck at the moment and any help will be appreciated. > > Ta, > Calchas > > > ________________________________________ > Do you have a story that started on Hotmail? Tell us now > ________________________________________ > Do you want a Hotmail account? Sign-up now - Free > ________________________________________ > Do you have a story that started on Hotmail? Tell us now > ________________________________________ > Got a cool Hotmail story? Tell us now > > > * > * 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/ _________________________________________________________________ Send us your Hotmail stories and be featured in our newsletter http://clk.atdmt.com/UKM/go/195013117/direct/01/ * * 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/