Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: How to filter data

From   Thomas Gericks <>
Subject   Re: st: RE: How to filter data
Date   Tue, 15 Jun 2010 13:51:52 +0200 (CEST)

Hi, thanks for helping me with the first question.

More explanation on the 2nd one:

I am looking at accounting data of several companies over several years. Thus, paneldata.
No i looked at each company and said that i want to mark every quarter, when assets grew by more than 50%.

so i said: gen dropma = 1 if 1.5*atq[_n-1] < atq[_n] & atq[_n]<10*atq[_n-1]

Now i have a 1 for these years in the companys. Now i want to drop all the observations of these companies. So, now i need the syntax to (1) mark every company if once in their time series they grew that much und then secon delete the complete company.

How do i do that?

Thanks a lot! BR Thomas

-----Ursprüngliche Nachricht-----
Von: Cornelius Nattey <>
Gesendet: 15.06.2010 12:43:59
Betreff: st: RE: How to filter data

Hi Thomas,
You can use the table command the syntax is as below
table year, c(sum sales) 
where sales is represent of several companies
Please clarify the the other question.
-----Original Message-----
From: [] On Behalf Of Thomas Gericks
Sent: Tuesday, June 15, 2010 12:26 PM
Subject: st: How to filter data


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 Geldprmie inklusive!

*   For searches and help try:


*   For searches and help try:
GRATIS für alle WEB.DE Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index