topic Re: Linenumber or rank by group in SAS Visual Analytics

Linenumber or rank by group

acordes — Tue, 12 Nov 2019 14:33:44 GMT

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.

Re: Linenumber or rank by group

acordes — Wed, 13 Nov 2019 17:35:57 GMT

@Sam_SAS any idea? Thanks a lot in advance

Re: Linenumber or rank by group

Sam_SAS — Wed, 13 Nov 2019 17:56:30 GMT

Hello,

I'm not sure I understand what you want to do. Your workaround with the cumulative total seems to provide a line number, but did you want this number to start over at one for each value of the TMA category?

Sam

Re: Linenumber or rank by group

acordes — Wed, 13 Nov 2019 18:03:11 GMT

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.

Re: Linenumber or rank by group

Sam_SAS — Wed, 13 Nov 2019 18:11:10 GMT

Thanks for the clarification, I understand the goal now.

I am not sure of how to do this in VA, unfortunately. Someone else might know a way.

Sam