topic Re: How to create row number in SAS VA 7.4 in SAS Visual Analytics

How to create row number in SAS VA 7.4

prashantgupta — Tue, 30 Jan 2018 07:55:53 GMT

Hi,

I have applied rank on top 25 items in a category in list table. These items will change based on the filter applied on the list table.

For these ranked items I want to assign a serial number to each row.

Could anyone please help me with this.

Any help will be appreciated.

Thank you!

Re: How to create row number in SAS VA 7.4

FredrikE — Tue, 30 Jan 2018 08:44:41 GMT

I'd say it's not possible :0

//Fredrik

Re: How to create row number in SAS VA 7.4

Madelyn_SAS — Tue, 30 Jan 2018 14:30:35 GMT

In release 8.2, you should be able to use the new AggregateCells operator to do this. For an example, see SAS Visual Analytics 8.2/Working with Report Data/Aggregated (Advanced) Operators/AggregateCells.

Re: How to create row number in SAS VA 7.4

prashantgupta — Tue, 30 Jan 2018 14:41:59 GMT

Hi Madelyn,

Since the upgrade is not available for 7.4 to 8.2. We are still using 7.4 release.
Is there any way to create row number done in 7.4 ?