Hi All,
Not sure if I am putting this in right group, please route me to right group if it is not the correct one.
We want to set up a mechanism to load PGP encrypted data set in SAS Office Analytics servers. Does SAS provides a capability to decrypt the files.
Regards,
Nishant
Are you aware that SAS has its own encryption capabilities for datasets? It would be a lot easier than trying to use third-party encryption and you can even go as far as restricting access to SAS data libraries:
http://support.sas.com/documentation/cdl/en/seclibag/66930/HTML/default/viewer.htm#bookinfo.htm
Regarding PGP - I don't think SAS can decrypt these directly. However I understand you can configure WINZIP to use PGP so you could use WINZIP tools to indirectly decrypt. If you are working on Unix then no doubt there would be third-party tools to help you here as well.
Please correct me if I am wrong, the current blog says how to encrypt the SAS dataset but I am looking for a functionality where SAS procs can be use to import pgp/aes encrypted external file (delimited file either CSV or text file) in SAS.
From my experience with such tools I guess that a pgp commandline tool can be used as a filter (eg pgp -parameters < encrypted_csv_file will send the decrypted file to standard output).
In such a case, it is best (IMHO) to define a filename pipe where the decryption process is coded into the physical filename (see above). When you use such a filename in an infile statement, the decryption is done on the fly and the decrypted data is handed over to SAS as if you directly read a plain, unencrypted file.
You need to have XCMD enabled for this to work.
Hi Kurt,
Thanks for the response.
Does this means that encrypted file can be placed on SAS server(Unix box), PGP command line Tool will decrypt the file and the file can be used by SAS,. Is my iunderstanding is correct?
If that is correct then we are not using SAS at all, it is purely based on PGP commandline tool.
REgards,
Nishant
@NAwasthi wrote:
Hi Kurt,
Thanks for the response.
Does this means that encrypted file can be placed on SAS server(Unix box), PGP command line Tool will decrypt the file and the file can be used by SAS,. Is my iunderstanding is correct?
If that is correct then we are not using SAS at all, it is purely based on PGP commandline tool.
REgards,
Nishant
Well, since SAS does not have a built-in tool for PGP decryption, you need to use an external one. But you can start/control that decryption process from within SAS, either by running the CLI tool with call system or the x statement, or by directly using it as a filter in a filename pipe.
Downloads of PGP commandline tool for UNIX can be found here: http://www.pgpi.org/products/pgp/versions/freeware/unix/6.5.8/
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.