SAS Export Data

newbi · Posted 08-17-2011 05:24 PM

Is it possible to export or ftp sas dataset into csv, xml or excel and schedule to run the export job ?

Thanks

FriedEgg · Posted 08-17-2011 05:43 PM

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.

SASKiwi · Posted 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.

newbi · Posted 08-17-2011 10:27 PM

I will be running this under unix. What option do i have with unix ?

art297 · Posted 08-17-2011 11:05 PM

Minimally, you have SAS Scheduler and Crontab

SAS Export Data

SAS Export Data

SAS Export Data

SAS Export Data

SAS Export Data

Registration is open

Call for Content EXTENDED

SAS Export Data

SAS Export Data

SAS Export Data

SAS Export Data

SAS Export Data

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away