Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

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

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

To |
<statalist@hsphsun2.harvard.edu> |

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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Thomas Gericks Gesendet: Dienstag, 15. Juni 2010 13:52 An: statalist@hsphsun2.harvard.edu 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 <cornelius.nattey@nioh.nhls.ac.za> Gesendet: 15.06.2010 12:43:59 An: statalist@hsphsun2.harvard.edu 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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Thomas Gericks Sent: Tuesday, June 15, 2010 12:26 PM To: statalist@hsphsun2.harvard.edu 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/

**References**:**st: How to filter data***From:*Thomas Gericks <ThomasGericks@web.de>

**st: RE: How to filter data***From:*"Cornelius Nattey" <cornelius.nattey@nioh.nhls.ac.za>

**Re: st: RE: How to filter data***From:*Thomas Gericks <ThomasGericks@web.de>

- Prev by Date:
**Re: st: AW: panel data analysis** - Next by Date:
**AW: st: AW: panel data analysis** - Previous by thread:
**Re: st: RE: How to filter data** - Next by thread:
**st: Problem with paneldata** - Index(es):