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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.