- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-13-2019 11:44 AM
(701 views)
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;