Sample 36065: Using SAS® software to access multiple files on an FTP server
/* SAMPLE 2: Moving files from FTP server to local system using OS FTP */
%let ftpcmds=ftp.cmds;
%let host= ; /* specify machine to connect with ftp */
%let userid=; /* specify id to use with ftp command */
%let ftppwd=; /* specify pwd for the ftp userid */
%let xfermode=ascii; /* specify ascii or binary mode xfer */
%let homedir=/home/AP_batch/files/out/contract/renm; /* optional: specify directory on ftp server */
%let localdir=H:\SASDATA\02. BACK\ETC\TEST; /* optional: specify local directory */
run;
/* Setup libref to execute the ftp command */
filename ftpcmds "&ftpcmds";
data _null_;
file ftpcmds pad lrecl=80;
put "user &userid &ftppwd";
put "verbose";
put "trace";
put "&xfermode";
put "cd &homedir";
put "lcd &localdir";
put "prompt"; /* used for MPUT and MGET commands */
put "mget GbatRenewRateMonth201807*.txt"; /* specify wilcard used for MGET command */
put "quit";
run;
filename doftp pipe %unquote(%str(%')ftp -n -s:"&ftpcmds" &host%str(%'));
data _null_;
infile doftp;
input;
put _infile_;
run;
* 참고 : [FILENAME,FPT] FTP에서 복수의 파일을 PC로 이송 후 SAS 데이터로 읽기
: http://cafe.daum.net/statsas/3F8j/372
