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]
st: AW: How to filter data
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: AW: How to filter data
Date
Tue, 15 Jun 2010 12:44:45 +0200
<>
1. How do i sum up all the sales of several companies per year or quarter. Do i have do to that in a new dataset?
-bys year/quarter: egen totalsales=total(sales)-
See NJC`s http://www.stata-journal.com/sjpdf.html?articlenum=pr0004
2. I gernerated a new variable that marks when a company grew in the last quarter more than 50% with a 1. now i want to delete all observations of that company in the dataset in order to limit biases of M&As. I have different number ob observations per company( quartely reporting)
-drop if newvariablename==1-
It may be better to condition via -if- than to -drop- outright, though...
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Thomas Gericks
Gesendet: Dienstag, 15. Juni 2010 12:26
An: [email protected]
Betreff: st: How to filter data
Hello,
I am analyzing a paneldataset.
I have two questions:
1. How do i sum up all the sales of several companies per year or quarter. Do i have do to that in a new dataset?
2. I gernerated a new variable that marks when a company grew in the last quarter more than 50% with a 1. now i want to delete all observations of that company in the dataset in order to limit biases of M&As. I have different number ob observations per company( quartely reporting)
As I have no programming background I'm overstrained with the syntax.
Thank you very much for your help
Best regards,
Thomas Gericks
___________________________________________________________
WEB.DE DSL ab 19,99 Euro/Monat. Bis zu 150,- Euro Startguthaben und
50,- Euro Geldprämie inklusive! https://freundschaftswerbung.web.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/