HOW TO ASSIGN A WEEK RANGE TO A DATE

Solved
Occasional Contributor
Posts: 5

HOW TO ASSIGN A WEEK RANGE TO A DATE

Hi Need help to assign the week range to a date.

Date            week_range

08MAR2016   06MAR - 12MAR

Arjin

Accepted Solutions
Solution
‎04-13-2016 01:42 AM
Super User
Posts: 10,784

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

``````data _null_;
x='08MAR2016'd;
start=intnx('week',x,0,'b');
end=intnx('week',x,0,'e');

put (x start end) (= date9.);
run;``````

All Replies
Super User
Posts: 5,881

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

Re your week range always calendar weeks?

If so, the intnx() function will give you the week boundaries for the date in its argument.

So your option would be to calculate this on each data observation, or to create a look up table with these ranges (which later can use to create a format, or use for look up, joins for example).

Data never sleeps
Solution
‎04-13-2016 01:42 AM
Super User
Posts: 10,784

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

``````data _null_;
x='08MAR2016'd;
start=intnx('week',x,0,'b');
end=intnx('week',x,0,'e');

put (x start end) (= date9.);
run;``````
🔒 This topic is solved and locked.