topic intnx function in New SAS User

intnx function

Schmageggy — Fri, 03 May 2019 18:49:46 GMT

I'm trying to increment a date time that is formatted 19FEB2019:00:00:00.000, using the intnx function by 10 days, but

Using this code:

INTNX('dtday', t1.CLCL_RECD_DT,10)

is returning 1867017600

and i'm not entirely sure what to do with that, is that 10 days after in seconds? Can I convert it?

Re: intnx function

novinosrin — Fri, 03 May 2019 18:59:54 GMT

You can apply format=datetime20. to your result.

Yes it is 10 days after in seconds

you could use a datepart function if you want to extract date value from datetime value. Not sure what you want to do though

Re: intnx function

Tom — Fri, 03 May 2019 19:12:39 GMT

That is what you asked for. Attach a datetime format, like DATETIME19., to the variable and it will be displayed in a more human readable way.

108   data _null_;
109   old='19FEB2019:00:00:00.000'dt;
110   new=intnx('dtday',old,10);
111   put old= old comma19. old datetime19.;
112   put new= new comma19. new datetime19.;
113   run;

old=1866153600       1,866,153,600 19FEB2019:00:00:00
new=1867017600       1,867,017,600 01MAR2019:00:00:00

Re: intnx function

Schmageggy — Sat, 04 May 2019 10:58:02 GMT

both of these solutions are very helpful and I appreciate, really the first
one is all I needed to use in a between filter. thank you though will use
it for the output

Re: intnx function

Tom — Sat, 04 May 2019 16:21:08 GMT

@Schmageggy wrote:
both of these solutions are very helpful and I appreciate, really the first
one is all I needed to use in a between filter. thank you though will use
it for the output

Right. There is no need to attach the format to use the value in code. The formats just make the values easier for humans to read.

1867017600 and '01MAR2019:00:00:00'dt represent the same underlying numeric value.