DATA Step, Macro, Functions and more

SAS Export Data

Reply
SAS Employee
Posts: 73

SAS Export Data

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

Thanks

Trusted Advisor
Posts: 1,301

SAS Export Data

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.

Super User
Posts: 3,252

SAS Export Data

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.

SAS Employee
Posts: 73

SAS Export Data

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

PROC Star
Posts: 7,469

SAS Export Data

Minimally, you have SAS Scheduler and Crontab

Ask a Question
Discussion stats
  • 4 replies
  • 306 views
  • 0 likes
  • 4 in conversation