topic Re: Encyption or depcription of a column from excel. How to write the code in SAS in New SAS User

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

Bala3 — Mon, 09 Dec 2019 20:52:27 GMT

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.

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

SASKiwi — Mon, 09 Dec 2019 22:27:52 GMT

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.

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

Bala3 — Tue, 10 Dec 2019 00:37:52 GMT

The enryption is made to the column for security reasons.

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

Reeza — Tue, 10 Dec 2019 00:57:18 GMT

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.

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

SASKiwi — Tue, 10 Dec 2019 05:39:22 GMT

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.