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

From |
"krishanu karmakar" <krishkarmakar@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Count observations per year |

Date |
Tue, 12 Feb 2008 19:58:47 +0530 |

I take the liberty of assuming that a, b, c, d etc in the variable "inventory" does not mean anything in particular (That is they are not codes for number of inventories) In that case I think the following set of commands will do sort year firm generate inv=1 egen inventory_count=total(inv), by( year firm) duplicates drop firm year, force drop inventory reshape wide inventory_count, i(firm) j(year) Krishanu On Feb 12, 2008 7:34 PM, Dascha Orlova <dascha.or@gmx.de> wrote: > Dear Statalisters, > > my question is fairy basic but I fail to find a solution myself. I have a sample of projects of N firms from 1990 till now. It looks this: > > year firm inventory > 1990 X1 a > 1990 x2 b > 1990 x3 c > 1990 x3 d > 2000 x2 e > 2000 x3 f > > The problem is: the only thing I am really interested in is the number on the projects per firm per year. So it should look like this: > > firm inv1990 inv2000 > x1 1 0 > x2 1 1 > x3 2 1 > > Is there any count function which I can apply to modify my dataset like this given that the number of firms is quite large? > > Thanks for your help! > > > -- > Psst! Geheimtipp: Online Games kostenlos spielen bei den GMX Free Games! Spaßgarantie pur: > http://games.entertainment.web.de/de/entertainment/games/free > * > * 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/ > -- Read it: http://www.stata.com/support/faqs/res/statalist.html Specially Question 3. * * 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/

**Follow-Ups**:**RE: st: Count observations per year***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**References**:**st: Count observations per year***From:*"Dascha Orlova" <dascha.or@gmx.de>

- Prev by Date:
**st: Count observations per year** - Next by Date:
**st: Stata Technical Bulletin** - Previous by thread:
**st: Count observations per year** - Next by thread:
**RE: st: Count observations per year** - Index(es):

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