topic Re: Fiscal year from dates (daily) in SAS Programming

Fiscal year from dates (daily)

amanjot_42 — Thu, 02 Apr 2020 09:23:23 GMT

Hi,

I am trying to create a new column for the respective fiscal year for every date. The fiscal year starts from 1st April and ends on 31st March every year. I have daily data, and I want to create a new column for fiscal years (ending).

Firm ID date fiscal_year(desired)

11 28/06/2010 2011

12 25/02/2016 2016

13 02/04/2018 2019

14 09/12/2019 2020

Regards,

Amanjot

Re: Fiscal year from dates (daily)

PeterClemmensen — Thu, 02 Apr 2020 09:33:52 GMT

Try this

data have;
input FirmID date :ddmmyy10.;
format date ddmmyy10.;
datalines;
11 28/06/2010
12 25/02/2016
13 02/04/2018
14 09/12/2019
;

data want;
   set have;
   FiscalYear = year(intnx("year.4", date, 0, "e"));
run;

Result:

FirmID date        FiscalYear 
11     28/06/2010  2011 
12     25/02/2016  2016 
13     02/04/2018  2019 
14     09/12/2019  2020

Re: Fiscal year from dates (daily)

amanjot_42 — Thu, 02 Apr 2020 10:19:50 GMT

Hi,

Thank you so much!

It worked perfectly.

Regards,