topic Reading a mainframes file through SAS on Unix in SAS Procedures

Reading a mainframes file through SAS on Unix

mmehr3 — Sat, 09 May 2015 10:18:29 GMT

Hi All,

I am trying to read a mianframes file through SAS but somehow the code is only reading the alternate lines of input data, Is there something I am missing out on.

Here's the SAS Code I have been trying :

FILENAME FIXIT FTP "&FIXEDFILE" host="dipe.ipc.us.xxxx.com"

user="&mfuser." pass="&mfpass." cd='..' RECFM=F LRECL=200;

DATA FIXED;

INFILE FIXIT ;

INPUT

@04 R_TRANCD $EBCDIC2.

@07 USERCD $EBCDIC2.

@20 TRANSAMT $EBCDIC14.

RUN;

Could you please suggest.

Re: Reading a mainframes file through SAS on Unix

MichaelLarsen — Mon, 11 May 2015 08:17:47 GMT

Do you get any warnings in the log?

Are you certain that RECFM=F and LRECL=200 are correct?

Regards,

Michael

Re: Reading a mainframes file through SAS on Unix

Kurt_Bremser — Mon, 11 May 2015 08:58:46 GMT

What is the organisation of the file on the mainframe (FB, VB, ...) and the record size?

The log from the data step would be helpful.

Small hint:

filename fixit ftp "'&fixedfile'" .....;

lets you omit the cd='..' option. Note the single quotes inside the double quotes.