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
How to import tabstat results to data editor?Hello, I want to know to import the tabstat results to a stata data editor. I am using the followin…
-order(c.(A C B)#c.X) option does not work with esttab?Dear all, I use the following commands to make a table: eststo: reg Y c.(A B C)#c.X esttab, order(…
grmap without shapefileDear Statalist members, Under the framework of spatial analysis, I have a dataset with coordinates …
How to loop over columns of 70 to get the categorical counts based on a particular observation?Hi all, I've a hospital cases dataset having 30 columns and 70 observations. Based on the types of …
how to systemmatically change data entry 200thousand alike into 200000many thanks! …
Subscribe to:
Post Comments (Atom)
0 Response to Reshape Wide Issue
Post a Comment