topic Re: Calculate month and quarter based on year and week in New SAS User

Calculate month and quarter based on year and week

Lina_K — Mon, 28 Sep 2020 13:46:18 GMT

I have a column with year (2018-2019) and a column with week number (01-52). Do you know how to create two columns with information on month and quarter based on information about year and week?

Example data:

ID	YEAR	WEEK	MONTH	QUARTER
1	2018	1	1(Jan)	1st
1	2018	2	1(Jan)	1st
1	2018	51	12(Dec)	4th

Thanks in advance!

Re: Calculate month and quarter based on year and week

Tom — Mon, 28 Sep 2020 13:55:52 GMT

Try using INTNX() to calculate date. Then you can use MONTH() and QTR() functions.

data have;
  input ID YEAR WEEK wantMONTH $ wantQUARTER $;
  date = intnx('week',mdy(1,1,year),week-1,'s');
  month=month(date);
  quarter=qtr(date);
  format date yymmdd10.;
cards;
1 2018 1 1(Jan) 1st
1 2018 2 1(Jan) 1st
1 2018 51 12(Dec) 4th
;

                              want       want
Obs    ID    YEAR    WEEK     MONTH     QUARTER          date    month    quarter

 1      1    2018      1     1(Jan)       1st      2018-01-01       1        1
 2      1    2018      2     1(Jan)       1st      2018-01-08       1        1
 3      1    2018     51     12(Dec)      4th      2018-12-17      12        4

Re: Calculate month and quarter based on year and week

Lina_K — Mon, 28 Sep 2020 14:12:31 GMT

Thank you Tom! It works perfectly.