WHERE LOGIC

manya92 — Tue, 24 Jul 2018 17:42:26 GMT

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 ;

Re: WHERE LOGIC

ChrisNZ — Tue, 24 Jul 2018 23:38:19 GMT

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;

topic WHERE LOGIC in SAS Programming

WHERE LOGIC

Re: WHERE LOGIC