topic Re: Find Week within a Month in SAS Enterprise Guide

Find Week within a Month

sdang — Thu, 18 Feb 2016 23:31:52 GMT

Hi all,

In Query Builder I have PlayDayDate in this format: 15FEB2016:00:00:00. I want to create a new calculated column to find out the week within the month of February that PlayDayDate is in. The output value should be 3 as '15Feb2016' lands in week 3 of February, not 7 like SAS has given.

Thanks

Re: Find Week within a Month

mohamed_zaki — Fri, 19 Feb 2016 00:01:30 GMT

What the expression you used?

  week=intck('week',intnx('month',date,0),date)+1;

Sample 41732: Determine the week number of a month

Re: Find Week within a Month

sdang — Fri, 19 Feb 2016 00:07:43 GMT

Thank you!. It worked!

Re: Find Week within a Month

sdang — Fri, 19 Feb 2016 21:29:03 GMT

Hi,

Thank again. I use the expression you've given me:

week=intck('week',intnx('month',date,0),date)+1;