BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Carrot17
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
TejaSurapaneni
Lapis Lazuli | Level 10

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

View solution in original post

4 REPLIES 4
TejaSurapaneni
Lapis Lazuli | Level 10

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.

Carrot17
Quartz | Level 8

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
Lapis Lazuli | Level 10

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

Explore_SAS
Obsidian | Level 7

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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1507 views
  • 1 like
  • 3 in conversation