DATA Step, Macro, Functions and more

Filter by current fiscal year using a Macro

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 83
Accepted Solution

Filter by current fiscal year using a Macro

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


Accepted Solutions
Solution
‎09-16-2013 05:07 PM
Frequent Contributor
Posts: 87

Re: Filter by current fiscal year using a Macro

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

View solution in original post


All Replies
Solution
‎09-16-2013 05:07 PM
Frequent Contributor
Posts: 87

Re: Filter by current fiscal year using a Macro

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 197 views
  • 1 like
  • 2 in conversation