topic Re: Send password protected csv files via email from sas 9.2 in Administration and Deployment

Send password protected csv files via email from sas 9.2

japsas100 — Wed, 05 Jul 2017 08:22:45 GMT

How to send password protected csv files via email from sas 9.2?

We don't have sas secure license for 9.2 version.

Re: Send password protected csv files via email from sas 9.2

Kurt_Bremser — Wed, 05 Jul 2017 08:30:46 GMT

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.

Re: Send password protected csv files via email from sas 9.2

JuanS_OCS — Wed, 05 Jul 2017 08:32:13 GMT

Hello @japsas100,

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

Re: Send password protected csv files via email from sas 9.2

japsas100 — Wed, 05 Jul 2017 08:35:30 GMT

Thanks Juan_OCS

Can we send an email if we don't have SAS secure license in 9.2 version?

I think SAS Secure module is free in 9.4 version.

Re: Send password protected csv files via email from sas 9.2

RW9 — Wed, 05 Jul 2017 08:37:09 GMT

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.

Re: Send password protected csv files via email from sas 9.2

JuanS_OCS — Wed, 05 Jul 2017 08:42:18 GMT

@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.

Re: Send password protected csv files via email from sas 9.2

Kurt_Bremser — Wed, 05 Jul 2017 08:42:32 GMT

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).

Re: Send password protected csv files via email from sas 9.2

japsas100 — Wed, 05 Jul 2017 08:51:07 GMT

Thanks ,

I want to create a file with password protected on unix env and then send email via sas 9.2.

Re: Send password protected csv files via email from sas 9.2

JuanS_OCS — Wed, 05 Jul 2017 08:51:58 GMT

I guessed that much. If you don't encrypt the email, just the file, you should be good to go.

Re: Send password protected csv files via email from sas 9.2

japsas100 — Wed, 05 Jul 2017 09:00:52 GMT

Thanks,

How we can create csv file as password protected on unix. Please share any example.

Re: Send password protected csv files via email from sas 9.2

Kurt_Bremser — Wed, 05 Jul 2017 09:07:54 GMT

@japsas100 wrote:

Thanks,

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

Re: Send password protected csv files via email from sas 9.2

JuanS_OCS — Wed, 05 Jul 2017 09:10:22 GMT

Hello @japsas100,

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.

Re: Send password protected csv files via email from sas 9.2

SASKiwi — Wed, 05 Jul 2017 20:26:12 GMT

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.