DATA Step, Macro, Functions and more

Problems parsing ebcdic encoded sequential file

Reply
Contributor
Posts: 71

Problems parsing ebcdic encoded sequential file

[ Edited ]

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?

Contributor
Posts: 71

Re: Problems parsing ebcdic encoded sequential file

Posted in reply to tomcmacdonald

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.

Ask a Question
Discussion stats
  • 1 reply
  • 90 views
  • 0 likes
  • 1 in conversation