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
Data of a groupHello, I have a data with normal firms and zombie firms. Both groups have capital. But I want to ge…
Drop individuals who have too many missingsHello everyone, I think this is quite a simple question but I am still not very used to STAT Cod…
Two new programs, -rqrs- and -which_version-, available from SSCThanks, as always to Kit Baum, two new programs, rqrs and which_version, are available for download …
margins, eydx after logitHi, I am working with a logit model. I am interested in the percentage change in the probability of…
Overlay line segments on graphArray I've generated the figure above and would like to make two line segments on the X-axis, one to…
Subscribe to:
Post Comments (Atom)
0 Response to Reshape Wide Issue
Post a Comment