Hello,

I am trying to expend one data set with another data set by using the command "append using, keep (...)". However, I have realised that the "date" variable in both data sets do not have the same format. In the master data set the date is formatted as " 5 August 2020" while in the other data set it is formatted as "Sunday, 17th November 2019". I have realised that there seems a problem in expanding variable observations if they are not in the same format. It looks like the data entries for the dates are ignored when expanding the master data set. Can someone help with formatting "Sunday, 17th November 2019" into a proper date format for appending?

Thank you.