topic Re: Error using FIlename statement and FTP access method in SAS Programming

Error using FIlename statement and FTP access method

kimdukes77 — Fri, 30 Jun 2017 08:07:53 GMT

Am getting the error "ERROR: Physical file does not exist, /testclear.zip".

Code is:-

filename rmt ftp '/testclear.zip' host='sftp.ucas.com'
user='anonymous' pass='XXXXX'
cd='/incoming/' recfm=s debug;

FILENAME lcl '\\par2\adi\data\STROBE\Jobs\2017\SR170601_001_BRITCO\PROJECT\RAW_DATA\testclear.zip' recfm=n;

data _NULL_;
N=1;
INFILE rmt NBYTE=n;
INPUT;
FILE lcl ;
PUT _INFILE_ @@;
run;

The rest of the log looks ok and file does exist and can be retrieved using FTP portal. Can anyone help?

Re: Error using FIlename statement and FTP access method

Kurt_Bremser — Fri, 30 Jun 2017 08:51:17 GMT

Remove the leading forward slash from the filename:

filename rmt ftp 'testclear.zip' host='sftp.ucas.com'
user='anonymous' pass='XXXXX'
cd='/incoming/' recfm=s debug;

Re: Error using FIlename statement and FTP access method

kimdukes77 — Wed, 05 Jul 2017 10:47:52 GMT

Ok I've tried that and it still doesn't work.

filename rmt ftp '' host='sftp.ucas.com'
user='anonymous' pass='XXXXX'
cd='/incoming/' recfm=s debug;

FILENAME lcl '' recfm=n;

data _NULL_;
N=1;
INFILE rmt NBYTE=n;
INPUT;
FILE lcl ;
PUT _INFILE_ @@;
run;

Re: Error using FIlename statement and FTP access method

Kurt_Bremser — Fri, 30 Jun 2017 09:19:46 GMT

The source file is simply not there. I just did this:

$ ftp sftp.ucas.com
Connected to sftp.ucas.com.
220 UKPASS Secure FTP Server
Name (sftp.ucas.com:XXXXX): anonymous
331 Password required for anonymous.
Password: 
230 Login OK. Proceed.
ftp> cd /incoming/
250 Folder changed to "/incoming".
ftp> ls
200 Command okay.
150 Opening ASCII mode data connection for file list.
jb.txt
226 Transfer complete. 8 bytes transferred. 8 Bps.
ftp> quit

As you can see, there's only one file named jb.txt there.