How to create a random sequence ID for each row?

This is a real work question. Usually, your clients send you some input files with a unique key. You need to append some variables and return the files to your clients.

However, to protect privacy and prevent reverse engineering, you must remove the unique key from clients and create a new unique key for each record. Also, you need reorder and randomize the sequences of output file records, then return them to clients. In this case, clients cannot match the output records to those in the input files.

How can you do it in SAS/R/Python respectively? Please develop, test your code and place it here.

• This discussion was modified 4 years, 1 month ago by  Datura.
• This discussion was modified 4 years, 1 month ago by  Datura.