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.
Related Posts with Date Conversion
Combining datasetsStata friends, I've struggled with this one for a while and hope someone can help me. I have two da…
Median from multiple variablesHi everyone, After hours of searching, I cannot figure out how to take the median of multiple colum…
Coefplot and headlingsHi, This is my first time posting, so if I break some rule please have patience with me. My problem…
asdoc eform no longer workingHello everybody, I run a Poisson regression for panel data using xtpoisson with the irr option. I w…
How do you find the r-squared and f-stat for an ARDL panel data model?Hi, I'm running a panel data ARDL model to see If there's a relationship between GDP per capita and …
Subscribe to:
Post Comments (Atom)
0 Response to Date Conversion
Post a Comment