Looking to export encrypted excel attachment via email from unix

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 95
Accepted Solution

Looking to export encrypted excel attachment via email from unix

hi all,

 

Looking to export encrypted excel attachment via email from unix sas (in other words, while I am not logged into my windows environment).

 

I'm currently able to automote daily jobs using cron tab and just found out how to email my excel output to email.

 

Has anyone experienced adding encryption to the excel files?

 

I found this tutorial: http://support.sas.com/kb/31/328.html

 

But not sure if this can work from Unix. I appreciate any tips you may have to offer


Accepted Solutions
Solution
‎05-25-2017 07:57 AM
Occasional Contributor
Posts: 6

Re: Looking to export encrypted excel attachment via email from unix

Hi @brulard,

You can use system commands such as gzip to zip your excel sheet and add a password to it. All of this can be done from within your sas program by using call system or x command. Later you can send this as an attachment to your email using the filename email option in SAS.

View solution in original post


All Replies
Solution
‎05-25-2017 07:57 AM
Occasional Contributor
Posts: 6

Re: Looking to export encrypted excel attachment via email from unix

Hi @brulard,

You can use system commands such as gzip to zip your excel sheet and add a password to it. All of this can be done from within your sas program by using call system or x command. Later you can send this as an attachment to your email using the filename email option in SAS.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation