DATA Step, Macro, Functions and more

getting week number from middle of year to next middle of year

Accepted Solution Solved
Reply
Super Contributor
Posts: 395
Accepted Solution

getting week number from middle of year to next middle of year

Hi, is there a creative way to get week number of a dataset that has a process date that starts from March2016 to March2017.. so the frist week of March2016 is 1 and so on until 52 of the last week of March2017.  Not necessarily March, any month of the year, and if I only have 6 months then would have week 1 to week 26...etc.   Thanks


Accepted Solutions
Solution
‎05-05-2017 06:29 AM
PROC Star
Posts: 7,360

Re: getting week number from middle of year to next middle of year

How about:

 

data have;
  format date date9.;
  do date='1mar2016'd to '01mar2017'd;
    output;
  end;
run;

data want;
  set have;
  week=intck("week",'01mar2016'd,date);
run;

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Solution
‎05-05-2017 06:29 AM
PROC Star
Posts: 7,360

Re: getting week number from middle of year to next middle of year

How about:

 

data have;
  format date date9.;
  do date='1mar2016'd to '01mar2017'd;
    output;
  end;
run;

data want;
  set have;
  week=intck("week",'01mar2016'd,date);
run;

Art, CEO, AnalystFinder.com

 

☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 115 views
  • 1 like
  • 2 in conversation