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

[podarum]

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

[art297 · Accepted solution]

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