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.
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.