As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Tip of the Day:June 25"

From sasCommunity
Jump to: navigation, search
m (Scheduled Increasing the Size of an Index Page)
(Scheduled INTNX function with Federal Fiscal Year)
 
Line 5: Line 5:
 
sasCommunity Tip of the Day
 
sasCommunity Tip of the Day
 
</h1><div style="padding:10px;">
 
</h1><div style="padding:10px;">
{{Tips:Increasing the Size of an Index Page}}
+
{{Tips:INTNX function with Federal Fiscal Year}}
 
<div style="width:100%"><hr></div>
 
<div style="width:100%"><hr></div>
Feel free to [[Tips Talk:Increasing the Size of an Index Page|comment]] on this tip.
+
Feel free to [[Tips Talk:INTNX function with Federal Fiscal Year|comment]] on this tip.
 
</div>
 
</div>
 
</td></tr>
 
</td></tr>

Latest revision as of 20:47, 17 June 2014

sasCommunity Tip of the Day

The INTNX function takes a supplied date, time, or datetime value and can shift it by any specified alignment you choose. For example, if you need to know the first day of the current calendar year, you can use the following formula:

intnx('YEAR', today(), 0, 'B')

But what if you need to know the beginning of an odd year format, such as the Federal Fiscal Year? The federal fiscal year starts October 1 and runs through September 30. For example, FFY2010 is October 1, 2009 through September 30, 2010. The optional shift-index portion of the interval argument can shift the interval to start at a specified subperiod starting point. For example, 'YEAR.10' specifies yearly periods shifted to start on the first of October of each calendar year and to end in September of the following year. In other words, to find the first day of the current Federal Fiscal Year, you would use:

intnx('YEAR.10', today(), 0, 'B')
Submitted By Tasha Chapman



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip