topic Re: intnx function in SAS Programming

intnx function

BrahmanandaRao — Fri, 18 Jun 2021 15:54:46 GMT

data  dsn;
res=intnx('day','1jan1960'd,today());
format date date9.;
proc print;
run;

Here I want to know days between from 1JAN1960 to today

intnx or intck which one

Re: intnx function

PaigeMiller — Fri, 18 Jun 2021 16:09:22 GMT

@BrahmanandaRao wrote:
data  dsn;
res=intnx('day','1jan1960'd,today());
format date date9.;
proc print;
run;
Here I want to know days between from 1JAN1960 to today

intnx or intck which one

Simple! Try INTNX and if that doesn't give you the answer you want, try INTCK. (Or look it up in the SAS documentation)

Side issue: TODAY() gives you the number of days since 01JAN1960, no need to compute it via some other function.

Re: intnx function

Reeza — Fri, 18 Jun 2021 16:09:23 GMT

Let's check the documentation.

INTNX Function

Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value.

INTCK Function

Returns the number of interval boundaries of a given kind that lie between two dates, times, or datetime values.

And the documentation is available in multiple languages.

@BrahmanandaRao wrote:
data  dsn;
res=intnx('day','1jan1960'd,today());
format date date9.;
proc print;
run;
Here I want to know days between from 1JAN1960 to today

intnx or intck which one

Re: intnx function

SASJedi — Fri, 18 Jun 2021 16:24:27 GMT

Try this:

data  _null_;
   Today=today();
   /* Use INTNX to produce a date value incremented from a start date */
   TargetDate=intnx('day',Today,30);
   /* Use INTCK to count the number of intervals between two dates */
   DaysBetween=intck('day',Today,TargetDate);
   format T: mmddyy10.;
   file print;
   put Today= TargetDate= DaysBetween=;
run;

Results:

Today=06/18/2021 TargetDate=07/18/2021 DaysBetween=30

Re: intnx function

BrahmanandaRao — Fri, 18 Jun 2021 16:32:26 GMT

I want no of days between 1JAN1960 to today

Re: intnx function

Kurt_Bremser — Fri, 18 Jun 2021 16:53:00 GMT

@BrahmanandaRao wrote:

I want no of days between 1JAN1960 to today

You already got the answer to that.

Re: intnx function

BrahmanandaRao — Fri, 18 Jun 2021 17:18:17 GMT

I did not get answer

Re: intnx function

Reeza — Fri, 18 Jun 2021 17:21:54 GMT

I 100% guarantee if you read this paper you will have the answer.
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

Re: intnx function

Kurt_Bremser — Fri, 18 Jun 2021 17:22:25 GMT

@BrahmanandaRao wrote:
I did not get answer

Learn to read.

Quote from PaigeMiller's post in this thread :

Side issue: TODAY() gives you the number of days since 01JAN1960, no need to compute it via some other function.

Re: intnx function

BrahmanandaRao — Fri, 18 Jun 2021 18:28:02 GMT

Any one correct my code i did not get idea

Re: intnx function

Sajid01 — Fri, 18 Jun 2021 18:27:15 GMT

Hello @BrahmanandaRao
You want to know number of days since January 1,1960.
Any SAS date is number of days since January 1,1960. If no output format is specified than SAS prints or stores dates since January 1,1960. Look at this example below. No special function needed

data _null_;
days_since01JAN1960=today();
put days_since01JAN1960=;
run;
/*Log output will be like this*/
1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data _null_;
 74         days_since01JAN1960=today();
 75         put days_since01JAN1960=;
 76         run;
 
 days_since01JAN1960=22449

Hope you have your answer .

Re: intnx function

PaigeMiller — Fri, 18 Jun 2021 18:29:11 GMT

data want;
     number_of_days_since_01JAN1960=today();
run;

Re: intnx function

ballardw — Sat, 19 Jun 2021 01:31:33 GMT

@BrahmanandaRao wrote:
Any one correct my code i did not get idea

Show the log of the code you ran that "did not get idea".