We have an ETL-job that creates a csv-file and attaches it to an outgoing email.
Ah yes, the good old WinZip and password protect data transfer. What a totally unsecure faff that really is. If you need to send data, then use a proper process for that. Your company (or recipient) will likely have a secure transfer area - ask IT - or alternatively use SFTP to transfer the file. This has several main benefits - firstly email is limited in the size it can carry for me it is 10mb maximum, hence sending data whiich can be gb is not a valid option and you email server admin may come round for a word. Secondly, security is embedded into the system which results in you not having to worry about implementing it, and is more secure that your process. So often have I seen the email with the data followed by the email with the password - I mean surely the person who intercepts the first can't intercept the second email?
So save yourself the bother and transfere files securely and consitently using methods appropriate.
And for extra comic relief to add to @RW9's response: I used to receive data in the method you describe. And then an upgrade to email security software included a check for "objectionable words" in the file. It took a week to find out why the file I received every three days didn't arrive. It turned out we had a street name that contained one of the "objectionable" words and the security software was trashing the file and not notifying the intended receipient about quarantined mail.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.