Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: FW: Urgent: Stored Data after the calculation
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
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: [email protected]
[mailto:[email protected]] On Behalf Of keeler james
Sent: Sonntag, 28. März 2010 20:34
To: [email protected]
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: [email protected]
> To: [email protected]
> 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: [email protected]
>> To: [email protected]
>> CC: [email protected]
>> 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:[email protected]]
>> Sent: Sonntag, 28. März 2010 15:10
>> To: [email protected]; [email protected]
>> 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: [email protected]
>> To: [email protected]
>> 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/