Where Date in table A is within 35 days of date in table B

[Dogo23]

Hi all,

I'm joining an email activity table (table a) with a email history table (table b). I'm using an inner join to give me all data from table a where the activity_date in that table is within 35 days of the campaign_date (attribution reasons). I'm not sure how the syntax for that works in SAS EG. Can someone help please?

Thanks!

proc sql;
select * 
	from email_campaign_activity a
	inner join
	email_campaign_history b 
	on a.email_campaign_id = b.email_campaign_id
	where ???

[novinosrin · Accepted solution]

Please meddle around this and see if this works

The addition is 

intck('days',activity_date, campaign_date)<=35;

proc sql;
select * 
	from email_campaign_activity a
	inner join
	email_campaign_history b 
	on a.email_campaign_id = b.email_campaign_id and intck('days',activity_date, campaign_date)<=35;
	quit;

[art297]

You didn't provide enough info to show you how to write the code, but take a look at the last post in the thread: https://communities.sas.com/t5/General-SAS-Programming/Checking-if-a-transaction-date-falls-between-...

Art, CEO, AnalystFinder.com