Stata fails to detect strings that look completely identical

[Agnes Weis]

Dear Stata users,

I encountered an intriguing issue and would appreciate your insights. In Stata, I have a variable called ID that appears as "057ab4dd-fa4f-4abe-84". To compare this variable, I created another variable called ID1 in Stata and copied the exact same value ("057ab4dd-fa4f-4abe-84") from my Excel table into ID1. However, when I used the command "count if ID == ID1" in Stata, it returned zero. I'm puzzled as to why Stata doesn't recognize that the strings are the same. Could this discrepancy be related to Excel?

Thank you for your assistance.

[Leonardo Guizzetti]

It's not clear what the issue is based on your description and without having a reproducible example. As you say, the strings do appear to be the same. Common reasons can be leading/trailing whitespace characters, embedded "invisible" characters or otherwise similar appearing, yet different, Unicode characters.

You might try a first pass for both ID and ID1 variables by inspecting which characters are present. I would use the user-contributed -chartab- (SSC, -ssc install chartab-) and inspect ID and ID1 for only those values which do not match identically.

Here's a sketch of what I propose that should work, but you might need to adapt for your own code (again, untested since there's no data example).

* remove leading/trailing spaces
replace ID = ustrtrim(ID)
replace ID1 = ustrtrim(ID1)

* flag non-matching IDs, then compare the characters present in each ID var, looking for differences between them.
gen byte nomatch = ID != ID1
chartab ID if nomatch
chartab ID1 if nomatch

[Agnes Weis]

It's not clear what the issue is based on your description and without having a reproducible example. As you say, the strings do appear to be the same. Common reasons can be leading/trailing whitespace characters, embedded "invisible" characters or otherwise similar appearing, yet different, Unicode characters.

You might try a first pass for both ID and ID1 variables by inspecting which characters are present. I would use the user-contributed -chartab- (SSC, -ssc install chartab-) and inspect ID and ID1 for only those values which do not match identically.

Here's a sketch of what I propose that should work, but you might need to adapt for your own code (again, untested since there's no data example).

* remove leading/trailing spaces
replace ID = ustrtrim(ID)
replace ID1 = ustrtrim(ID1)

* flag non-matching IDs, then compare the characters present in each ID var, looking for differences between them.
gen byte nomatch = ID != ID1
chartab ID if nomatch
chartab ID1 if nomatch

Thanks, but I tried it before and it did not help. All the characters are the same. There are no spaces or invisible characters too.

[Hemanshu Kumar]

Please create a data extract using dataex, and before sending it to the list, verify that your issue occurs specifically in that very data extract (clear your data from memory, copy back from your dataex like any of us would, and then check for equality between the two variables).

[Agnes Weis]

Please create a data extract using dataex, and before sending it to the list, verify that your issue occurs specifically in that very data extract (clear your data from memory, copy back from your dataex like any of us would, and then check for equality between the two variables).

Yes, even with dataex it still thinks that strings are different.

"6f7486a6-5bd6-42d1-bc6c-f1a94f3eaa73" ""
"e887dd78-eb42-4c68-9ab4-cc0f952d4aeb" ""
"e1809cd7-8a66-448b-b10b-e321e4ea74f4" ""
"6cbd04d5-b316-4f16-90dc-b31646f8dd27" ""
"9545561a-d663-4e88-bbe9-fd76996976d8" ""
"f8f03355-2a48-40d8-8b0f-c11ab291ac23" "057ab4dd-fa4f-4abe-8482-8bc8a55886cd"
"62557772-a2b8-431e-b0e8-9811c34228e8" "3611021b-1588-4b1d-8576-c8d47fff22be"
"fcb999cf-c691-428c-acba-06f7c2f406ff" "3172ec35-bd9c-4e50-a854-a74e9cfdcf7c"
"5266ceb9-c226-4f72-9d7b-693853062ba1" "0b6b7fe1-7f9a-485d-844f-df324552ce7d"
"945712e6-0951-45b6-ad31-4197f382c155" "1c5821ac-9467-457b-9ecc-ca4119334462"
"399f876b-923d-4aee-908d-44b38eff9312" "c14bdc43-c256-4fdc-b8f8-d1dcc3958ac0"
"14df99c0-b98f-4871-9756-3f7280f54933" "f17ccaeb-c9f1-4fd4-9513-05b1f6cb795a"
"b57cbdbe-261d-4c8a-8647-4d2a4a16f885" "e50df1e8-81a1-448d-ba5a-679dd0874ba2"
"6c0b8a5c-04e7-4b9b-beb7-e419d5f85ee6" "11d882a8-0f6b-4e5b-83a4-ab41f770e87b"
"6b9ae763-7d2d-49a1-ab11-0ea4bb95b4df" "db262fc5-4ded-4089-8067-07c87b9d16ff"
"057ab4dd-fa4f-4abe-8482-8bc8a55886cd" "4e94f3b3-80a0-4409-a33c-d2736d290617"
"3611021b-1588-4b1d-8576-c8d47fff22be" "d1dde55e-8710-417d-be3d-99647f04cf20"
"3172ec35-bd9c-4e50-a854-a74e9cfdcf7c" "f23c8e17-8152-41f8-9eec-bd96ff1b726f"
"0b6b7fe1-7f9a-485d-844f-df324552ce7d" "addf4171-581f-46cf-a3dc-e881ef1e1c85"
"fa3b7d18-e7e5-4019-972d-4a23258e9485" "9f14dcb9-0d7d-468e-a81d-2e90c8044240"
"cc6cf94a-5420-462d-8be8-871dffe8d62a" "8e8a0f21-7479-4a68-a5b2-d526a80f9c05"
"c77659a9-729c-4b0f-a029-027eb3e950bf" "2b15a4ec-5f5f-4760-a707-4c620f77e486"
"2ea65e5c-3c66-4130-80dc-cbd04a22e371" "1a09d217-98ee-4c1e-a409-2f51ab9d7c32"
"8d358d25-7c62-49b0-944a-3004444175bd" "7aa8bb65-1b96-4040-ad92-61f62ed2e8ed"
"ff5c2809-b49e-4575-b8a0-688d03df749f" "909626be-d236-4ccd-882a-f3d44631a4ae"
"d0575f64-ad92-439b-8f7b-0d071ae31ca3" "0037dfda-d6ce-4bd2-a074-8cd565149a9b"
"c71843b0-fddd-4de7-984b-0540880d6eb8" "9748d8d0-51b4-49fc-885d-aadb2fcb39ac"
"2ef02b10-b4c3-4319-9f5f-544aa9601f89" "83e93d3b-49e0-4910-8f94-2bdc6ed79fc8"
"29672919-d782-4cf0-ac84-b03383ba49ed" ""
"dc0eb7f2-0ae1-46f0-9c57-3a8382756712" ""
"d865ebb9-9255-4edc-8326-66d877bfe829" ""
"078ea453-abb7-4518-9a48-7a89fc5d1628" ""
"daa1344f-bcd1-443e-bda0-7529680e536d" ""
"f98abb6f-7ce6-45f4-87b5-74718309cc1e" ""
"9b7b1d50-1b36-4c65-97dc-b2bc7e221652" ""
"00a97986-90e0-43ac-9571-1f06e99ccd82" ""
"f52756c5-9427-47b1-b40d-c600b36e3992" ""
"3fde0b37-d46f-452b-a6f7-2c9cae4c2c8d" ""
"c37cc82f-18ba-44cf-ab96-cf34332433b0" ""
"9eb005c6-855c-4403-8c19-24b47631b687" ""
"3c11cb53-01a2-4903-88ba-0b46f2528f66" ""
"1b5ba115-390f-43b3-8046-048f6bdabe28" ""
"124e9624-85f5-41df-bc5f-b5cf2673ed66" ""
"e134db34-1c7f-4e22-ae04-f774e66dee5f" ""
"7dabeea9-d364-4a26-85cd-090aae440eea" ""
"212c325b-6495-440b-b7ce-8d4b36b38e71" ""
"2128d8a9-74cc-4539-86ec-9d4e0d53226e" ""
"fe50208e-9631-4b03-9145-2ac7687aeb3b" ""
"d28b862b-ffdf-4e54-a156-e818420d7bfb" ""
"ce977039-7f68-4f19-abf3-2e7202f2f605" ""
"0c835323-e82b-40ca-88d7-d6c28f83e9f7" ""
"e876dc4f-0b79-4394-9c6c-bcb5de25266a" ""
"f67094cc-2353-4100-87b7-e5a3fdbd4a41" ""
"29150928-8478-4807-9774-17f552805117" ""
"a0ee444a-537f-470e-a3af-1dca51b5811e" ""
"c0e2b0bf-6f2c-462f-b3eb-605a6dc6f8fd" ""
"a8fb3814-30e6-452c-bd5c-541e206b1968" ""
"3d1fcc78-fce9-4f74-84f2-23bc6dd7c8cd" ""
"4c66d81b-7d7c-4607-aaee-d66c202dc8ce" ""
"84b1656d-8139-4b35-b2c0-acb8d5a58fad" ""
"54edb979-968f-4e34-b27a-e9b8d71b6493" ""
"84ba51c8-9759-4b77-9c43-af0ee97cacdc" ""
"8b54af89-9ea4-4ac0-9f1a-fdc192126f81" ""
"17787fb8-4ddc-4156-a56f-069142c7a784" ""
"65923d5c-4ace-4640-bd43-49cf136a1174" ""
"4a1e5dc1-7f96-4459-b5c2-c6f30df926d4" ""
"8a9066b1-43a0-4cd4-8420-97824abd28b4" ""
"725ef4bf-7bf1-4dca-b6a2-954f2d22f0cd" ""
"dfff8ea1-21f5-4c0e-9114-162bd77596c0" ""
"98a6371b-bcb0-45ca-8353-13884639807b" ""
"eb9158c5-e26c-424f-9c69-f00b1c5f95d5" ""
"47169bb8-7626-447c-af0d-a9d27eb1185c" ""
"ab0bd7da-90d2-49d3-86c4-e6cad2efdb30" ""
"0874fb63-1380-4bc6-80f4-3c21650ce830" ""
"f24bf697-0ca3-47b1-aa15-8177c85ac437" ""
"0970bdeb-8918-4505-8f51-8ca8b34d75c4" ""
"9007e452-d3b5-483a-b1ae-c12ef28f0552" ""
"05aec304-4921-4360-82d6-f28790866775" ""
"06bf5a98-b83d-4adf-b3a9-dc3846ee0603" ""
"8de12404-f00d-4db8-8875-4660f102b358" ""
"6f2f0e86-c031-4126-be13-c1250298e189" ""
"dac84e26-e0ef-4e7f-9492-0c5a6d5ffb8b" ""
"bf14829e-8950-41a6-8617-6ded2171e741" ""
"c7c9d0b2-8665-4aec-ac1e-bb7fd12b4f63" ""
"e623cdd6-aa33-4493-85be-5e0c059bf5ed" ""
"49c3bc5d-b405-4e71-85fa-f6b97cbd83ff" ""
"454be9f2-188b-449b-82b1-3a129c2d103e" ""
"7dc45812-e839-46ba-ba48-2cff20cd6edb" ""
"5e983cf1-63b3-4a1e-9253-e52a0d1f6720" ""
"1df8f60f-9fa9-4146-968b-bc3bd5f120b1" ""
"a731ba67-cbc0-4862-923e-cd06385918d8" ""
"578d272b-3f5c-4471-83ed-a8c6f451f6ff" ""
"07387a33-fd61-4c7d-a66a-7491c443a6f6" ""
"e4bbf021-5f5b-482e-8645-74ba42b255cd" ""
"220817cc-be04-46f2-93e6-9b13c7dd6280" ""
"ee3011af-14fb-4026-a3d3-705480b3e9cd" ""
"b3076b32-ffb3-460a-9a7b-68b38a975ee8" ""
"8a3f31d4-e2db-4d6c-ae06-1efb02c1e3a0" ""
"8b13c01b-a9f2-4bfa-bbf3-21a0fc6adbe2" ""
"a56e3278-4dd3-40a1-8be0-5d2bd9755066" ""

[Hemanshu Kumar]

Your data extract is not informative: for none of the rows you show do the strings even look superficially similar. So of course they are not equal. Please show an example which reproduces your problem, make sure to include the top lines (input ... ) and the last line (end), and put it within CODE delimiters, not QUOTE (use the # button on the textbox toolbar, not the one with the quote symbol).

[Leonardo Guizzetti]

Thanks, but I tried it before and it did not help. All the characters are the same. There are no spaces or invisible characters too.

If this is really the case, and I doubt that it is, then the only logical conclusion is that the IDs must be different. I cannot help further unless you can provide a reproducible data example using -dataex- that includes all of the output from that command as suggested already.

[Clyde Schechter]

There aren't any instances your example data where the first string equals the second string in the same observation. Now, your string "057ab4dd-fa4f-4abe-8482-8bc8a55886cd" does occur as the first variable in observation 16 and the second variable in observation 6. But -count if ID == ID1- will not pick that up. That code only picks up situations where the same value of ID and ID1 appear in the same observation. The code you need, to find a match between ID in one observation and ID1 in any (possibly, usually, other) observation, assuming this is what you mean to do, is:

* Example generated by -dataex-. For more info, type help dataex
clear
input str36(ID ID1)
"6f7486a6-5bd6-42d1-bc6c-f1a94f3eaa73" ""                                    
"e887dd78-eb42-4c68-9ab4-cc0f952d4aeb" ""                                    
"e1809cd7-8a66-448b-b10b-e321e4ea74f4" ""                                    
"6cbd04d5-b316-4f16-90dc-b31646f8dd27" ""                                    
"9545561a-d663-4e88-bbe9-fd76996976d8" ""                                    
"f8f03355-2a48-40d8-8b0f-c11ab291ac23" "057ab4dd-fa4f-4abe-8482-8bc8a55886cd"
"62557772-a2b8-431e-b0e8-9811c34228e8" "3611021b-1588-4b1d-8576-c8d47fff22be"
"fcb999cf-c691-428c-acba-06f7c2f406ff" "3172ec35-bd9c-4e50-a854-a74e9cfdcf7c"
"5266ceb9-c226-4f72-9d7b-693853062ba1" "0b6b7fe1-7f9a-485d-844f-df324552ce7d"
"945712e6-0951-45b6-ad31-4197f382c155" "1c5821ac-9467-457b-9ecc-ca4119334462"
"399f876b-923d-4aee-908d-44b38eff9312" "c14bdc43-c256-4fdc-b8f8-d1dcc3958ac0"
"14df99c0-b98f-4871-9756-3f7280f54933" "f17ccaeb-c9f1-4fd4-9513-05b1f6cb795a"
"b57cbdbe-261d-4c8a-8647-4d2a4a16f885" "e50df1e8-81a1-448d-ba5a-679dd0874ba2"
"6c0b8a5c-04e7-4b9b-beb7-e419d5f85ee6" "11d882a8-0f6b-4e5b-83a4-ab41f770e87b"
"6b9ae763-7d2d-49a1-ab11-0ea4bb95b4df" "db262fc5-4ded-4089-8067-07c87b9d16ff"
"057ab4dd-fa4f-4abe-8482-8bc8a55886cd" "4e94f3b3-80a0-4409-a33c-d2736d290617"
"3611021b-1588-4b1d-8576-c8d47fff22be" "d1dde55e-8710-417d-be3d-99647f04cf20"
"3172ec35-bd9c-4e50-a854-a74e9cfdcf7c" "f23c8e17-8152-41f8-9eec-bd96ff1b726f"
"0b6b7fe1-7f9a-485d-844f-df324552ce7d" "addf4171-581f-46cf-a3dc-e881ef1e1c85"
"fa3b7d18-e7e5-4019-972d-4a23258e9485" "9f14dcb9-0d7d-468e-a81d-2e90c8044240"
"cc6cf94a-5420-462d-8be8-871dffe8d62a" "8e8a0f21-7479-4a68-a5b2-d526a80f9c05"
"c77659a9-729c-4b0f-a029-027eb3e950bf" "2b15a4ec-5f5f-4760-a707-4c620f77e486"
"2ea65e5c-3c66-4130-80dc-cbd04a22e371" "1a09d217-98ee-4c1e-a409-2f51ab9d7c32"
"8d358d25-7c62-49b0-944a-3004444175bd" "7aa8bb65-1b96-4040-ad92-61f62ed2e8ed"
"ff5c2809-b49e-4575-b8a0-688d03df749f" "909626be-d236-4ccd-882a-f3d44631a4ae"
"d0575f64-ad92-439b-8f7b-0d071ae31ca3" "0037dfda-d6ce-4bd2-a074-8cd565149a9b"
"c71843b0-fddd-4de7-984b-0540880d6eb8" "9748d8d0-51b4-49fc-885d-aadb2fcb39ac"
"2ef02b10-b4c3-4319-9f5f-544aa9601f89" "83e93d3b-49e0-4910-8f94-2bdc6ed79fc8"
"29672919-d782-4cf0-ac84-b03383ba49ed" ""                                    
"dc0eb7f2-0ae1-46f0-9c57-3a8382756712" ""                                    
"d865ebb9-9255-4edc-8326-66d877bfe829" ""                                    
"078ea453-abb7-4518-9a48-7a89fc5d1628" ""                                    
"daa1344f-bcd1-443e-bda0-7529680e536d" ""                                    
"f98abb6f-7ce6-45f4-87b5-74718309cc1e" ""                                    
"9b7b1d50-1b36-4c65-97dc-b2bc7e221652" ""                                    
"00a97986-90e0-43ac-9571-1f06e99ccd82" ""                                    
"f52756c5-9427-47b1-b40d-c600b36e3992" ""                                    
"3fde0b37-d46f-452b-a6f7-2c9cae4c2c8d" ""                                    
"c37cc82f-18ba-44cf-ab96-cf34332433b0" ""                                    
"9eb005c6-855c-4403-8c19-24b47631b687" ""                                    
"3c11cb53-01a2-4903-88ba-0b46f2528f66" ""                                    
"1b5ba115-390f-43b3-8046-048f6bdabe28" ""                                    
"124e9624-85f5-41df-bc5f-b5cf2673ed66" ""                                    
"e134db34-1c7f-4e22-ae04-f774e66dee5f" ""                                    
"7dabeea9-d364-4a26-85cd-090aae440eea" ""                                    
"212c325b-6495-440b-b7ce-8d4b36b38e71" ""                                    
"2128d8a9-74cc-4539-86ec-9d4e0d53226e" ""                                    
"fe50208e-9631-4b03-9145-2ac7687aeb3b" ""                                    
"d28b862b-ffdf-4e54-a156-e818420d7bfb" ""                                    
"ce977039-7f68-4f19-abf3-2e7202f2f605" ""                                    
"0c835323-e82b-40ca-88d7-d6c28f83e9f7" ""                                    
"e876dc4f-0b79-4394-9c6c-bcb5de25266a" ""                                    
"f67094cc-2353-4100-87b7-e5a3fdbd4a41" ""                                    
"29150928-8478-4807-9774-17f552805117" ""                                    
"a0ee444a-537f-470e-a3af-1dca51b5811e" ""                                    
"c0e2b0bf-6f2c-462f-b3eb-605a6dc6f8fd" ""                                    
"a8fb3814-30e6-452c-bd5c-541e206b1968" ""                                    
"3d1fcc78-fce9-4f74-84f2-23bc6dd7c8cd" ""                                    
"4c66d81b-7d7c-4607-aaee-d66c202dc8ce" ""                                    
"84b1656d-8139-4b35-b2c0-acb8d5a58fad" ""                                    
"54edb979-968f-4e34-b27a-e9b8d71b6493" ""                                    
"84ba51c8-9759-4b77-9c43-af0ee97cacdc" ""                                    
"8b54af89-9ea4-4ac0-9f1a-fdc192126f81" ""                                    
"17787fb8-4ddc-4156-a56f-069142c7a784" ""                                    
"65923d5c-4ace-4640-bd43-49cf136a1174" ""                                    
"4a1e5dc1-7f96-4459-b5c2-c6f30df926d4" ""                                    
"8a9066b1-43a0-4cd4-8420-97824abd28b4" ""                                    
"725ef4bf-7bf1-4dca-b6a2-954f2d22f0cd" ""                                    
"dfff8ea1-21f5-4c0e-9114-162bd77596c0" ""                                    
"98a6371b-bcb0-45ca-8353-13884639807b" ""                                    
"eb9158c5-e26c-424f-9c69-f00b1c5f95d5" ""                                    
"47169bb8-7626-447c-af0d-a9d27eb1185c" ""                                    
"ab0bd7da-90d2-49d3-86c4-e6cad2efdb30" ""                                    
"0874fb63-1380-4bc6-80f4-3c21650ce830" ""                                    
"f24bf697-0ca3-47b1-aa15-8177c85ac437" ""                                    
"0970bdeb-8918-4505-8f51-8ca8b34d75c4" ""                                    
"9007e452-d3b5-483a-b1ae-c12ef28f0552" ""                                    
"05aec304-4921-4360-82d6-f28790866775" ""                                    
"06bf5a98-b83d-4adf-b3a9-dc3846ee0603" ""                                    
"8de12404-f00d-4db8-8875-4660f102b358" ""                                    
"6f2f0e86-c031-4126-be13-c1250298e189" ""                                    
"dac84e26-e0ef-4e7f-9492-0c5a6d5ffb8b" ""                                    
"bf14829e-8950-41a6-8617-6ded2171e741" ""                                    
"c7c9d0b2-8665-4aec-ac1e-bb7fd12b4f63" ""                                    
"e623cdd6-aa33-4493-85be-5e0c059bf5ed" ""                                    
"49c3bc5d-b405-4e71-85fa-f6b97cbd83ff" ""                                    
"454be9f2-188b-449b-82b1-3a129c2d103e" ""                                    
"7dc45812-e839-46ba-ba48-2cff20cd6edb" ""                                    
"5e983cf1-63b3-4a1e-9253-e52a0d1f6720" ""                                    
"1df8f60f-9fa9-4146-968b-bc3bd5f120b1" ""                                    
"a731ba67-cbc0-4862-923e-cd06385918d8" ""                                    
"578d272b-3f5c-4471-83ed-a8c6f451f6ff" ""                                    
"07387a33-fd61-4c7d-a66a-7491c443a6f6" ""                                    
"e4bbf021-5f5b-482e-8645-74ba42b255cd" ""                                    
"220817cc-be04-46f2-93e6-9b13c7dd6280" ""                                    
"ee3011af-14fb-4026-a3d3-705480b3e9cd" ""                                    
"b3076b32-ffb3-460a-9a7b-68b38a975ee8" ""                                    
"8a3f31d4-e2db-4d6c-ae06-1efb02c1e3a0" ""                                    
"8b13c01b-a9f2-4bfa-bbf3-21a0fc6adbe2" ""                                    
"a56e3278-4dd3-40a1-8be0-5d2bd9755066" ""                                    
end

//    SAVE ID1 IN A SEPARATE TEMPORARY FILE
preserve
keep ID1
duplicates drop
rename ID1 ID
tempfile to_match
save `to_match'

//    FIND VALUES OF ID THAT MATCH ANY VALUE OF ID1
restore
merge m:1 ID using `to_match'
count if _merge == 3

[Agnes Weis]

There aren't any instances your example data where the first string equals the second string in the same observation. Now, your string "057ab4dd-fa4f-4abe-8482-8bc8a55886cd" does occur as the first variable in observation 16 and the second variable in observation 6. But -count if ID == ID1- will not pick that up. That code only picks up situations where the same value of ID and ID1 appear in the same observation. The code you need, to find a match between ID in one observation and ID1 in any (possibly, usually, other) observation, assuming this is what you mean to do, is:

* Example generated by -dataex-. For more info, type help dataex
clear
input str36(ID ID1)
"6f7486a6-5bd6-42d1-bc6c-f1a94f3eaa73" ""
"e887dd78-eb42-4c68-9ab4-cc0f952d4aeb" ""
"e1809cd7-8a66-448b-b10b-e321e4ea74f4" ""
"6cbd04d5-b316-4f16-90dc-b31646f8dd27" ""
"9545561a-d663-4e88-bbe9-fd76996976d8" ""
"f8f03355-2a48-40d8-8b0f-c11ab291ac23" "057ab4dd-fa4f-4abe-8482-8bc8a55886cd"
"62557772-a2b8-431e-b0e8-9811c34228e8" "3611021b-1588-4b1d-8576-c8d47fff22be"
"fcb999cf-c691-428c-acba-06f7c2f406ff" "3172ec35-bd9c-4e50-a854-a74e9cfdcf7c"
"5266ceb9-c226-4f72-9d7b-693853062ba1" "0b6b7fe1-7f9a-485d-844f-df324552ce7d"
"945712e6-0951-45b6-ad31-4197f382c155" "1c5821ac-9467-457b-9ecc-ca4119334462"
"399f876b-923d-4aee-908d-44b38eff9312" "c14bdc43-c256-4fdc-b8f8-d1dcc3958ac0"
"14df99c0-b98f-4871-9756-3f7280f54933" "f17ccaeb-c9f1-4fd4-9513-05b1f6cb795a"
"b57cbdbe-261d-4c8a-8647-4d2a4a16f885" "e50df1e8-81a1-448d-ba5a-679dd0874ba2"
"6c0b8a5c-04e7-4b9b-beb7-e419d5f85ee6" "11d882a8-0f6b-4e5b-83a4-ab41f770e87b"
"6b9ae763-7d2d-49a1-ab11-0ea4bb95b4df" "db262fc5-4ded-4089-8067-07c87b9d16ff"
"057ab4dd-fa4f-4abe-8482-8bc8a55886cd" "4e94f3b3-80a0-4409-a33c-d2736d290617"
"3611021b-1588-4b1d-8576-c8d47fff22be" "d1dde55e-8710-417d-be3d-99647f04cf20"
"3172ec35-bd9c-4e50-a854-a74e9cfdcf7c" "f23c8e17-8152-41f8-9eec-bd96ff1b726f"
"0b6b7fe1-7f9a-485d-844f-df324552ce7d" "addf4171-581f-46cf-a3dc-e881ef1e1c85"
"fa3b7d18-e7e5-4019-972d-4a23258e9485" "9f14dcb9-0d7d-468e-a81d-2e90c8044240"
"cc6cf94a-5420-462d-8be8-871dffe8d62a" "8e8a0f21-7479-4a68-a5b2-d526a80f9c05"
"c77659a9-729c-4b0f-a029-027eb3e950bf" "2b15a4ec-5f5f-4760-a707-4c620f77e486"
"2ea65e5c-3c66-4130-80dc-cbd04a22e371" "1a09d217-98ee-4c1e-a409-2f51ab9d7c32"
"8d358d25-7c62-49b0-944a-3004444175bd" "7aa8bb65-1b96-4040-ad92-61f62ed2e8ed"
"ff5c2809-b49e-4575-b8a0-688d03df749f" "909626be-d236-4ccd-882a-f3d44631a4ae"
"d0575f64-ad92-439b-8f7b-0d071ae31ca3" "0037dfda-d6ce-4bd2-a074-8cd565149a9b"
"c71843b0-fddd-4de7-984b-0540880d6eb8" "9748d8d0-51b4-49fc-885d-aadb2fcb39ac"
"2ef02b10-b4c3-4319-9f5f-544aa9601f89" "83e93d3b-49e0-4910-8f94-2bdc6ed79fc8"
"29672919-d782-4cf0-ac84-b03383ba49ed" ""
"dc0eb7f2-0ae1-46f0-9c57-3a8382756712" ""
"d865ebb9-9255-4edc-8326-66d877bfe829" ""
"078ea453-abb7-4518-9a48-7a89fc5d1628" ""
"daa1344f-bcd1-443e-bda0-7529680e536d" ""
"f98abb6f-7ce6-45f4-87b5-74718309cc1e" ""
"9b7b1d50-1b36-4c65-97dc-b2bc7e221652" ""
"00a97986-90e0-43ac-9571-1f06e99ccd82" ""
"f52756c5-9427-47b1-b40d-c600b36e3992" ""
"3fde0b37-d46f-452b-a6f7-2c9cae4c2c8d" ""
"c37cc82f-18ba-44cf-ab96-cf34332433b0" ""
"9eb005c6-855c-4403-8c19-24b47631b687" ""
"3c11cb53-01a2-4903-88ba-0b46f2528f66" ""
"1b5ba115-390f-43b3-8046-048f6bdabe28" ""
"124e9624-85f5-41df-bc5f-b5cf2673ed66" ""
"e134db34-1c7f-4e22-ae04-f774e66dee5f" ""
"7dabeea9-d364-4a26-85cd-090aae440eea" ""
"212c325b-6495-440b-b7ce-8d4b36b38e71" ""
"2128d8a9-74cc-4539-86ec-9d4e0d53226e" ""
"fe50208e-9631-4b03-9145-2ac7687aeb3b" ""
"d28b862b-ffdf-4e54-a156-e818420d7bfb" ""
"ce977039-7f68-4f19-abf3-2e7202f2f605" ""
"0c835323-e82b-40ca-88d7-d6c28f83e9f7" ""
"e876dc4f-0b79-4394-9c6c-bcb5de25266a" ""
"f67094cc-2353-4100-87b7-e5a3fdbd4a41" ""
"29150928-8478-4807-9774-17f552805117" ""
"a0ee444a-537f-470e-a3af-1dca51b5811e" ""
"c0e2b0bf-6f2c-462f-b3eb-605a6dc6f8fd" ""
"a8fb3814-30e6-452c-bd5c-541e206b1968" ""
"3d1fcc78-fce9-4f74-84f2-23bc6dd7c8cd" ""
"4c66d81b-7d7c-4607-aaee-d66c202dc8ce" ""
"84b1656d-8139-4b35-b2c0-acb8d5a58fad" ""
"54edb979-968f-4e34-b27a-e9b8d71b6493" ""
"84ba51c8-9759-4b77-9c43-af0ee97cacdc" ""
"8b54af89-9ea4-4ac0-9f1a-fdc192126f81" ""
"17787fb8-4ddc-4156-a56f-069142c7a784" ""
"65923d5c-4ace-4640-bd43-49cf136a1174" ""
"4a1e5dc1-7f96-4459-b5c2-c6f30df926d4" ""
"8a9066b1-43a0-4cd4-8420-97824abd28b4" ""
"725ef4bf-7bf1-4dca-b6a2-954f2d22f0cd" ""
"dfff8ea1-21f5-4c0e-9114-162bd77596c0" ""
"98a6371b-bcb0-45ca-8353-13884639807b" ""
"eb9158c5-e26c-424f-9c69-f00b1c5f95d5" ""
"47169bb8-7626-447c-af0d-a9d27eb1185c" ""
"ab0bd7da-90d2-49d3-86c4-e6cad2efdb30" ""
"0874fb63-1380-4bc6-80f4-3c21650ce830" ""
"f24bf697-0ca3-47b1-aa15-8177c85ac437" ""
"0970bdeb-8918-4505-8f51-8ca8b34d75c4" ""
"9007e452-d3b5-483a-b1ae-c12ef28f0552" ""
"05aec304-4921-4360-82d6-f28790866775" ""
"06bf5a98-b83d-4adf-b3a9-dc3846ee0603" ""
"8de12404-f00d-4db8-8875-4660f102b358" ""
"6f2f0e86-c031-4126-be13-c1250298e189" ""
"dac84e26-e0ef-4e7f-9492-0c5a6d5ffb8b" ""
"bf14829e-8950-41a6-8617-6ded2171e741" ""
"c7c9d0b2-8665-4aec-ac1e-bb7fd12b4f63" ""
"e623cdd6-aa33-4493-85be-5e0c059bf5ed" ""
"49c3bc5d-b405-4e71-85fa-f6b97cbd83ff" ""
"454be9f2-188b-449b-82b1-3a129c2d103e" ""
"7dc45812-e839-46ba-ba48-2cff20cd6edb" ""
"5e983cf1-63b3-4a1e-9253-e52a0d1f6720" ""
"1df8f60f-9fa9-4146-968b-bc3bd5f120b1" ""
"a731ba67-cbc0-4862-923e-cd06385918d8" ""
"578d272b-3f5c-4471-83ed-a8c6f451f6ff" ""
"07387a33-fd61-4c7d-a66a-7491c443a6f6" ""
"e4bbf021-5f5b-482e-8645-74ba42b255cd" ""
"220817cc-be04-46f2-93e6-9b13c7dd6280" ""
"ee3011af-14fb-4026-a3d3-705480b3e9cd" ""
"b3076b32-ffb3-460a-9a7b-68b38a975ee8" ""
"8a3f31d4-e2db-4d6c-ae06-1efb02c1e3a0" ""
"8b13c01b-a9f2-4bfa-bbf3-21a0fc6adbe2" ""
"a56e3278-4dd3-40a1-8be0-5d2bd9755066" ""
end

// SAVE ID1 IN A SEPARATE TEMPORARY FILE
preserve
keep ID1
duplicates drop
rename ID1 ID
tempfile to_match
save `to_match'

// FIND VALUES OF ID THAT MATCH ANY VALUE OF ID1
restore
merge m:1 ID using `to_match'
count if _merge == 3

Thank you so much, Mr Schechter! You literally saved my life with this.