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: histogram
From
Schöler, Lisa <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: histogram
Date
Thu, 14 Oct 2010 14:10:13 +0000
Thank you all for your answers. All answers worked well
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Andrea Bennett
Sent: Thursday, October 14, 2010 4:01 PM
To: [email protected]
Subject: Re: st: histogram
Dear Lisa,
You might want to have a look at the tag-option of the egen command
http://www.stata.com/help.cgi?egen
best,
Andrea
On Oct 14, 2010, at 15:53 , Schöler, Lisa wrote:
> Dear Statalist,
>
> I have different observations within one id:
>
> Example
>
> +----------------------------------+
> | id mean(brand) brand year |
> |--------------------------------|
> | 1 5 7 1999 |
> | 1 5 5 2000 |
> | 1 5 3 2001 |
> | 1 5 5 2002 |
> | 1 . . 2003 |
> |--------------------------------|
> | id mean(brand) brand year |
> |--------------------------------|
> | 2 . . 1999 |
> | 2 6 7 2000 |
> | 2 6 8 2001 |
> | 2 6 5 2002 |
> | 2 6 4 2003 |
> |--------------------------------|
> | id mean(brand) brand year |
> |--------------------------------|
> | 2 . . 1999 |
> | 2 6 7 2000 |
> | 2 6 8 2001 |
> | 2 6 5 2002 |
> | 2 6 4 2003 |
> +------------------------------+
>
> Now I need to get a histogram that uses only one observation for each id for the mean(brand). Therefore I wanted to include a dummy=1, so I can use the command
>
> . histogram if dummy==1
>
> Can anybody help me how I can create a dummy=1 only for one observation per id? I was gonna use
>
> . by id: gen dup = cond(_N==1,0,_n)
>
> and then
>
> . histogram if dup==1
>
> But the problem here is that I have missings within my id groups, so sometimes my dup per id starts with 2.
>
> If anybody has a better idea than creating a dummy, I am very happy to hear about it.
>
> Thank you
> Lisa
>
> Lisa Schöler
> Professur für BWL, insb. Electronic Commerce
> Goethe-Universität Frankfurt
> Grüneburgplatz 1
> 60629 Frankfurt a.M.
>
> Phone: ++49 69 798 34632
> Fax: ++49 69 798 35001
> Email: [email protected]
> URL: www.ecommerce.wiwi.uni-frankfurt.de
>
> _________________________________
> Get serious about better marketing decisions - apply now!
> http://www.goethe-master.de
>
>
> *
> * 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/
*
* 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/