Reshaping Data from Wide to Long Format in Stata

[Shaila mohammadi]

Hello Stata Community,
I am currently working on a dataset that contains various actions of resuscitation, such as suctioning and ventilation. I would like to reshape my data from wide to long format, where:

• The columns represent time counting (elapsed time).
• The rows represent different actions of resuscitation.
• I want the start and end points of each action to be displayed below the corresponding time.

Could anyone guide me on how to achieve this in Stata? Is there a specific command or method I should use to ensure that the start and end points align correctly with the matched time?
Thank you for your assistance!

[Andrew Musau]

The best way to elicit a helpful reply is to provide a data example using the dataex command. See

help dataex

If your data is confidential (you appear to have medical records), you should create a fake example that mirrors your case while preserving confidentiality. See FAQ Advice #12 for more details on how to post effectively.

[Nick Cox]

Please follow http://statalist.org/forums/forum/ge...ormat-in-stata if interested.

[Clyde Schechter]

This thread appears to be an earlier attempt to ask the question posed at https://www.statalist.org/forums/for...ormat-in-stata. O.P. followed the advice in #2 when responding there. However, even with the example data, the description of what is wanted is unclear. At the linked post you will find Ken Chui 's request for further clarification, as well as two (foolish?) attempts on my part to guess a solution.