topic Re: Sequence number in sas va in SAS Visual Analytics

Sequence number in sas va

Carrot17 — Tue, 07 Jul 2015 16:50:37 GMT

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

Thank you.

Re: Sequence number in sas va

TejaSurapaneni — Wed, 08 Jul 2015 05:21:30 GMT

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.

Re: Sequence number in sas va

Carrot17 — Wed, 08 Jul 2015 06:42:20 GMT

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

Re: Sequence number in sas va

TejaSurapaneni — Wed, 08 Jul 2015 13:26:43 GMT

Hi,

In my knowledge dynamic serial no. is not possible.

Regards,

Teja Surapaneni.

Re: Sequence number in sas va

Explore_SAS — Fri, 17 Jul 2015 14:12:41 GMT

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.