Hello,
I use Redcap as a database and am trying to use Stata to filter and analyse data from this database. In Redcap you can store data in multiple instruments so that when you export it, you will have data spread across different rows for the same individual. I need to have this data filled out across all rows for some variables.
For example, in the screenshot: my unique identifier for each individual is cohort_id. For cohort_id 1, age sex and site information isn't present until row 3 (but I have other required data on other rows). For cohort_id 2, this data isn't represented until the 6th row.
For another dataset, I was able to use this code: bysort cohort_id (site): replace site = site[1]
I repeated this for each variable I required data on all rows. But for this dataset, my data may be on row 2, 6 or anything else for the individual so I cannot use this code.
Does anyone know how I can get my data on each row per cohort_id? I don't even care if I have to slowly go through and do it one by one for each variable. Surely someone out there has struggled with this Redcap issue before!
Thank you.
Related Posts with Data management for REDCap exports with repeating instruments
Generating new variableHi within a dataset I have been looking at there are 33 countries. I am trying to create a dummy var…
controlling for fixed effectsNone …
Stata 17 Tables - Constructing a table from nlcom in 1 results?I would like to use the Stata 17 table functions to automate a results table. I have used nlcom to e…
Creating variables in long formatHello, I am trying to create a variable "stage1_class" that represents different responses to lx_ite…
Constraining the X-Axis within a rangeI'm studying the causal impact of Puerto Rico's VacuTour policy with my event-study synthetic contro…
Subscribe to:
Post Comments (Atom)
0 Response to Data management for REDCap exports with repeating instruments
Post a Comment