Bookmark and Share

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: Difference of values in the same column/variable


From   Gokhan Yilmaz <[email protected]>
To   [email protected]
Subject   Re: st: Difference of values in the same column/variable
Date   Thu, 24 Nov 2011 17:32:28 -0500

Thanks a lot for the ideas Anna and Tirthankar. i was trying your
suggestions and this came to my mind and it solved the issue:

replace ewdiffret=. if ewdiffret==0  // I would get so many 0 values
for a reason i do not know.
egen ewmax=max(ewdiffret), by(t)
replace ewdiffret= -1*ewmax

Best,

Gokhan

On Wed, Nov 23, 2011 at 9:37 PM, Tirthankar Chakravarty
<[email protected]> wrote:
> You have a panel setup and for error-free handling in cases like this,
> use Stata's -xt- machinery:
>
> *****************************************
> clear*
> input group  str7 time    ewportret
> 1       2007m4  .0375245
> 1       2007m5  .0397919
> 1       2007m6  -.0188678
> 0       2007m4  .041679
> 0       2007m5  .0449738
> 0       2007m6  -.0240277
> end
> g time2 = monthly(time, "YM")
> format time2 %tm
> xtset group time2
> g dewportret = D.ewportret
> li
> *****************************************
> T
>
> On Wed, Nov 23, 2011 at 6:23 PM, Anna Reimondos <[email protected]> wrote:
>> Hi Gokhan
>> Maybe something like
>>
>>
>> gen newvar=.
>> gsort time -group
>> bysort time: replace newvar=ewportret-ewportret[_n+1] if group==1 &
>> group[_n+1]==0
>>
>> Or in a loop
>>
>> gen newvar=.
>> forvalues n=1/6 {
>> replace newvar=ewportret-ewportret[`n'] if time==time[`n'] & group==1
>> }
>>
>>
>> Anna
>>
>>
>> On Tue, Nov 15, 2011 at 1:21 PM,  <[email protected]> wrote:
>>> Dear All,
>>>
>>> How can i create a new variable that is equal to the difference in ewportret
>>> (see below table) between two groups in the same month?
>>> For example: the first row of the newvar below would be equal to (.0375245-
>>> .041679) and the second row would be equal to(.0397919- .0449738)
>>>
>>>
>>> group   time    ewportret  newvar
>>>
>>> 1       2007m4  .0375245
>>> 1       2007m5  .0397919
>>> 1       2007m6  -.0188678
>>> 0       2007m4  .041679
>>> 0       2007m5  .0449738
>>> 0       2007m6  -.0240277
>>>
>>>
>>> Thank you
>>>
>>> Gokhan
>>>
>>>
>>> *
>>> *   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/
>>
>
>
>
> --
> Tirthankar Chakravarty
> [email protected]
> [email protected]
>
> *
> *   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index