Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Martin Weiss" <martin.weiss1@gmx.de> |
To | <statalist@hsphsun2.harvard.edu> |
Subject | RE: st: FW: Urgent: Stored Data after the calculation |
Date | Sun, 28 Mar 2010 20:39:30 +0200 |
<> Maybe you wanted: ******* list if Cohort=="Group 2" & A09!=. ******* The string "and" was bound to cause an error message... HTH Martin -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of keeler james Sent: Sonntag, 28. März 2010 20:34 To: statalist@hsphsun2.harvard.edu Subject: RE: st: FW: Urgent: Stored Data after the calculation BTW, one more question. What if the groups are ever changing, e.g. sometimes groups 1 and 4 are missing, and it will end up like the following: Cohort Tot08 Tot09 A08 A09 Group 2 10 3 0 ? Group 3 3 4 2 ? Group 5 3 8 0 ? Group 6 0 31 0 ? Group 7 266 245 181 ? if we use the same display command -di in r "Second value of A09: " A09[2]-, it will show the value of Group 3 instead of Group 2. I try in vain to use the following command di in r if Cohort=="Group 2" and A09!=. to lock the output to Group 2 but there was an error message. Any help will be great! Cal ---------------------------------------- > From: 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/ _________________________________________________________________ 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/ * * 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/