I am trying to read file from FTP site , but I am getting following error while doing import .
can any one help?
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update
mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
ERROR: Open failed for file TEST
ERROR: Import unsuccessful. See SAS Log for details.
filename test ftp
'S****.csv'
cd = '/Home/abacb/' /*directory of file*/
host= 'sftp.com'
user= 'uuuuu'
pass = 'xxxxx'
passive binary recfm=s
;
Nope. I am now getting any error while running filename statement .
Error comes with proc import when I tried to read the file
tried data step getting below error..
@Kurt_Bremser @MichaelLarsen @Cynthia_sas can you please suggest something
26 data _null_;
27 infile test obs=10;
28 input;
29 put _infile_;
30 run;
ERROR: Open failed for file TEST
ERROR: The connection has timed out..
Have you made sure that passwordless sftp works from the commandline?
If you are trying to access a SFTP site then please read the documentation:
currently you have specified the FTP protocol which will not work with SFTP.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.