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]

st: RE: How to filter data


From   "Cornelius Nattey" <cornelius.nattey@nioh.nhls.ac.za>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: How to filter data
Date   Tue, 15 Jun 2010 12:43:59 +0200

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/


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