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.


Tips Talk:INTNX function with Federal Fiscal Year

From sasCommunity
Jump to: navigation, search

I think one tip on this issue is sufficient. See Tips:Federal Fiscal Year Date Conversion. How about picking one preferred method.--Howles 01:02, 30 August 2011 (UTC)


I disagree. The other tip (which I also submitted) shows an algorithm that creates a FFY year variable based on a given date, which can be used as a class variable, etc. This shows how to shift a date to the beginning (or end or what-have-you) of the FFY, which can be used as an automated date parameter or the like. It is two different issues. --Tasha


Given how common a Federal Fiscal Year is, I am not too concerned about a duplicate tip. I do agree with Howard that these overlap. I would suggest that each Tip be updated so that there is a short description of the other one with a link. --Don Henderson 21:55, 31 August 2011 (UTC)


I suppose it depends on one's frame of reference, and whether one is interested in result or technique. The discussion of the earlier tip included several methods. They were all one-liners, which can be advantageeous vis a vis the IF/THEN/ELSE construct. As Andrew Howell pointed out, the INTNX function is the tool designed for this sort of problem. So let's compare his formula with Tasha's from the present tip:

Andrew   year(intnx("MONTH12.10",open_date,0, "E") )
Tasha         intnx(   'YEAR.10',today()  ,0, 'B')

There are 4 differences. In the first INTNX argument, MONTH12 and Year are synonymous. The second arguments are examples not prescriptions; any in-range expression is permitted. So we're down to 2 differences. In the fourth argument, Andrew generates the last day of the fiscal year while Tasha generates the first. Finally, Andrew uses the year function to transform the SAS date into a simple year number.

To me, these are variations on a theme. The big lesson is using the interval offset (.10) to model the fiscal year. --Howles 21:59, 31 August 2011 (UTC)


All are very good points. I didn't notice the changes to the discussion page on the other tip until now (call it simultaneous inspiration), but I can see where the similarities lie. On the flipside, Andrew's suggestions are currently hidden in the discussion of an old tip, not exactly the most accessible location. In any case, I leave it up to the general concensus to decide, and am willing to make any revisions necessary. Also, since Andrew had the idea first, he's certainly welcome to present this tip or something similar under his own name if he so desires. --Tasha


Perhaps an article that summarizes these points, with links to the earlier discussion would be a good way to deal with this. That article could be see also link for any relevant tip. --Don Henderson 18:41, 4 September 2011 (UTC)


That works for me. As it turns out I have a draft paper available already that can be used. --Tasha


Tasha, If you are going to expand this, think of also including the closely related topic I posted at: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1109a&L=sas-l&D=1&O=A&P=10497

I was going to post the tip separately, but you have my permission to include it in your own tip. --Art T 22:53, 25 September 2011 (UTC)


But keep in mind that tips are not good candidates for expansion. Better to create/expand pertinent Sasopedia pages to which the tips can link.--Howles 23:09, 25 September 2011 (UTC)


Good work, Tasha. I understood your tip, clearly written, explained, and illustrated. Charlie Shipp 01:12, 9 May 2012 (EDT)


Interesting new perspective on a classic topic. Good tip! --Murphy Choy From Singapore 12:18, 11 May 2012 (EDT)