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.
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.
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.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.