topic Re: Where Date in table A is within 35 days of date in table B in SAS Enterprise Guide

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

Dogo23 — Tue, 22 May 2018 16:28:50 GMT

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 ???

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

novinosrin — Tue, 22 May 2018 16:59:47 GMT

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;

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

art297 — Tue, 22 May 2018 16:59:38 GMT

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-a-begin-date-and/td-p/204415

Art, CEO, AnalystFinder.com