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

Hi All,

Just trying to calculate number of days between the following two dates. Looking forward for your advise please?

Regards,

Naeem

11DEC2013:20:52:39.000

21NOV2013:04:45:43.000

1 ACCEPTED SOLUTION

Accepted Solutions
slchen
Lapis Lazuli | Level 10

data _null_;
date1='11DEC2013:20:52:39.000'dt;
date2='21NOV2013:04:45:43.000'dt;
day1=intck('second',date2,date1)/86400;

day2=round(day1);

day3=floor(day1);

put day1 day2 day3;
run;

View solution in original post

2 REPLIES 2
slchen
Lapis Lazuli | Level 10

data _null_;
date1='11DEC2013:20:52:39.000'dt;
date2='21NOV2013:04:45:43.000'dt;
day1=intck('second',date2,date1)/86400;

day2=round(day1);

day3=floor(day1);

put day1 day2 day3;
run;

RichardinOz
Quartz | Level 8

The day1 calculation is no different from (date2 - date1)/86400 ;

I would prefer to use 'dtdate' instead of 'second':

     day1=intck('dtdate',date2,date1) ;


'dtdate' is measuring days in datetime, ie seconds.


Richard

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

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 875 views
  • 3 likes
  • 3 in conversation