topic Finding the number of days between a particular date to today. in New SAS User

Finding the number of days between a particular date to today.

Sandeep77 — Thu, 23 Feb 2023 14:12:07 GMT

Hi all,

I have a dataset called Adding_120A. It has EnteredAccountStatusDate column. I want to add a column which shows the number of days between EnteredAccountStatusDate and today's date. I have written a code but it adds a column but there is no data in the column. Below is the code I have written and the Note message from the log.

Data Adding_120A;
Set Adding_120A;
today=today();
No_of_days=intck('d',EnteredAccountStatusDate,today);
run;

NOTE: Invalid argument to function INTCK('d',23023,23064) at line 32 column 12.

Re: Finding the number of days between a particular date to today.

Tom — Thu, 23 Feb 2023 14:15:28 GMT

There is no interval named D that INTCK() understands. Did you mean to use 'DAY'?

But if you have date values you can just subtract them to calculate day differences. Dates are stored as a number of days and you don't have to use INTCK() or INTNX() when the interval you are using is the basic storage unit of the values.

Re: Finding the number of days between a particular date to today.

Sandeep77 — Thu, 23 Feb 2023 14:19:42 GMT

okay, I changed 'd 'with 'day' and now it is showing the number of days. Thanks

Re: Finding the number of days between a particular date to today.

Kurt_Bremser — Thu, 23 Feb 2023 15:02:40 GMT

SAS dates are counts of days, so you do not need the INTCK function to determine a difference in days:

No_of_days = today() - EnteredAccountStatusDate;