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.
Hi,
In my knowledge dynamic serial no. is not possible.
Regards,
Teja Surapaneni.
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.
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
Hi,
In my knowledge dynamic serial no. is not possible.
Regards,
Teja Surapaneni.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.