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.
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;
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
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;
solve my problem!!!! thank you very much!!!!!!!
NWKDOM() may be easier to work with.
Returns the date for the nth occurrence of a weekday for the specified month and year.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.