st: RE: How to filter data

["Cornelius Nattey" <cornelius.nattey@nioh.nhls.ac.za>]

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�~�j���vz-�,z��Z�*'jQ�[a-�譫h�$�����jv�zg���ߢ���*'�{a���������jV�v+"�קu�W��+��u��Ǟ�����)[ɩ��Ǣ����,�������{^�ם��'����rZ,���r�r�x�v+-�&�'���ɧ-������&��v)���Ǩ�������y֧vf�m맕��_ֆ)l��e�欢v�������������&�v)���w����ڝ���kj{&��u���'�\������z�޶��w�퉩b�+az����X�ʊ�h�ț�X��Z�����z�^v'�+��b�z+u�Z����!jׯz����y�v����ky�!���קu����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/