BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
LAtwood
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
SteveNZ
Obsidian | Level 7

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

1 REPLY 1
SteveNZ
Obsidian | Level 7

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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