SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Determine the week number of a month

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

Determine the week number of a month

Hi guys 

I have a variable called "_datadate" that include all Friday from May 2015 to May 2017, I want to output all Friday which is 3rd Friday in the month, I use this code " 

DATA AAPL_TEsT1;
set AAPL_test;
week =intck('_datadate',intnx('month',date,0),date)+1;
run; "

But it not work.

 

I need some suggestions for this issue.

Thank you.


Accepted Solutions
Solution
‎10-27-2017 01:11 PM
Super User
Posts: 5,717

Re: Determine the week number of a month

Here's a different way to calculate WEEK:

 

week = ceil(day(_datadate)/7);

 

If you know that your data set contains only Fridays, you could easily follow that with:

 

if week = 3;

 

If your data set might contain some non-Fridays, you would have to add a condition:

 

if week = 3 and weekday(_datadate)=6;

View solution in original post


All Replies
PROC Star
Posts: 362

Re: Determine the week number of a month

 

you need to calculate for weekday

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201173.htm

if week = 3 and weekday = 6

will give your 3rd Friday of everymonth

Solution
‎10-27-2017 01:11 PM
Super User
Posts: 5,717

Re: Determine the week number of a month

Here's a different way to calculate WEEK:

 

week = ceil(day(_datadate)/7);

 

If you know that your data set contains only Fridays, you could easily follow that with:

 

if week = 3;

 

If your data set might contain some non-Fridays, you would have to add a condition:

 

if week = 3 and weekday(_datadate)=6;

Contributor
Posts: 29

Re: Determine the week number of a month

Posted in reply to Astounding

solve my problem!!!! thank you very much!!!!!!!

Super User
Posts: 20,730

Re: Determine the week number of a month

NWKDOM() may be easier to work with.

 

Returns the date for the nth occurrence of a weekday for the specified month and year.

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 142 views
  • 2 likes
  • 4 in conversation