Hello Stata Wizards, hope one of you can help me with my problem.
I have hierarchical data that is a little complicated:
I want to try and reshape.
Office_ID and Branch names are corresponding. Employee_ID is unique for every employee. The Account_ID often has multiple entries for employees, because though the value in itself is unique, every time there is a change in status, there is a new entry with Date, Old_Status and New_Status.
I want to change the data into wide form so that for every Account ID there is a single row, without losing any of the data.
So that data would look something like this:
Please let me know if you need me to clarify.
I have hierarchical data that is a little complicated:
I want to try and reshape.
Office_ID and Branch names are corresponding. Employee_ID is unique for every employee. The Account_ID often has multiple entries for employees, because though the value in itself is unique, every time there is a change in status, there is a new entry with Date, Old_Status and New_Status.
I want to change the data into wide form so that for every Account ID there is a single row, without losing any of the data.
So that data would look something like this:
Please let me know if you need me to clarify.
Last edited: