DATA Step, Macro, Functions and more

How do you use LSA in SFTP syntax

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

How do you use LSA in SFTP syntax

Hi

 

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 Smiley Happy

 

Kind regards Frederik.

 


Accepted Solutions
Solution
‎02-16-2016 09:57 AM
Occasional Contributor
Posts: 5

Re: How do you use LSA in SFTP syntax

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

View solution in original post


All Replies
Solution
‎02-16-2016 09:57 AM
Occasional Contributor
Posts: 5

Re: How do you use LSA in SFTP syntax

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 225 views
  • 0 likes
  • 1 in conversation