The rank option in the right panel comes in handy.
But how can I use a rank-by construct?
In a data step I would i.e. apply the "first" function to reset the rank counter on the aggregated data like an output of proc freq.
But in VA I don't know how to solve it.
I was trying around with aggregated data source + aggregated cell, but I do not succeed in resetting every time a new outer group starts.
Thanks for replying to me call 🙂
Yes, indeed, I want to filter the object by those TMAIMGs that are the TOP3 most frequent BY their TMA group.
If I use the rank option with TOP3 and add the TOP3 by TMA, the result is not satisfactory.
Therefore I thought about creating a rank that starts over for every new TMA group. This value I could use in the filter i.e.
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.