topic Re: Week Format in SAS Programming

Week Format

hwangnyc — Wed, 13 Mar 2019 15:44:26 GMT

Hi everyone,

I'm using the WEEK function and I get a column that has 0-53.

Is there a format that I can apply to have it read:

1 = 1/7/19 - 1/13/19

2 = 1/14/19 - 1/20/19

Thanks in advance!

Henry

JosvanderVelden — Wed, 13 Mar 2019 16:41:33 GMT

ballardw — Wed, 13 Mar 2019 17:57:16 GMT

The week function for a specific year can be adjusted to do this using the V modifier which starts a week on Monday.

However the function also considers the week 1 as the week that includes both January 4 and the first Thursday.

For 2019 this does what you request but is not a generic solution because you have not specified what your rule might be for other years:

data example;
   do date='01JAN2019'd to '31DEC2019'd;
      week = week(date,'V') -1;
      output;
   end;
   format date date9.;
run;