Sequence number in sas va

[Carrot17]

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.

[TejaSurapaneni]

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.

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.

[Carrot17]

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

[TejaSurapaneni · Accepted solution]

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

[Explore_SAS]

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.