I know this is an old post but I found it in my efforts to do some state fiscal year stuff. I tried the above programs that were posted and I found them difficult and cumbersome. I ended up scrapping them and came up with the above. This would be for fiscal years that run July 1 to June 30 but could be easily adapted to the start and stop dates that you need. Just wanted to put this out there for other users. data work.appointments (drop=appt_year appt_month); set WORK.QUERY_FOR_APPOINTMENTS ; format appt_date date9.; appt_date = datepart(appointment_date); appt_year = year(appt_date); appt_month = month(appt_date); if appt_month ge 7 then do; sfy = appt_year+1; if appt_month in (7,8,9) then qtr = 1; else if appt_month in (10,11,12) then qtr = 2; end; else if appt_month le 6 then do; sfy = appt_year; if appt_month in (1,2,3) then qtr = 3; else if appt_month in (4,5,6) then qtr = 4; end; run;
... View more