Hi:
My data comes from WRDS and my research question is about gender diversity and firm performance. My data is 7 years panel data(from 2007 to 2013) and I use fixed effect to run the regression. I use Stata 13.1
However, because the data in WRDS is quite tricky, I am confused about how to write down relative Stata code to count the number of business segments.
The data picture downloaded from the WRDS are as follows. DATADATE =Ending date of the Fiscal Period Being Reported
Source Date=“Date” of the report – Up to 3 SRCDATE’s for each DATADATE
I am curious about how to use these data to count the number of business segments.
Especially,in the same day in the same company, the number of Segment Identifiers is different. How can I count the number ?
Actually, I do not want to use the data sorted by data data, I want to use the data sorteed by data year. I have already used data year and ticker as key variables to merge about 10 data sets. Therefore, if the new data set do not have data year then I can not merge the new dta with the old one.
Or could you recommend me other database that can be used to count the number of business segments?
WRDS provide me with the SAS code to count the number of business segments sorted by GVKEY,SRCDATE and DATADATE which cannot solve my problem.
Thank you very much!
My data comes from WRDS and my research question is about gender diversity and firm performance. My data is 7 years panel data(from 2007 to 2013) and I use fixed effect to run the regression. I use Stata 13.1
However, because the data in WRDS is quite tricky, I am confused about how to write down relative Stata code to count the number of business segments.
The data picture downloaded from the WRDS are as follows. DATADATE =Ending date of the Fiscal Period Being Reported
Source Date=“Date” of the report – Up to 3 SRCDATE’s for each DATADATE
I am curious about how to use these data to count the number of business segments.
Especially,in the same day in the same company, the number of Segment Identifiers is different. How can I count the number ?
Actually, I do not want to use the data sorted by data data, I want to use the data sorteed by data year. I have already used data year and ticker as key variables to merge about 10 data sets. Therefore, if the new data set do not have data year then I can not merge the new dta with the old one.
Or could you recommend me other database that can be used to count the number of business segments?
WRDS provide me with the SAS code to count the number of business segments sorted by GVKEY,SRCDATE and DATADATE which cannot solve my problem.
Thank you very much!
Comment