Problems parsing ebcdic encoded sequential file

tomcmacdonald — Tue, 28 Nov 2017 19:33:01 GMT

I'm trying to parse an ebcdic encoded sequential file downloaded via FTP from a z/OS mainframe and it's cutting off rows. The code looks something like this:

filename f ftp <DSN>
  host=<HOST>
  user=<USER> 
  password=<PASSWORD> 
  port=<PORT>
  passive
  lrecl=<LRECL> 
  recfm=F;

data foo;
 infile f;
 input
 @<start1> <col1> <encoding1>
 @<start2> <col2> <encoding2>
 ...
 @<startn> <coln> <encodingn>;
run

The log file is registering that SAS recognizes the appropriate number of records it just stops on a bad row. There is packed decimal encoding so encoding directly to ASCII isn't trivial. How should I go about dealing with this in a SAS environment?

Re: Problems parsing ebcdic encoded sequential file

tomcmacdonald — Tue, 28 Nov 2017 20:37:51 GMT

OK, looks like I figured it out. Checking over this help file:

https://support.sas.com/resources/papers/proceedings13/122-2013.pdf

I used "?" between the variable name and informat.

topic Re: Problems parsing ebcdic encoded sequential file in SAS Programming

Problems parsing ebcdic encoded sequential file

Re: Problems parsing ebcdic encoded sequential file