Filter by current fiscal year using a Macro

[LAtwood]

Hello,

I have a query that selects a single day's data using the macro &date.

Create table work.temptpc

select t1.cc, t1.turn_dt, t1.delay_hrs

from imcs.pay_tpc_prd_a t1

where turn_date = "&date"d

My question is I now would like the query to also grab (filter) our fiscal year data from imcs.pay_tpc_prd_a from the date selected using macro &date.  Our fiscal year is April 1 - March 31.

Example:  If the date selected was September 1, 2013, the fiscal year would be April 1, 2013 - March 31, 2014.

Thanks for your help in advance,

Lori

[SteveNZ · Accepted solution]

Hiya,

Create the following macros using your &date one to subset:

	data _null_ ;
	call symput('fstart',intnx('year.4',&date,0,'b')) ;
	call symput('fend',intnx('year.4',&date,1,'b')-1) ;

    run ;

cheers

Steve