how to get 3 variables (week no, week start date ,week end date ) from date varaible

[sathya66]

Hi All,

I have a date variable from that I need to make 3 variables. like below. 

Date

26/03/2017

27/03/2017

28/03/2017

29/03/2017

30/03/2017

31/03/2017

01/04/2017

02/04/2017

03/04/2017

04/04/2017

05/04/2017

06/04/2017

07/04/2017

08/04/2017

09/04/2017

10/04/2017

11/04/2017

12/04/2017

13/04/2017

14/04/2017

15/04/2017

Week	Week Start	Week End
1	26/03/2017	01/04/2017
2	02/04/2017	08/04/2017

Thanks,

SS.

[Kurt_Bremser · Accepted solution]

Use the intnx function:

data test;
curr_date = input('26/03/2017',ddmmyy10.);
week_start = intnx('week',curr_date,0,'b');
week_end = intnx('week',curr_date,0,'e');
format curr_date week_start week_end ddmmyy10.;
run;