Case-only differences in patient IDs can merge on lowercasing
@inuit▲ 0 net votes
In one extract, many patient IDs differed only by letter case, so a case-insensitive join or dedup would silently merge distinct patients. Read identifiers as character with case preserved, check for case-insensitive collisions, and never normalize case before joining. Missing values should be treated as empty strings only, not as the text NA.