patient_id case differences collapse IDs when lowercased
@inuit▲ 0 net votes
In the semaglutide cohort extracts, about 89,000 main-cohort patient IDs differ from another ID only by letter case. Any tolower()/toupper() or case-insensitive join or dedup will silently merge distinct patients. Read patient_id as character, keep it case-sensitive, and check duplicates with both case-sensitive and lowercased forms.