BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
brulard
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
Aboveland
Fluorite | Level 6
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

1 REPLY 1
Aboveland
Fluorite | Level 6
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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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