topic Re: Issues using SAS FTP functionality fb and vb in SAS Programming

Issues using SAS FTP functionality fb and vb

deleted_user — Wed, 13 Oct 2010 15:46:56 GMT

When FTPing files using SAS it successfully transfer the files but the file is transferred as vb (variable block) even if I specify fb (fixed block).

Any ideas or suggestions how to fix it?

Re: Issues using SAS FTP functionality fb and vb

Doc_Duke — Wed, 13 Oct 2010 16:15:24 GMT

Perhaps you could show your code. FB and VB are attributes for mainframes, so I suspect the target needs to be a mainframe for this option to work. One example I found uses the RCMD= to send it.

http://support.sas.com/kb/18/665.html

Re: Issues using SAS FTP functionality fb and vb

deleted_user — Thu, 14 Oct 2010 05:34:22 GMT

This is the code I used;

FILENAME f ftp "BCNE.BRYAN.FCBTEST"
host='10.33.255.17' user='PASS' pass='XXXXXX'/*cd='..'*/ debug RECFM=fb lrecl=80;

data _null_;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
%let _EFIREC_ = 0; /* clear export record count macro variable */
file f RECFM=FB LRECL=80;;

set T03 end=EFIEOD;
format col1 $80. ;
do;
EFIOUT + 1;
put col1 $ ;
;
end;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
if EFIEOD then call symputx('_EFIREC_',EFIOUT);
run;

Can anyone see any issues with it?

Re: Issues using SAS FTP functionality fb and vb

Robert_Bardos — Thu, 14 Oct 2010 08:12:57 GMT

Doc's RCMD suggestion is worth following. Try to pass both STATUS and LOCSTAT commands to the FTP process in order to have both the server and client settings displayed.

(At least that's what I would try next. Not having used SAS's FTP access method I don't know whether you will get the messages though.)