Hi, I have been trying to reshape my data from long to wide format using reshape wide. The data looks like this:
OrganisationName AssetClass CapitalCommitted TotalCapitalCommitted
Maroni Private Equity 50 120
Susani Private Equity 70 120
Mazia Debt 30 75
Mungo Debt 45 75
Total Capital Committed denotes the total amount of capital committed per asset class by all organisations (I obtained this number by using the command: egen TotalCapitalCommitted = total(CapitalCommitted), by(AssetClass).
I now would like to reshape my data from long to wide format and I have been trying to do so through: reshape wide TotalCapitalCommitted, i(OrganisationName) j(AssetClass) string, however whenever I run this code I get the error message: TotalCapitalCommittedInfrastructure invalid variable name. Would anyone be able to help me? The most important piece of information I have to showcase is the total capital committed per asset class.
Many thanks
Related Posts with Reshape Wide Issue
Multivariate Regression value higher than univariate?This is a simple question: I have done a small research study where I had a significant (Logistic re…
bar chart comparing mean to a constant variableDear Stata Community, I am looking to create a bar graph similar to that below. For simplicity, I w…
loop for dummy variableI have many data sets in the format such as this one, however most are much longer. origin is just t…
Panel Data model interpretation: Choosing between FE and REHi. I have a long panel, that is my T is 16 and N=8. Where the dependent variable is number of under…
change in sign and significance of linear term after adding quadratic and cubic termsHi all, I need your comments on change in sign and significance of linear term after adding quadrat…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape Wide Issue
Post a Comment