Hi all,
I would like to merge two datasets by identifier and date within range
dataset A:
accountnumber variableA date
dataset B:
accountnumber variableB startdate enddate
I would like to have a dataset like:
accountnumber variableA variableB date
where date would be between startdate and enddate
I looked at range join, but it seems like it would only accomplish merging using one variable? But I would like to have oaccountumber matched as well.
Thanks so much!
Related Posts with Merge identifier and date within range
Update to -iscogen- available from SSCAn update to the iscogen package is now available from SSC. Type Code: . ssc install iscogen, repl…
stata doesn't recognize missings in string variableI want to delete observations that have missing data for a particular variable but stata does not re…
Changing the date formatCurrently, I have the variable, calldate, which is in the format 09jul2019, 10jul2019, etc. Is ther…
Update to -kmatch- available from SSCA maintenance update to kmatch is now available from SSC. Type Code: . ssc install kmatch, replace…
Stata Matrix errorHi. I am doing a regression based decomposition analysis. This is my code Code: global X "Educatio…
Subscribe to:
Post Comments (Atom)
0 Response to Merge identifier and date within range
Post a Comment