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
extracting several string values from several different variablesHello, i am working with treatment data i have treatment1 treatment2 treatment3 treatmentn variables…
T&EHi I am trying to create a stacked bar graph using the percentage option but one of the bars is grea…
Stacked bar graph using percentage optionHi I am using Stata 15. I am trying to create a stacked bar graph using the percentage option but o…
Diff in Diff graphic with repeated cross-sectional dataHi Everyone, I am currently trying to do a DD analysis on expenditure for two nations as a result o…
How to interpret predicted probabilities with continious variables in logistic regression?Hello everyone, I've got a question regarding how to interpret continious variables in logistic reg…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape Wide Issue
Post a Comment