My dataset has over 500,000 rows of data.
One category field in my data is called cat1, the Model Type is discrete, and the Format is $4.
There are 117 levels (distinct values) for cat1.
Another category field in my data is report_time, the Model Type is Continous, and the Format is Date, Time. There is no duplication in cat1*report_time.
I need to create a filter in SAS VA 7.3 Data Exploration so that I am only pulling data from the record associated with the last submitted date/time.
Then I will create a bar chart of a numeric measure with aggregation of sum.
My goal is to have the bar chart add one value per level of cat1, and that one value will have a variety of report_time. There is no reference time and I can not use a time period for the pull. It must simply be the most recent record for each distinct level of cat1.
The last report_time could be different for each level of cat1 so I can not use the regular boolean operators.
I see two possible solutions - both of these are untested.
Hope this gives you an exploration trail.
Using the TreatAs function you can convert a Date value into a numeric value. Then you could get it's MAX value.
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.
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.