Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Sequence number in sas va

Accepted Solution Solved
Reply
Contributor
Posts: 54
Accepted Solution

Sequence number in sas va

Hi experts,

Anyone knows if we can create a sequence number in sas va report designer? For example i have 5 records then the S/N column in the list will be

S/N

1

2

3

4

5

Thank you.


Accepted Solutions
Solution
‎07-08-2015 09:26 AM
Regular Contributor
Posts: 196

Re: Sequence number in sas va

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

View solution in original post


All Replies
Regular Contributor
Posts: 196

Re: Sequence number in sas va

Hello Carrot,

There is no direct option for serial no/sequence no. in SAS VA,

If you want you can calculate using IF Else Statement.

Untitled.png

Ex:-

IF ( 'Record'n In ('X') )          

RETURN 1

ELSE (

  IF ( 'Record'n In ('Y') )

  RETURN 2

  ELSE (

    IF ( 'Record'n In ('Z') )

    RETURN 3

    ELSE (

      IF ( 'Record'n In ('D') )

      RETURN 4

      ELSE (

        IF ( 'Record'n In ('S') )

        RETURN 5

        ELSE ( .)

Thanks & Regards,

Teja Surapaneni.

Contributor
Posts: 54

Re: Sequence number in sas va

Hi Venkata,

I see. Thank you for your response. Our data is not only 5. It is thousands of data and user wants to have a dynamic S/N column that based on the number of records/data. Anyways. Thanks again.

Best Regards

Solution
‎07-08-2015 09:26 AM
Regular Contributor
Posts: 196

Re: Sequence number in sas va

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

Contributor
Posts: 69

Re: Sequence number in sas va

Hi carrot,

If you can let us know, what you are trying to achieve by adding a new column, we might be able to suggest different work around for it.

if possible you can add this SN column in your data source before you load it into the VA.

Post a Question
Discussion Stats
  • 4 replies
  • 366 views
  • 1 like
  • 3 in conversation