Hello all,
For a large sample of firms, I need to count the number of (1) business segments and (2) geographic segments the business is in for the years 2010-2019. Using Ben Earnhart's code (https://www.statalist.org/forums/for...variable-group); bysort fyear CUSIP: gen howmany=_N gives me the number of segments for every firm in a particular year.
Now this is good, but I have to separate the business segments from the geographic segments.
For a particular firm, this is what it looks like:
SegmentType CompanyName fyear howmany
GEOSEG NEW SOURCE ENERGY PRTRS LP 2013 7
GEOSEG NEW SOURCE ENERGY PRTRS LP 2013 7
BUSSEG NEW SOURCE ENERGY PRTRS LP 2013 7
BUSSEG NEW SOURCE ENERGY PRTRS LP 2013 7
GEOSEG NEW SOURCE ENERGY PRTRS LP 2013 7
BUSSEG NEW SOURCE ENERGY PRTRS LP 2013 7
BUSSEG NEW SOURCE ENERGY PRTRS LP 2013 7
GEOSEG NEW SOURCE ENERGY PRTRS LP 2014 8
BUSSEG NEW SOURCE ENERGY PRTRS LP 2014 8
GEOSEG NEW SOURCE ENERGY PRTRS LP 2014 8
GEOSEG NEW SOURCE ENERGY PRTRS LP 2014 8
BUSSEG NEW SOURCE ENERGY PRTRS LP 2014 8
BUSSEG NEW SOURCE ENERGY PRTRS LP 2014 8
BUSSEG NEW SOURCE ENERGY PRTRS LP 2014 8
BUSSEG NEW SOURCE ENERGY PRTRS LP 2014 8
Anyone knows how to distinguish in the code between the two types of segments?
Related Posts with Counting observations with an 'if'
Changing variable names on a forest plot STATA 15.1Ok so i have ran a mata analysis odds ratio and created a forest plot,i have what i need on the grap…
Dropping duplicates based on another variableI have a large dataset with patient encounters, of which some patients may have had multiple encount…
svmachinesI am trying to run svmachines command and this syntax, when I run this in CV and Test predictions I …
Create a duplicates drop logic working for missing valueHi Statalisters, I am working on my data cleaning and have such a problem. When I use duplicat…
Testing for Non-linearity in Fixed EffectsHello, I am running individual FE models where my dep variable (DV) is treated as continuous but it…
Subscribe to:
Post Comments (Atom)
0 Response to Counting observations with an 'if'
Post a Comment