Hi:
I have an excel file and one of the columns is encrypted (eg:SSN). I want to decrypt the column and do some manipulations. What is the way I have to do in SAS.
Usually decryption isn't possible for the obvious reason that if it were easy / possible why bother encrypting in the first place. Go back to the supplier of the spreadsheet and ask them to re-supply it in non-encrypted form.
The enryption is made to the column for security reasons.
A better option would be to get the supplier to encrypt the whole spreadsheet file with a password key, send you this, then supply you the encryption key separately and securely. The open source tool PGP is good option for this.
Do you have the encryption algorithm or key? Or some instructions of any kind? Otherwise, trying to decrypt it is basically a hacking exercise.
@Bala3 wrote:
Hi:
I have an excel file and one of the columns is encrypted (eg:SSN). I want to decrypt the column and do some manipulations. What is the way I have to do in SAS.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.