Calculate month and quarter based on year and week

[Lina_K]

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!

[Tom · Accepted solution]

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

[Lina_K]

Thank you Tom! It works perfectly.