topic Download file from URL of FTP site to SAS in SAS Programming

Download file from URL of FTP site to SAS

arunrami — Mon, 21 Oct 2019 12:08:14 GMT

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
;

Re: Download file from URL of FTP site to SAS

MichaelLarsen — Mon, 21 Oct 2019 11:36:54 GMT

start by adding the DEBUG parameter to the filename statement. You should then see additional information in the log that may help in finding out the cause for the error message.

Re: Download file from URL of FTP site to SAS

arunrami — Mon, 21 Oct 2019 12:07:07 GMT

Nope. I am now getting any error while running filename statement .

Error comes with proc import when I tried to read the file

Re: Download file from URL of FTP site to SAS

arunrami — Mon, 21 Oct 2019 12:15:54 GMT

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..

Re: Download file from URL of FTP site to SAS

Kurt_Bremser — Mon, 21 Oct 2019 12:41:33 GMT

Have you made sure that passwordless sftp works from the commandline?

Re: Download file from URL of FTP site to SAS

MichaelLarsen — Mon, 21 Oct 2019 13:03:17 GMT

If you are trying to access a SFTP site then please read the documentation:

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lestmtsglobal&docsetTarget=p0xln1fiwsr340n1xxf4mkmfxp6f.htm&locale=da

currently you have specified the FTP protocol which will not work with SFTP.