Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Filter by Current Weekending Date?

Reply
Occasional Contributor
Posts: 10

Filter by Current Weekending Date?

I have built some graphs and my current date ranges are Week Ending, Month, and Year.

 

I need to be able to filter on the Current Week Ending  Date and Month.

 

How do I build that in an advanced filter?  Thank for any help!

SAS Super FREQ
Posts: 296

Re: Filter by Current Weekending Date?

Do you already have the week ending date values, or do you need to calculate them?

You probably want to do this as part of your data query by using the INTNX() function. See this thread:
https://communities.sas.com/t5/Base-SAS-Programming/Identifying-Weekend-date-from-a-given-date/td-p/...

Once you have the week ending date values in a column, filtering on that should be fairly straightforward unless there is some issue I am missing.

Thanks,
Sam
Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 0 likes
  • 2 in conversation