With SAS VA (I'm assuming you are using SAS Visual Analytics on Viya 4) you have two choices. Either you can calculate your financial year when preparing the data to be loaded into memory or you can create a VA formula that will derive the FY once the data is loaded into memory. Personally I find it easier to do this when preparing the data:
data Want;
input trandate ddmmyy10. Amount;
FY_Date = intnx ('YEAR.4', trandate, 0, 'END');
format trandate FY_Date date9.;
datalines;
25/02/2022 100
31/03/2022 50
12/05/2022 100
10/09/2022 150
02/03/2023 75
31/03/2023 100
05/10/2023 200
13/11/2023 150
;
run;
... View more