Hello, I am a new member to this forum! Nice to meet you all.
I have just went through set of posts regarding rangejoin, but I could not apply it to my own data project, and all helps would be very grateful!
So, I have two data sets where
use dataSet1
PERMNO FIRSTDATE LASTDATE
25881 19701113 19780630
10015 19830920 19860731
10023 19721214 19730605
and
use dataSet2
PERMNO TargetDate
25881 19701220
10015 19840305
10023 19721216
and on.
so, using dataset 1, I ran the following code
(Both my FirstDate and LastDate are in long format)
rangejoin NamesDate FirstDate LastDate using dataSet2.dta, by (PERMNO)
but I am getting
no observation with valid interval bounds to use as my error message. Would anyone be willing to help me out? Thank you all.
Related Posts with Doing Merge using rangejoin
Wanted: New Home for Survey Sampling textsI've retired from professional work and I'd like to donate the stat books in my library to a good ho…
Need help with creating a Growth Incidence Curve in Stata. I am very new to this wonderful software.Hey there! My name is Philip and I'm currently studying for a bachelors degree in economics. I reall…
Panel regression with moderatorDear all, I am conducting a fixed effects panel regression with a IV several DVs and a moderator (M…
Dropping unmatched dataHi everyone, I need some help in processing data for my phd research. I started with a dataset inclu…
Endogeneity 2SLSHi there, I have to report on the difference in estimates of 2SLS and OLS (same model) and the endo…
Subscribe to:
Post Comments (Atom)
0 Response to Doing Merge using rangejoin
Post a Comment