topic Re: Question on using SFTP to rename a file at remote SFTP server after getting the file in SAS Programming

Question on using SFTP to rename a file at remote SFTP server after getting the file

DennisLam — Tue, 03 Nov 2015 17:13:55 GMT

Hi, I need to develop a SAS program to get a file from an remote SFTP server and rename the file after download the file. I can get the file but don't know how to send the UNIX rename command to the remote SFTP server to rename the file. Any suggestion?

Following is my code that I have developed and it works well:

Filename SITE1 SFTP "reports/Market_Summary_date..csv"
Host="142.199.199.199" user="user1" ;

data WORK.Market_DATA ;
%let _EFIERR_ = 0;
infile site1 delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2;
informat REPORT_DATE yymmdd10. ;

format REPORT_DATE yymmdd10. ;

input
REPORT_DATE;

if _ERROR_ then call symputx('_EFIERR_',1);

run;

Re: Question on using SFTP to rename a file at remote SFTP server after getting the file

DartRodrigo — Tue, 03 Nov 2015 18:49:40 GMT

Hi mate.

You can use the filename statement to rename the file using a shell script command "mv".

you can use the following sintax:

filename myfile pipe "mv myfile.txt newfile.txt";

/*or you can use the X command*/

x "mv myfile.txt newfile.txt";

Once you have permission to execute shell scripts you can use filename, call system, or x command to execute Shell scripts from SAS.

Check out some Shell commands or Executing Operating System Commands from Your SAS Session;

Hope this helps

Re: Question on using SFTP to rename a file at remote SFTP server after getting the file

DennisLam — Tue, 03 Nov 2015 20:20:00 GMT

Hi, thank you for sharing the code with me.. I have some problems on using the Filename myfile Pipe statement.

If I use this

Filename SITE4 PIPE 'mv reports/Market_Summary_20151102.csv reports/Market_Summary_20151102.done'
Host="142.199.199.199" user="userid" ;
run;

I received an error message tha Host and user are invalid option. It seems to me that host and user cannot use with pipe. If I don't define for SFTP server IP and user id, how can I rename the file

If I use this

Filename SITE4 PIPE 'mv reports/Market_Summary_20151102.csv reports/Market_Summary_20151102.done' ;
run;

I received an error message that I have insufficient authority.

Please advise and thank you for your help...

Re: Question on using SFTP to rename a file at remote SFTP server after getting the file

DartRodrigo — Wed, 04 Nov 2015 10:54:57 GMT

Hi mate,

Once you are in the enviroment of this host you don't need to use these options.

Your SAS is connected in this host, or it is another server ?

These are the questions that you might answer to select the option that you have to use.

Pipe is used to the server you are connected.

Maybe you should use instead of pipe use sftp and do the same.

Try this: FILENAME Statement, SFTP Access Method

Hope this helps