topic Re: SAS FTP Upload in SAS Procedures

SAS FTP Upload

vomer — Wed, 13 Mar 2013 14:38:44 GMT

Hi All, I have a question around SAS and FTP:

Currently I have a set of reports generated by SAS (let's assume PDF's, EXCEL etc) in a directory (let's assume called 'report')

Is there any code I can add which can do the following:

1. Connect to my FTP/SFTP server

2. Upload the directory I specify from my system -> to a directory I specify on the FTP server.

Please provide sample code if possible!

Thank You!

DBailey — Wed, 13 Mar 2013 19:34:36 GMT

SAS has a FTP option for defining filenames. Might be easier to send already created objects via batch file which SAS can also run.

Subrata_LS — Thu, 03 Oct 2013 10:46:52 GMT

use the code below

options mlogic mprint obs=max formdlim='_' source2 noxsync noxwait source=1;

%let id=user;

%let pw=xxxxxx;

data null;

file 'F:\Batch\getDATA.bat'; * the batch file;

put "ftp -s:%0";

put "goto END";

put "&id";

put "&pw";

put 'CD "USer/Test/file"';/* FTP path*/

put "LCD C:\Users\dwnld";/* Local Destination path*/

put "GET abcd.txt";/* File name*/

put "bye";

put ":END";

run;

options noxsync noxwait;