Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: How to construct a duration variable?


From   "Albert Newton" <lacneo@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: How to construct a duration variable?
Date   Thu, 6 Apr 2006 11:00:23 -0700

I know.  The duration variable in my first email could be made by
muliplying the duration variable in my second email with switch
variable.  And I think the duration variable in my second email makes
more sense.

Thanks,

Albert

On 4/6/06, Alex Ogan <aogan@arrowstreetcapital.com> wrote:
> This doesn't match your first example table -- the first time, you had
> duration == 0 in all cases that a switch did not take place.
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Albert Newton
> Sent: Thursday, April 06, 2006 1:42 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: RE: How to construct a duration variable?
>
> Thank you, Nick.
>
> For example,  there are three brands in the market: A, B and C.  One
> consumer buy A at the first period.  At the second period, she
> switches to B.  Since then, she keeps buying B for the next four
> periods.  After that, she switches to C etc.
>
> Then the duration variable I want should be:
>
> hhid    Period   Brand    Switch  Duration
> 1         1         A           0           1
> 1         2         B           1           4
> 1         3         B           0           4
> 1         4         B           0           4
> 1         5         B           0           4
> 1         6         C           1           2
> 1         7         C           0           2
> 1         8         A           1           1
> 1         9         B           1           4
> 1        10         B           0           4
> 1        11         B           0           4
> 1        12         B           0           4
> 1        13         C           1           2
> 1        14         C           0           2
>
> I wish that it's clear this time.  I just not sure how to construct
> the duration variable in Stata.
>
> Thanks,
>
> Albet
>
>
>
>
>
> On 4/6/06, Nick Cox <n.j.cox@durham.ac.uk> wrote:
> > I think you are going to need to explain how "Duration"
> > is calculated. The numerical example is not
> > clear to me.
> >
> > Nick
> > n.j.cox@durham.ac.uk
> >
> > Albert Newton
> >
> > >        I get stuck in coding a during variable.  The data is like:
> > >
> > > hhid    weekshoppingday triptype        switch  switchtype
> > >   Duration
> > > 1871877 954     7       1       0       0       0
> > > 1871877 955     7       2       1       2       1
> > > 1871877 956     3       1       1       4       1
> > > 1871877 957     6       0       1       1       1
> > > 1871877 958     7       1       1       6       3
> > > 1871877 959     7       1       0       0       0
> > > 1871877 960     7       1       0       0       0
> > > 1871877 961     7       0       1       1       1
> > > 1871877 962     7       2       1       5       1
> > > 1871877 963     4       1       1       4       3
> > > 1871877 964     2       1       0       0       0
> > > 1871877 964     7       1       0       0       0
> > >
> > > I just wanto count how long the customer stay in the switched
> shopping
> > > type.  Could any one give some suggestion of how to constuct the
> > > variable "Duration"?
> > > The one above is make manually.
> >
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/support/faqs/res/findit.html
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> >
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
> This message is intended solely for the designated recipient(s). It may contain confidential or proprietary information and may be subject to confidentiality protections. If you are not a designated recipient, you may not review, copy, or distribute this message. If you receive this in error, please notify the sender by reply e-mail and delete this message.
>
> Arrowstreet Capital, L.P. is an Equal Opportunity Employer.
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index