07-05-2017 04:30 AM
Simple answer: don't.
Sending files per email may fail because the target mail server does not accept mails sizes > X, where X is arbitrary.
How would you want to "protect" a simple text file anyway?
Also how do you convey the password, if you manage the above?
Place the csv in a place where it can be retrieved via SSH. This scales well and satisfies all security needs. And you only have to send a notification per mail.
07-05-2017 04:32 AM
To protect a CSV file, I would just look into a generic tool. Maybe you can zip it and protect the zip. Then you can send any kind of file, protected or not.
To protect an Excel file: http://support.sas.com/kb/31/328.html
For sending emails: http://www2.sas.com/proceedings/forum2008/038-2008.pdf
07-05-2017 04:42 AM
You can send email, but SAS does not support sending encrypted emails. A google search for "sas secure encrypted emails" reveals that this has been dealt with here (SAS communities) already.
SAS/SECURE handles encrypted storage and encryption on SAS connections (CONNECT and SHARE).
07-05-2017 04:37 AM
There is no such thing as pasword protected CSV files. CSV=Comma Separated Variable text files - note it is NOT Excel! You can use third party tools like ZIP to add a layer of security, however if it is critical data then you really should consider Secure FTP or Secure Portals, not just for security but for traceability.
07-05-2017 04:42 AM
@japsas100, you would need SAS/SECURE only to be able to understand certificates and encryption (meaning, reading or writing), but sending a file (encrypted or not, it will be just a binary or text file) does not require security management. Security management is only required to read secured files or to create secured files, that is it.
07-05-2017 05:07 AM
How we can create csv file as password protected on unix. Please share any example.
@RW9 already provided the answer to that. zip is a utility present on UNIX systems, a manual page for it can be found by googling "zip manual page", eg http://www.linuxguide.it/command_line/linux-manpage/do.php?file=zip
07-05-2017 04:26 PM
Please be aware that password-protected zip files are not particularly secure. There are tools easily available on the internet for "cracking" zip files. There is no way my company would let us exchange data this way.
07-05-2017 05:10 AM
I don't think it is a good idea if we give you examples of something it is not related to SAS, I would rather ask the expert on those areas.
We already covered some blunt ideas, such as create a password-protected zip file containing the csv file (which seems to be a good idea, to reduce space), and I can think now that probably openssl can be a good idea as well.
Please google a bit or ask in the relevant spaces. That is the best advise I can give you at this moment.