Bookmark and Share

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]

AW: st: RE: How to filter data


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   AW: st: RE: How to filter data
Date   Tue, 15 Jun 2010 16:55:45 +0200

<> 

" 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?"




*************
bys company: egen byte mymax=max(dropma)
drop if mymax==1
*************


For the creation of "dropma", you may also want to rely more on the lag operator (-help tsvarlist-) than on explicit subscripting.


HTH
Martin


-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Thomas Gericks
Gesendet: Dienstag, 15. Juni 2010 13:52
An: [email protected]
Betreff: Re: st: RE: How to filter data

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 <[email protected]>
Gesendet: 15.06.2010 12:43:59
An: [email protected]
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.
thanks
Cornelius
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Gericks
Sent: Tuesday, June 15, 2010 12:26 PM
To: [email protected]
Subject: 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 Geldprmie 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/


N���,{kz�v)�+���j���y^��-����Ǭ��^w�a�Ǩ~�^j�a���vz-�,z���Z�*'jQ�j[a-�譫h�$���z�+��&jv�zg����z)ߢ���*'�{a��������(��z{bjV�v+"�קu�l�W���+��u�޲Ǟ�
z�-��b���j)[ɩ�w��Ǣ��ں�h�,�w�ʋ�����^�{^�ם��"�'�����جrZ,���r�r�x�v+-�&�*'���ɧ-���jG���&��^v)�zX��Ǩ��b��!���y֧vf�m맕��_ֆ)l��e�欢v���-z���Z����캷���r��s&�v)�z
�*�w�f���ڝ�Z��kj{&��^u�^r��'�\���h���z�޶��w�u�퉩b�+az����&��X�ʊ�z�h�ț�X��Z����Ⱨz�^v'��+��b�z+u�Z��ߢ�!jׯz��j�'��+��my�+v����ky�!��"�קu�]z�b��b

*
*   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/
___________________________________________________________
GRATIS für alle WEB.DE Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.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/


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