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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.