DATA Step, Macro, Functions and more

HOW TO ASSIGN A WEEK RANGE TO A DATE

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

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

 

Thans in advance.

Arjin


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

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;

View solution in original post


All Replies
Super User
Posts: 5,256

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: 9,676

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 225 views
  • 1 like
  • 3 in conversation