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?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.