Bookmark and Share

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]

AW: st: RE: How to filter data


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/


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