Joining Dates between periods

[Tihannah]

I am needing to join tables on for an event date, but to also pull in any data for one day before and one day after the event date. Not sure how to write the code for the join? 

[novinosrin]

Your question needs to be well explained.

1. Give us the community sample data

2. Explain your requirement referring to the data in your sample

3. Also give us the output sample that you want  

Please be clearly descriptive as possible. Thank you!

[Tihannah · Accepted solution]

I figured it out. Simple fix. Just couldn't think at the moment. 

The code I used was:

(Left join) where t2.date between t1.date-1 and t1.date+1

Thanks.

[kiranv_]

made up an example, may be something like this.

data have1;
input name $ event:mmddyy10.;
format event mmddyy10.;
datalines;
smith 09/23/2005
Sam 10/11/2016
Pam 05/15/2016
;
run;


data have2;
input name $ event1:mmddyy10. price;
format event1 mmddyy10.;
datalines;
smith 09/23/2005 10
smith 09/02/2005 20
smith 09/24/2005 25
smith 09/28/2005 35
Sam 10/11/2016 22
Sam 10/12/2016 17
Sam 10/11/2016 60
Sam 10/02/2016 70
Pam 05/18/2016 50
;
run;

proc sql;
select a.name, event1, price 
from have1 a
inner join
have2 b
on a.name =b.name
and (a.event=b.event1
or a.event=b.event1 -1
or a.event=b.event1 +1);