Encyption or depcription of a column from excel. How to write the code in SAS

[Bala3]

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.

[SASKiwi]

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.

[Bala3]

The enryption is made to the column for security reasons.

[SASKiwi]

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.

[Reeza]

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.

---