Hello

I need some help linking this data set

So the variable taskdefinitionid is the numerical code for the string in the task_def_description column

e.g the in row 1 the id 03812d19-5eaf-4dd0-aa82-01a878b408eb = Attach leg bag to catheter

What i would like to do is link taskdefinitionid and task_def_description and then replace task_definition_id2 with the description as a string (as defined in column 2)

hope that is clear
thanks



Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str36 taskdefinitionid str57 task_def_description str36 task_definition_id2
"03812d19-5eaf-4dd0-aa82-01a878b408eb" "Attach leg bag to catheter"                        "86b43572-3f9d-44ca-8b84-55508fd61dc6"
"038771a5-934d-4ab6-9419-1cf564465962" "Prompt to use commode"                             "4c5323f2-65b2-4453-8437-f8193b75702c"
"053de533-24cb-4824-ae91-6cb309b68c52" "Empty and disconnect day bag"                      "2fc93eb6-1616-477b-8742-97b56a287109"
"068d5526-a7b8-4023-bc8c-3466a07e8f72" "Assist to prepare drink of choice"                 "81fcab77-5192-4abc-86e4-0e73752bfcbf"
"07c8d58e-1298-4ba5-b87c-596767239f40" "Take laundry to launderette"                       "5d3ee1cd-e702-4bd2-bf85-c2c622075e7d"
"08200da1-aaa7-4c02-bcc9-4c80b90ff9fb" "Assist with transfers into wheelchair"             "068d5526-a7b8-4023-bc8c-3466a07e8f72"
"09143829-b597-4740-9e39-ea71744dd374" "Escort visit / community access outing"            "81fcab77-5192-4abc-86e4-0e73752bfcbf"
"09dfafaa-00bd-4aa4-89d6-8a6289fee217" "Attach night bag"                                  "2fc93eb6-1616-477b-8742-97b56a287109"
"0a207f04-ae50-4b03-8b2c-381369dd3bed" "Ensure walking aid is within reach"                "1b231f64-cebe-433d-9929-3018c4e90bf6"
"0e7d5f3d-a541-4721-a5a9-7d451f789427" "Ensure something to eat is left out"               "85d6a035-3ad8-4ac1-bb55-8703f35b30d7"
"12d793c5-3a03-4562-b77e-2e1ec201b3f7" "Apply cream to sacrum and buttocks"                "9ac88364-79c5-4f1d-9767-5e65f16a0711"
"13315071-808a-49f7-86b4-ae896ed74652" "Assist with applying creams to skin as instructed" "6f4a7e65-4bb0-4347-8f73-0c6dd16310c6"
"16805d7f-16b4-445f-9269-e2ea1134508a" "Assist when using the toilet"                      "4c5323f2-65b2-4453-8437-f8193b75702c"
"1aea7de9-b723-4b08-a25c-71f9867bc7c1" "Prepare and leave out a meal"                      "6f4a7e65-4bb0-4347-8f73-0c6dd16310c6"
"1b231f64-cebe-433d-9929-3018c4e90bf6" "Prepare and serve a meal with drinks"              "86b43572-3f9d-44ca-8b84-55508fd61dc6"
"1bf3b81d-40b0-4539-ba96-9ea12ad6110b" "Assist with oral hygiene"                          "3f460c6a-f037-48ef-92ae-5df9c6b09d21"
"1c5ff505-c50d-4f00-88d5-0fb489219dcc" "Assist with shopping"                              "4c5323f2-65b2-4453-8437-f8193b75702c"
"1d2a49f9-eb77-4221-b8ef-d248944ff591" "Assist with PEG feed"                              "6f4a7e65-4bb0-4347-8f73-0c6dd16310c6"
"1f4c3eb9-cfa2-47a6-a58d-6accdfed527c" "Assist with exercises"                             "068d5526-a7b8-4023-bc8c-3466a07e8f72"
"1f6ebda8-5759-43f9-aee7-6f4339a96c20" "Take frozen meal out of the freezer"               "f118e52d-4b5b-4ab2-b4c6-5fd402d1ffb7"
end