topic Re: automated job in SAS Procedures

automated job

Tal — Tue, 22 Dec 2015 18:20:06 GMT

Hi ,

is it possible to create a batch in SAS that picks up a file from a particular UNIX location and emails it to myself for example?

I dont have certain dates when that file will be in UNIX

pls advise

Thanks

Re: automated job

Reeza — Tue, 22 Dec 2015 18:32:01 GMT

Yes, it's possible. You'll have to schedule the script to run and check if the file exists, if it exists then do A, otherwise stop. There are code samples on here if you search.

Re: automated job

SASKiwi — Tue, 22 Dec 2015 18:32:14 GMT

Yes. Assuming that SAS is running on the Unix server and that it is configured to work with an email server.

Why do you want to use email? What happens if the file is too large to send as an email attachment? Most email systems have restrictions on this.

Also there are schedulers that can check for the existence of a file and then run a batch job.

Re: automated job

Tal — Tue, 22 Dec 2015 20:09:43 GMT

thanks guys,

I usually pick up the file from our server manually and load it to another server which is not owned by us but now the guys asked me if i can pick it up and email it to them directly instead of loading it to their server.

Can you please point where on here i can get the samples of those scripts or even the scheduler that check for existence?

thanks,

Re: automated job

Reeza — Tue, 22 Dec 2015 20:12:42 GMT

Does it have to be a SAS script, there are a lot more Unix scripts out there I would imagine, and it's probably more efficient.

Re: automated job

Tal — Tue, 22 Dec 2015 20:40:40 GMT

i dont know how to write scripts in UNIX

Re: automated job

SASKiwi — Wed, 23 Dec 2015 02:51:40 GMT

Here is a link that has some code example for sending emails with attachments:

http://support.sas.com/documentation/cdl/en/hostunx/67929/HTML/default/viewer.htm#p1hl3t66coao7bn18vrmhx2gte1q.htm

You should talk to your SAS administrator to confirm your site's email settings if any.

Re: automated job

Tal — Wed, 23 Dec 2015 20:42:51 GMT

thanks SaSKiwi,

i did try one of the codes from the link you sent me and looks like my SAS is not set up to talk to SMTP yet.

Can you also point to some codes that check to see if a file exists in a particular server and then picks it up before sending it via email?

Re: automated job

Reeza — Wed, 23 Dec 2015 20:49:00 GMT

Use the Fexist or FileExist functions.

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000210912.htm

The example is pretty much what you want, except you want more stuff to happen in the IF/THEN sections. You may have to use different parts from different questions but the solutions are on here.