08-17-2011 05:43 PM
SAS has a procedure for doing exactly that.
You can also send the resulting file via ftp using the filename statement:
As far as scheduling is confirmed you can install a crontab task to execute the job as a SAS batch process if you wanted.
08-17-2011 08:41 PM
Other scheduling options include the Windows Scheduler if you are running under Windows, numerous third-party schedulers, or in SAS itself via the EG schedule project facility or the DATA step SLEEP function.