topic Re: sas va row number in SAS Visual Analytics

sas va row number

rajsukh — Thu, 14 Jul 2016 16:24:51 GMT

Hi,

Is there a way to add row numbers to a list table?

In base/enterprise guide can use _N_, but could not find an easy solution in SAS VA.

thks,

Sukhbir

Re: sas va row number

rajsukh — Thu, 28 Jul 2016 15:48:30 GMT

Does anyone have a recommendation on how this can be achieved?

Thanks in advance

Re: sas va row number

Joy_SAS — Thu, 28 Jul 2016 16:33:28 GMT

Hi rajsukh,

SAS Visual Analytics Designer doesn't currently have an option the lets you display row numbers for list tables.

-Joy

Re: sas va row number

LinusH — Thu, 28 Jul 2016 18:46:06 GMT

You could create a variable during data prep using the techniques you mention.
But I can't really see when seeing a row no is relevant during analysis?

Re: sas va row number

rajsukh — Thu, 28 Jul 2016 22:34:04 GMT

Hi Joy,

Thanks for response, this is shame. It is useful in a list table when looking at top 50 or 100 of data, say by revenue figure. This is when it is useful Linush in Sas VA. Can't by done in data prep is my understanding if you apply filters to list table such as area.

Hope it makes sense.

Re: sas va row number

rajsukh — Thu, 28 Jul 2016 22:35:04 GMT

Is there any plan to bring row count as function in next release.. ?

Re: sas va row number

Joy_SAS — Fri, 29 Jul 2016 14:03:48 GMT

Hi rajsukh,

SAS Visual Analytics Designer might have another feature that you can use with your revenue figures.

You can rank values to subset your data. For example, using the Rank tab, you could create a rank to display the top 10 stores for revenue. When you apply a rank, you can specify top count, bottom count, top percent, or bottom percent. You can apply a rank to your data item, and then use that data item in a list table.

Here's the related information in the SAS Visual Analytics 7.3 User's Guide: Ranking Values in Reports. (There's similar information for previous releases here: http://support.sas.com/documentation/onlinedoc/va/index.html.)

-Joy

Re: sas va row number

rajsukh — Fri, 29 Jul 2016 14:08:26 GMT

Yes I am aware of this and works well to show top 10/20 etc. However I have list where stakeholder wants to see top 50 or 100 so a row number would be useful when you look down this list. It's a really simple cosmetic thing to have so bit surprised SAS VA does not have a solution for it. It's almost like building in a count function or _n_ to label rows and can be dynamic. Thanks again.

Re: sas va row number

Joy_SAS — Fri, 29 Jul 2016 14:17:11 GMT

Thanks for the additional explanation. I understand why you want the row numbers in the list table. I'm sorry the list table doesn't have a property like this in the current release.

-Joy

Re: sas va row number

romeomai — Fri, 17 Feb 2017 22:15:07 GMT

I able to use _N_ in data prepration after unlock manual editing to index rows in my table. At the last table in the code, add the line anyColumnName = _N_;

Re: sas va row number

rajsukh — Tue, 21 Feb 2017 17:23:42 GMT

Ah ok, we will try this if the need comes up again to add row numbers

Re: sas va row number

gabras — Sun, 05 Aug 2018 15:19:53 GMT

Hi @Joy_SAS

i need to create a sequence variable based on CUSTOMER_ID, so i have to enumerate the interactions a Cust_ID had with the company.

Is it possible with VA?

Thanks

Re: sas va row number

Joy_SAS — Wed, 08 Aug 2018 17:27:39 GMT

Hi @gabras,

I'm sorry, but I don't know the answer to your question about sequence variables. I hope another VA expert can provide some guidance.

-Joy