Hello, I'm trying to merge two datasets using a variable called sur_mon_yr that is month/year. E.g. 01/2010
When merging by sur_mon_yr, there is no match.
I suspect this is because one dataset has sur_mon_yr in %tmNN/CCYY format whereas the other dataset uses %tdNN/CCYY format.
I tried changing the format of the variables to match but it's not working.
For example, if %tdNN/CCYY is changed to %tmNN/CCYY, the observation changes from 01/2010 to 01/3497.
On the other hand, if %tmNN/CCYY is changed to %tdNN/CCYY, the observation changes from 01/2020 to 08/1961.
I'm not sure how to get the two sur_mon_yr variables to have the same format such that they can merge and match.

Many thanks for your help,
Harry