Flexible fiscal week from date column

hk24 — Tue, 14 Nov 2023 20:07:09 GMT

In the given sample dataset, I’m adding fiscal week from a date column “TX_DT”. The fiscal year runs from Feb through Jan in a given year, for example, if we consider FY2022 (Feb’22 – Jan’23), 2022-02-01 will be fiscal week 1 and 2023-01-31 will be fiscal week 52. I’m using the code below to add fiscal week, however, the dates ranging between 2023-02-01 and 2023-02-05 are assigned 0 for their fiscal week. Dates post 2023-02-05 are assigned fiscal week 1 and so on….How can I make sure that my fiscal week starts from 2023-02-01. Also, this code starts the fiscal week from Saturday through Sunday. What changes can be made in the code if the fiscal week were to run from Monday through Sunday?

data temp_summ;

set temp;

Sales_Yearmon = year(TX_DT)*100 + month(TX_DT);

week_normal = week(TX_DT);

dat2 = intnx('month12.2',TX_DT,0);

week_F = intck('week',dat2,TX_DT);

format dat2 date9.;

run;

Please note that the date column “TX_DT” is of numeric data type of ‘YYMMDD10.’ Format and ‘YYMMDD10.’ Informat.

Re: Flexible fiscal week from date column

ballardw — Tue, 14 Nov 2023 20:35:45 GMT

Look at the V descriptor option for the WEEK function.

topic Flexible fiscal week from date column in SAS Programming

Flexible fiscal week from date column

Re: Flexible fiscal week from date column