Hello Experts,
My Date_1 < Date_2 so I would like to get only the observation with 7 days diffrence. Could you tell me if my code is right :
proc sql;
create table Result as select a.*, b.* from total_RE as a
left join SUP as b on a.pers=b.pers
and intck('day',b.D_1, a.D_2)<7;
quit;
Thank you !
Exactly 7 days? 7 days or less? Or less than 7 days?
Assuming your date variables have DATE values then they are already stored as a number of days, so there is no need to use any special functions to check the differences.
To test if D2 is between D1 and up to 7 days after D1 just use:
proc sql;
create table Result as
select a.*, b.*
from total_RE as a
left join SUP as b
on a.pers=b.pers
and a.D_2 between b.D_1 and b.D_1+7
;
quit;
If you actually have DATETIME values then you would need to use INTNX() or INTCK() since those values are stored as number of seconds. But you would need to use the DTDATE interval and not the DATE interval.
@SASdevAnneMarie wrote:
My Date_1 < Date_2 so I would like to get only the observation with 7 days diffrence. Could you tell me if my code is right :
Did you actually try running this code? SAS will tell you if the code is right, and do so more quickly and more authoritatively than anyone here can do (especially since we don't have your data).
There do not appear to me to be any syntax errors (but again SAS will give you are more authoritative answer). I question the logic in the code which doesn't seem to match the words you used; 7 days difference would be
intck('day',b.D_1, a.D_2)=7
Since dates in SAS are counts of days, the INTCK call is not necessary.
and a.D_2 - b.D_1 = 7
Exactly 7 days? 7 days or less? Or less than 7 days?
Assuming your date variables have DATE values then they are already stored as a number of days, so there is no need to use any special functions to check the differences.
To test if D2 is between D1 and up to 7 days after D1 just use:
proc sql;
create table Result as
select a.*, b.*
from total_RE as a
left join SUP as b
on a.pers=b.pers
and a.D_2 between b.D_1 and b.D_1+7
;
quit;
If you actually have DATETIME values then you would need to use INTNX() or INTCK() since those values are stored as number of seconds. But you would need to use the DTDATE interval and not the DATE interval.
Then you have to use INTNX or INTCK with a DTDAY interval.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: