topic Re: getting week number from middle of year to next middle of year in SAS Programming

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

podarum — Fri, 05 May 2017 01:35:22 GMT

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

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

art297 — Fri, 05 May 2017 03:47:17 GMT

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