Is it possible to export or ftp sas dataset into csv, xml or excel and schedule to run the export job ?
Thanks
SAS has a procedure for doing exactly that.
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000316288.htm
You can also send the resulting file via ftp using the filename statement:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000178980.htm
As far as scheduling is confirmed you can install a crontab task to execute the job as a SAS batch process if you wanted.
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.
I will be running this under unix. What option do i have with unix ?
Minimally, you have SAS Scheduler and Crontab
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.