Week Format

[hwangnyc]

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]

Have a look at this post: https://communities.sas.com/t5/SAS-Procedures/How-to-get-the-first-day-of-a-week/td-p/131859

[ballardw]

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;