WHERE LOGIC

[manya92]

Hi, 

I need to write a code for the condition given below :-

All patients must have 365 days of eligibility prior to the index_date and 365 days of eligibility after the index_date. 

Below is the code i wrote. Is that correct ?

proc sql;
	create table DATASET_A as  
	select distinct a.*, b.period_start, b.period_stop
	from DATASET_b as a 
	inner join DATASET_c as b 
	on a.enrolid = b.enrolid 
	where ((a.index_date -365) le b.period_start le (a.index_date) AND (a.index_date) le b.period_stop ge (a.index_date +365));
quit ;

[ChrisNZ]

Assuming eligibility means what I think (you haven't told us), wouldn't this fill the criteria?

where b.PERIOD_START <= a.INDEX_DATE-365 and b.PERIOD_STOP >= a.index_date+365;