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
Removing duplicatesHi Statalist, I have this variable: Code: * Example generated by -dataex-. To install: ssc instal…
Complicate box plotHii guys, I have a database made as follows: Code: * Example generated by -dataex-. To install: s…
How to count a purchase date of medicines?Hello! This is Babar, quite new here in this forum and here is my first question. " I have a long d…
Expressing all other variables in deviation from the cross-section mean of 'year' variableHello everyone, I am a STATA novice and still getting to grips with the software. I am running a l…
test of endogeneityHow to find which variable is endogenous before finding an instrument for it (before 2sls test)? …
Subscribe to:
Post Comments (Atom)
0 Response to Doing Merge using rangejoin
Post a Comment