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
Generate treatment variables for panel data analysisDear community, I am working on a panel data analysis, where I have to generate a treatment variabl…
Extracting First Character in a String that Satisfies a ConditionHello, My data contains in each row: (1) a string variable of different lengths ("String") (2) a n…
How to use command cem to get the exact results from command kmatch?I want to compare whether the results of user-command Code: cem and Code: kmatch are the same. Ho…
Interaction in manual DIDHello, Im running a DID model( over two waves of a longitudinal survey) where the code that I use i…
Alternative-specific constant equal to nest in nested logitDear all, I am using a nested logit model to analyze a discrete choice experiment. I have one nest …
Subscribe to:
Post Comments (Atom)
0 Response to Doing Merge using rangejoin
Post a Comment