DATA Step, Macro, Functions and more

decryption using the PBEWITHSHA256AND256BITAES-CBC-BC algorithm

Reply
Occasional Contributor
Posts: 9

decryption using the PBEWITHSHA256AND256BITAES-CBC-BC algorithm

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.

Super Contributor
Super Contributor
Posts: 266

Re: decryption using the PBEWITHSHA256AND256BITAES-CBC-BC algorithm

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.

Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation