topic Re: Read aes/pgp encrypted external file in SAS Procedures

Read aes/pgp encrypted external file

manishh — Tue, 14 Jul 2015 14:31:51 GMT

I am using SAS 9.3/Linux...can someone help me with the SAS procs which can be use to import pgp/aes encrypted external file (delimited file either CSV or text file) in SAS?

Or it can be achievable using infile pipe statement with SAS options to decrypt while reading the file?

Thanks!!!

Re: Read aes/pgp encrypted external file

FriedEgg — Tue, 14 Jul 2015 15:11:38 GMT

Yes, it is possible to do this using an infile pipe, but there are certain caveats to this. Using a tool, such as GPG-AGENT can be helpful in avoiding the items that sometimes require human interaction.

Re: Read aes/pgp encrypted external file

manishh — Tue, 14 Jul 2015 17:21:45 GMT

Thanks for response, is it supported by SAS procs?

Using gpg-agent, first ext file should be decrypt on o/s level then can be import. Isn't it?

Re: Read aes/pgp encrypted external file

FriedEgg — Tue, 14 Jul 2015 18:15:02 GMT

Files encrypted in this manner are not directly supported by any procedure.

Re: Read aes/pgp encrypted external file

NAwasthi — Fri, 01 Apr 2016 07:04:23 GMT

Hi Manish,

Have you received a possible way for doing this. I am also discovering that how to load a PGP encrypted csv file into sas.

Any pointer would be helpful.

Regards,

Nishant