I have an Excel sheet that contains medical history with "identifying data". I want to break it up into two excel sheets.
1) That contains only identifying data and no medical history (basically a list of names).
2) That contains only medical history and no identifying data (basically a list of medical history but that cannot be id to a specific patient).
Now I want to be able to merge them back in if required. So I need to create a unique link variable.
The easiest thing is to cut and paste the id columns but I am afraid the ppl this is going to WILL sort the data and the re-linking will get messed up.
The identifying data is charecter not a numeric SSN type of variable.