Hello good Sir/Madam,
I am currently working with a list of corporations and their CashFlowTypes, and I wish to see the effect of a certain type of cash flows on a dependent variable. For now, each CashFlowType makes up a new row per corporation, with an adjacent column stating the Amount of that CashFlowType, so say there are 6 types of cash flow, I have 6 rows per corporation. What I would want is 1 row per corporation with 6 different columns, each describing their respective cash flow variable.
Is this possible? If so, with what code could this be accomplished?
I included a picture so you may better understand what I am trying to bring across with my limited programming knowledge. The string variable is in Dutch if you were wondering.
My sincerest thanks in advance!
Jan Paul
Array
Related Posts with How to dissect multiple variables in one column to separate columns
Generate with tempfilesI used Stata tempfile code from one of the earlier posts to append multiple years of NHIS mortality …
Looking for examples of OSIRIS dictionaries and dataDear Statalisters, I am writing a custom converter of data from OSIRIS dictionaries and need exampl…
Strategy to choose the right controls? Conceptual questionsHello, I have a problem with chosing the right controls for my model and hope someone can help me a…
Non-linear hypotheses testing with a GSEMHello, I'm having trouble with the testnl command after a GSEM model. Specifically, my problem is th…
Generate a new variable by deleting everything after certain character ("/") Code: * Example generated by -dataex-. To install: ssc install dataex clear input str28 country "U…
Subscribe to:
Post Comments (Atom)
0 Response to How to dissect multiple variables in one column to separate columns
Post a Comment