SAS Enterprise Guide

Desktop productivity for business analysts and programmers
BookmarkSubscribeRSS Feed
alepage
Barite | Level 11

Hello,

I am using the intnx function to estimate new dates based on the interval.

In term of interval, I am trying to find the documentation on it. Maybe I am not lucky.

 

it could be day, week, month, quarter and year.

What's the name of a four months interval.?

 

How do we define a custom interval ?

Please provide an example.

 

Also, in a old calendar,  I have something refering to prv begining of the year and end of the year

which gives 28DEC2013 02JAN2015

Does someones know what it is

 28DEC2013 is a Saturday and  02JAN2015 is a Friday.

So some week definition that start a Saturday and finish on Friday

 

 

 

 

1 REPLY 1
PaigeMiller
Diamond | Level 26

Intervals you can use in INTNX, from the documentation

https://documentation.sas.com/doc/en/pgmmvacdc/9.4/leforinforref/n0pxq4af0hx60nn1i1x3xn41mc3c.htm#n0...

 

For custom intervals, scroll down in the documentation to "Multi-Unit Intervals"

 

Regarding weeks that go from Saturday to Friday, you can scroll down to "Shifted Intervals"

--
Paige Miller

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1 reply
  • 286 views
  • 1 like
  • 2 in conversation