If I am understanding your Q correctly I would want the output data for lines 1-6 look like this pers_id px_id. fu_6m. fu_1. fu_2. fu_3. fu_4. fu_5 4736884 715723 1 1 1 1 1 1
... View more
I would like to combine the six records and see for each person something like this: pers_id px_id fu_6m fu_1 fu_2 fu_3 fu_4 fu_5 123 123 1 1 1 0 0 0 124 124 1 1 1 1 0 0 Where 123 has died at follow up at 3 years and 124 has died at follow up at 4 years
... View more
Hello, I am trying to do some survival analysis and have a dataset that looks like this: As you can see the first 6 lines are from the same person. fu_6m to fu_5 are the follow up status from 6 months to 5 years. 0 is dead and 1 is alive. I need help with having one unique observeration per person and having a variable for follow up status at 6 month, 1 year, 2 year .... 5 year
... View more
I have a dataset that lists my center ID and the organs transplanted at that center ID. I need to convert the dataset to tell me at each unique center ID how many and which organs are transplanted. What the data looks like: Center ID Organ 1 Heart 1 Lung 1 Kidney 2 Heart 3 Heart 3 Liver 4 Heart 4 Lung 5 Liver 6 Lung 7 Heart 7 Lung 7 Liver 7 Kidney What I need it to look like: Center ID Organ 1 Heart+Lung+Kidney 2 Heart 3 Heart+Liver 4 Heart+Lung 5 Liver 6 Lung 7 Heart+Lung+Liver+Kidney The last column can be coded for the different combinations of organs. Any help will be truly appreciated!!
... View more