07-08-2015 01:21 AM
There is no direct option for serial no/sequence no. in SAS VA,
If you want you can calculate using IF Else Statement.
IF ( 'Record'n In ('X') )
IF ( 'Record'n In ('Y') )
IF ( 'Record'n In ('Z') )
IF ( 'Record'n In ('D') )
IF ( 'Record'n In ('S') )
ELSE ( .)
Thanks & Regards,
07-08-2015 02:42 AM
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.
07-17-2015 10:12 AM
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.