How do you use LSA in SFTP syntax

Frede_1 — Mon, 15 Feb 2016 12:49:33 GMT

I have some issues using the syntax LSA in the SFTP procedure.

Untill now i have used the syntax below and it has worked fine.

filename local '***************************' LRECL = 2000;

filename SFTP SFTP '/'

DIR FILEEXT LSA

HOST = '***.**.***.**'

USER = '**********'

WAIT_MILLISECONDS = 5000

LRECL = 2000

OPTIONS = '-P ** -i \\*****.*** -pw "*******"'

DEBUG

I have manged to transfer files from the SFTP library SFTP to my own library local, using the following syntax.

data _null_;

infile SFTP ('&SFTP_FILE') truncover;

input;

file local (&LOCAL_FILE');

Put _infile_;

run;

But how do i use SAS to get an exact overview of all the files that are located in the library SFTP. I have read that i can use the LSA and LS syntax but I cant really get it to work.

Please help 🙂

Kind regards Frederik.

Re: How do you use LSA in SFTP syntax

Frede_1 — Tue, 16 Feb 2016 14:57:40 GMT

I recieved the following solution from Bruno that works perfectly, thought I would share it:

Frederik

The follwoing code works for me. It will list all the files from the root directory to the SAS Log. You will need to adapt it to your needs.

filename xsas ftp cd="/" host="machine" user="myuser" pass="mypass" list debug;

data _null_;

infile xsas;

input;

putlog _infile_;

run;

Please send also the log

topic How do you use LSA in SFTP syntax in SAS Programming

How do you use LSA in SFTP syntax

Re: How do you use LSA in SFTP syntax