Hello,
I would greatly appreciate some help/feedback with merging Network Canvas data with output from Qualtrics.
Specifically, I am aiming to create a combined dataset in both wide (one row per index with all network information as columns) and long (one row per network member where that network member’s data is appended to their index’s data) format.
We will not be using the network-network relationship output. The inputs will be:
- Data from Qualtrics, where each row is an index (one column lists participant ID)
- Ego data from Network Canvas (will manually enter above participant ID)
- Network attribute data from Network Canvas
The hope is to merge ego data with Qualtrics, and then append the network attribute data into both a long and wide format. I am using STATA 18. Our team has managed to identify code that can generate data in the long format but we are encountering some issues creating the wide format. We thought this might be an issue that you all have worked through before.
Any assistance would be very appreciated!
Thanks,
Grace