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.
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.
Comment