BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
robertrao
Quartz | Level 8

Hi,

I am trying to find if date variable is greater than surgery variable by 35days

both are dates.

is this below code right??????

data want;

set have;

if date ge (Surgery - 60*60*24*35);

run;

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Vince28_Statcan
Quartz | Level 8

That would work if your values were datetime, not date. Date formats are stored as the number of days since a fixed date (01/01/1960) so you'd simply need to substract 35.

It is typically best to get accustomed to the intnx function though for date distance. I'll let you look that up.

View solution in original post

1 REPLY 1
Vince28_Statcan
Quartz | Level 8

That would work if your values were datetime, not date. Date formats are stored as the number of days since a fixed date (01/01/1960) so you'd simply need to substract 35.

It is typically best to get accustomed to the intnx function though for date distance. I'll let you look that up.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 992 views
  • 0 likes
  • 2 in conversation