decryption using the PBEWITHSHA256AND256BITAES-CBC-BC algorithm

[Robert]

I received a dataset last week that has some variables that contain encrypted data values. I was provided with the password and algorithm information, but am not sure how to implement this in SAS.

The algorithm is: PBEWITHSHA256AND256BITAES-CBC-BC

The data was encrypted using 1000 key iterations

I know how to encrypt data using the SHA256 function, but I don’t know how to decrypt data using the algorithm above. Can you please provide a solution to this problem.

[HB · Accepted solution]

Here is a page that has a Python decryption function that may outline the pieces needed:

https://gist.github.com/bertramn/d22e88eba2ce432be016ab5d61595ab4

My instinct may be wrong, but I think I might look at decrypting the data before reading it into SAS.