Export SAS data into FTP using SAS Data

sureshprabhu153 — Mon, 11 Feb 2019 04:15:52 GMT

I want to export SAS dataset from SAS into FTP. I can exporting csv file (or txt file) with the help of the following command.

%macro export_to_ftp(dsn= ,outfile_name= );

Filename MyFTP ftp "&outfile_name." 
HOST='ftp.site.com'
                 cd= "&DATA_STRM/QC" 
                  USER=&ftp_user.
                  PASS=&ftp_pass.;

PROC EXPORT DATA= &dsn. OUTFILE= MyFTP DBMS=%SCAN(&outfile_name.,2,.) REPLACE; 
RUN; filename MyFTP clear;
%mend;

%export_to_ftp(dsn=lib1.dataset ,outfile_name=dataset.csv);

Am unable to make sure the SAS Data set exportation

Please help me to solve my issue,

Thank you,

Re: Export SAS data into FTP using SAS Data

andreas_lds — Mon, 11 Feb 2019 06:14:16 GMT

Please explain what "Am unable to make sure the SAS Data set exportation" means.

topic Re: Export SAS data into FTP using SAS Data in SAS Programming

Export SAS data into FTP using SAS Data

Re: Export SAS data into FTP using SAS Data