Filter by current fiscal year using a Macro

LAtwood — Mon, 16 Sep 2013 19:22:10 GMT

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

Re: Filter by current fiscal year using a Macro

SteveNZ — Mon, 16 Sep 2013 21:07:15 GMT

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

topic Re: Filter by current fiscal year using a Macro in SAS Programming

Filter by current fiscal year using a Macro

Re: Filter by current fiscal year using a Macro