@SASKiwi - Yes. After multiple tries, after many failures, I've finally made it. I also had some problems with connection string so I changed to dsn. Thank you very much for your suggestion. Here is my code: proc sql; connect to odbc(dsn=<Data source name>); execute (open master key decryption by password = '<Master key encryption password>') by odbc; create table table2 as select * from connection to odbc (select convert(nvarchar, decryptbykeyautocert(cert_id('<Certificate name>'), null, <encrypted column>)) from table1); disconnect from odbc; quit; @shivxy- I used DecryptByKeyAutoCert that combines the functionality of OPEN SYMMETRIC KEY and DecryptByKey so I don't need to separately open and close symmetric key.
... View more