Hi,
I have 2 datasets that need to be merged in one using variable Date (both MDY). The master dataset contains financial data on stock prices and the using dataset contains data about terrorists attacks.
However, I am not able to merge them due to differences in storage type. Master's Date variable is Int whilst of using is string.
When I try to translate it into a date variable STATA gives: 8,236 missing values generated (all values) or the error: type mismatch.
And when I try to destring the string variable, the values change and the values do not match with the other Date variable.
What can I do?
Thank you in advance,
Rosa
I have 2 datasets that need to be merged in one using variable Date (both MDY). The master dataset contains financial data on stock prices and the using dataset contains data about terrorists attacks.
However, I am not able to merge them due to differences in storage type. Master's Date variable is Int whilst of using is string.
When I try to translate it into a date variable STATA gives: 8,236 missing values generated (all values) or the error: type mismatch.
And when I try to destring the string variable, the values change and the values do not match with the other Date variable.
What can I do?
Thank you in advance,
Rosa
Comment