HOW TO ASSIGN A WEEK RANGE TO A DATE

[arjinram]

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

    Date            week_range

08MAR2016   06MAR - 12MAR

Thans in advance.

Arjin

[LinusH]

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).

[Ksharp · Accepted solution]

data _null_;
 x='08MAR2016'd;
 start=intnx('week',x,0,'b');
 end=intnx('week',x,0,'e');
 
 put (x start end) (= date9.);
run;