BookmarkSubscribeRSS Feed
sureshprabhu153
Fluorite | Level 6

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,

1 REPLY 1
andreas_lds
Jade | Level 19
Please explain what "Am unable to make sure the SAS Data set exportation" means.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1248 views
  • 0 likes
  • 2 in conversation