Hi all,
I have not used Stata for long and have now to perform a statistical analysis based on financial and merger data I have gathered. I want to make this data "Stata-ready", because it currently seems to not work when loaded. (summarize does not yield any values etc)
The issue with the data is that, for each firm, I have circa 40 variables per year from 2012 to 2017 (i.e. revenue, EBITDA, market value etc.). Also, there are a lot of datapoints that contain only missing values as well as a mix of string and numerical values and therefore something Stata cannot apparently work with.
What do I need to do (in Stata or Excel?) so that the data becomes usable? For example, that, based on the datastream Code (DSCD) for each firm I have outputs per year that I can analyse?
Please let me know if that sounds vague - I have attached a snapshot of the dataset I havem maybe that makes things clearer.
Thanks in advance
I have not used Stata for long and have now to perform a statistical analysis based on financial and merger data I have gathered. I want to make this data "Stata-ready", because it currently seems to not work when loaded. (summarize does not yield any values etc)
The issue with the data is that, for each firm, I have circa 40 variables per year from 2012 to 2017 (i.e. revenue, EBITDA, market value etc.). Also, there are a lot of datapoints that contain only missing values as well as a mix of string and numerical values and therefore something Stata cannot apparently work with.
What do I need to do (in Stata or Excel?) so that the data becomes usable? For example, that, based on the datastream Code (DSCD) for each firm I have outputs per year that I can analyse?
Please let me know if that sounds vague - I have attached a snapshot of the dataset I havem maybe that makes things clearer.
Thanks in advance
Comment