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
Why F-test is missing? Could you please help!Hi, I run some regressions, but the F-test is missing. I read some previous posts related to this i…
Creating a variable containing number of decimal points of another variable's valuesHi, I have a variable measuring speed. The values are double and vary in the number of decimal point…
Instrumental Variable HelpHi, I'm having trouble with a new instrumental variable. So I'm trying to find some causality, betw…
Code that picks up sudden spikes in prices Code: * Example generated by -dataex-. To install: ssc install dataex clear input double op …
Multiple Regression analysis: Explanatory Variable as percentageIn STATA when I do a regression analysis and the y variable is expressed in a percentage, I normally…
Subscribe to:
Post Comments (Atom)
0 Response to Doing Merge using rangejoin
Post a Comment