Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

RE: st: FW: [...] Stored Data after the calculation


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: FW: [...] Stored Data after the calculation
Date   Mon, 29 Mar 2010 12:53:16 +0100

This was well answered by Martin Weiss, but keeler james or Calchas could have answered part of his or her question by studying the help for -display- 

"and", as Martin pointed out, was guessed but illegal syntax. 

In addition, -display- does not support -if-. If a command supports -if- it is always explicit in the help. 

By the way, I think only the moderator has the right to claim urgency on this list. 

Nick 
n.j.cox@durham.ac.uk 

keeler james

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
>
> Brilliant! Many thanks, Martin - have a good weekend!
>
>
>> From: martin.weiss1@gmx.de

>> 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'
>> *******
>>
>> From: keeler james [mailto:keelercalchas@hotmail.com]
>
>> 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

>> 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.

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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index