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

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: st: FW: [...] Stored Data after the calculation
Date   Mon, 29 Mar 2010 14:00:02 +0200

<> 


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



See the policy re "histrionics" at
http://www.stata.com/statalist/archive/2008-04/msg01286.html. This could be
incorporated into the FAQ, I think...



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Nick Cox
Gesendet: Montag, 29. März 2010 13:53
An: statalist@hsphsun2.harvard.edu
Betreff: RE: st: FW: [...] Stored Data after the calculation

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/


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