topic Re: INTNX function in SAS Programming

INTNX function

albribmun — Mon, 13 Jun 2022 16:06:06 GMT

Hi,

I would like to be able to select data where the 'send date' of my dataset refers to the last 3 weeks from today.

Thanks.

Re: INTNX function

Quentin — Mon, 13 Jun 2022 16:18:52 GMT

Hi,

Please show what code you have tried, and describe why it didn't work (did you get an error? did you get a surprising result?).

Also, please define your selection criteria more precisely. Do you want to select all records where FECHA_ENVIO is within 21 days of today's date (the date the program is run)?

Perhaps:

if (today() - datepart(fecha_envio)) <=21  ;

Re: INTNX function

Reeza — Mon, 13 Jun 2022 16:23:11 GMT

where fecha_envio > intnx('dtweek', today(), -3, 'b');

Thinks you should consider - what defines a week? Is it 21 days before exactly or does it start on Sunday's? Does it start at the same times as when you run the report (e.g 10:23) or is at the start of the day (00:00)? You control these choices with the first and last parameter in the INTNX function.

Re: INTNX function

albribmun — Mon, 13 Jun 2022 16:24:51 GMT

Yes, I want to get all records for all other variables where the date is between the last 3 weeks. The code does not give me error, but the table is not displayed.

Re: INTNX function

albribmun — Mon, 13 Jun 2022 16:32:12 GMT

I have executed the command you say and it does not give me an error but it does not give me the expected result.

Re: INTNX function

Reeza — Mon, 13 Jun 2022 16:36:34 GMT

intnx('dtday', today(), -21, 'b');

Try that one instead

Re: INTNX function

Quentin — Mon, 13 Jun 2022 16:36:35 GMT

Can you show the log? It should show the number of records read in, and the number of records written out. It may also show errors, warnings, or bad notes.

Re: INTNX function

Kurt_Bremser — Mon, 13 Jun 2022 16:38:15 GMT

The datetimes you show are ALL before three weeks before today.

Re: INTNX function

albribmun — Tue, 14 Jun 2022 07:42:47 GMT

Not all

Log:

Re: INTNX function

Kurt_Bremser — Tue, 14 Jun 2022 09:51:31 GMT

@albribmun wrote:

Not all

And as your log tells you, 885 observations met the condition and were read and written to the new dataset.

Please do not post pictures. Copy/paste log text to a window opened with this button:

To supply example data for our use in developing and testing code, use a data step with datalines, and post it as text in a window opened with the "little running man" right next to the one indicated.

Re: INTNX function

Tom — Tue, 14 Jun 2022 12:38:56 GMT

Note that TODAY() is just an alias for the DATE() function.

So the function TODAY() returns a DATE value (number of days since 1960).

The DTDAY interval works with DATETIME values (number of seconds since 1960).

If you treat the number of days since 1960 as the number of seconds since 1960 you get some time early on January 1,1960.

If you want the current datetime value use the DATETIME() function.

Re: INTNX function

albribmun — Tue, 14 Jun 2022 16:42:33 GMT

I have already found the solution using this:

if intck('week', today(), datepart(fecha_envio)) ge -3