08-16-2013 06:26 PM
ed deHi all
I am trying to read a Mainframe flat file in to Unix (AIX) platform. I am using SAS FTP for this purpose. I need to read and later on export this file as excel using proc export. How ever I am facing issue while reading the packed decimal field stored in this file. They are getting read as unreadble characters and come as missing in the printed output.
I use the following filename statement.
FILENAME FTP TEST "'TEST.TESTFILE.MF'" HOST="XXX.XXX.COM" USER="XXX" PASS="XXXX";
INFILE TEST TRUNCOVER;
INPUT PDFIELD PD4.2;
I tried using S370FPD in the input statements. I also tried giving binary/encoding=ebcdicany options in the FILENAME statement. Nothing seems to work for this packed decimal field alone. Can anyone help me in reading this field in a printable form?
Thanks in advance.
Need further help from the community? Please ask a new question.