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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.