topic Re: Is there a SAS function which returns the month based on the week identifier? in New SAS User

Is there a SAS function which returns the month based on the week identifier?

PierreYvesILY — Fri, 02 Jul 2021 08:16:56 GMT

Is there a SAS function which returns the month based on the week identifier?

Ex.: Week 26 => 06

or Week 26 => JUNE

LinusH — Fri, 02 Jul 2021 08:25:47 GMT

Not that I know of.

Since a week can be split between two months, you need to figure how you want to map this.

So I think that you need to go via a date first.

Patrick — Fri, 02 Jul 2021 08:31:34 GMT

I believe what you're asking for is not possible without also knowing the year AND the logic used to determine the first day of week 1.

Without a year what month should week 1 get - and what month week 52 or 53?

FreelanceReinh — Fri, 02 Jul 2021 09:41:00 GMT

You could pick one of the WEEK... informats and use the MONTH, INPUT, CATS and PUT functions to compute the month from week number and year.

Example:

data test;
do week=26 to 27;
  do year=2019 to 2021;
    mon=month(input(cats(year,'W',put(week,z2.)),weekv.));
    output;
  end;
end;
run;

Result:

week    year    mon

 26     2019     6
 26     2020     6
 26     2021     6
 27     2019     7
 27     2020     6
 27     2021     7

In this example the month is (by default) calculated for the Monday of the respective week.

PierreYvesILY — Fri, 02 Jul 2021 11:02:59 GMT

hey Reinhard,

thanks a lot for this very good solution, which is exactly what I was looking for!

I just modified my program with it and tested it, it's just perfect.

Have a nice WE

Regards,