Hi
I would like to display 7 months data on a crosstab (Current month and 6 months prior).
Is there any suggestions i can use to achieve this?
Regards
You could use an advanced filter expression like this:
( TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n) ) <= 210
This selects the last 210 days of rows. I'm not sure if you can make a filter that selects on months intelligently that would span years.
Sam
You could use an advanced filter expression like this:
( TreatAs(_Number_, DatePart(Now())) - TreatAs(_Number_, 'Facility Opening Date'n) ) <= 210
This selects the last 210 days of rows. I'm not sure if you can make a filter that selects on months intelligently that would span years.
Sam
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.