topic Re: HOW TO ASSIGN A WEEK RANGE TO A DATE in SAS Programming

HOW TO ASSIGN A WEEK RANGE TO A DATE

arjinram — Tue, 08 Mar 2016 08:42:00 GMT

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

Date week_range

08MAR2016 06MAR - 12MAR

Thans in advance.

Arjin

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

LinusH — Tue, 08 Mar 2016 09:07:40 GMT

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

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

Ksharp — Tue, 08 Mar 2016 09:53:07 GMT

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