topic Re: How to convert packed decimal to text ? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81632#M17607 <HTML><HEAD></HEAD><BODY><P>Thank you Tom </P><P>That is what I intended. </P><P></P><P>OHt</P><P></P><P>There are also some very useful papers on the support.sas.com website on the topic. </P><P></P><P></P><P>Peter</P></BODY></HTML> Fri, 13 Apr 2012 17:24:39 GMT Peter_C 2012-04-13T17:24:39Z How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81625#M17600 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have ftp a file that contains paked decimal from Mainframe(MVS- no SAS) to unix using 'EXEC PGM=FTP'. Is there any way to convert the packed decimal to numeric or char in Unix ?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 12 Apr 2012 16:45:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81625#M17600 oht 2012-04-12T16:45:31Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81626#M17601 <HTML><HEAD></HEAD><BODY><P>It's probably relatively easy.</P><P></P><P>Can you provide a few examples of what the data look like after being transferred (hex codes, please), and what values they should become?</P></BODY></HTML> Thu, 12 Apr 2012 18:26:12 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81626#M17601 Astounding 2012-04-12T18:26:12Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81627#M17602 <HTML><HEAD></HEAD><BODY><P>Just make sure to move the file as BINARY and not ASCII with FTP.</P><P>Then you should be able to read it with SAS using PD informat.</P></BODY></HTML> Thu, 12 Apr 2012 18:34:58 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81627#M17602 Tom 2012-04-12T18:34:58Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81628#M17603 <HTML><HEAD></HEAD><BODY><P>We did try to ftp in binary format and then use the SAS PD to read in the data. However, the pack decimal vaules all become missing.values.</P><P></P><P>We finally able to convert the pd to flat file with COBALT and then FTP and it works</P><P></P><P>Tom,Astounding, really thanks for your help</P></BODY></HTML> Thu, 12 Apr 2012 19:00:58 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81628#M17603 oht 2012-04-12T19:00:58Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81629#M17604 <HTML><HEAD></HEAD><BODY><P>For future reference, PD OFF-mvs is not the same as PD ON-mvs</P><P>To read data in binary mvs PD format use the informat S370FPD.</P><P>There are several of these S370Fxxx formats designed to help with the task of reading ebcdic data (as well as $ebcdic itself)</P><P></P><P>not S3270FPD ( 3270 is an IBM terminal data ) Message was edited by: Peter Crawford</P></BODY></HTML> Thu, 12 Apr 2012 19:37:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81629#M17604 Peter_C 2012-04-12T19:37:17Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81630#M17605 <HTML><HEAD></HEAD><BODY><P>Thanks Peter, I am sorry I get confused with 'PD OFF-mvs is not the same as PD ON-mvs'&nbsp; ? Do you mean I can read in the MVS PD data in unix using informat S370FPD if the file was FTP in binary ?</P></BODY></HTML> Fri, 13 Apr 2012 11:43:20 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81630#M17605 oht 2012-04-13T11:43:20Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81631#M17606 <HTML><HEAD></HEAD><BODY><P>That is what he meant.&nbsp; There are a number of useful formats/informats that should allow you to both read and write data that can be moved to/from IBM mainframe.&nbsp;&nbsp; For example I was just using the S370FIB to write binary integers with the byte order in the direction I wanted.</P></BODY></HTML> Fri, 13 Apr 2012 13:20:57 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81631#M17606 Tom 2012-04-13T13:20:57Z Re: How to convert packed decimal to text ? https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81632#M17607 <HTML><HEAD></HEAD><BODY><P>Thank you Tom </P><P>That is what I intended. </P><P></P><P>OHt</P><P></P><P>There are also some very useful papers on the support.sas.com website on the topic. </P><P></P><P></P><P>Peter</P></BODY></HTML> Fri, 13 Apr 2012 17:24:39 GMT https://communities.sas.com/t5/SAS-Programming/How-to-convert-packed-decimal-to-text/m-p/81632#M17607 Peter_C 2012-04-13T17:24:39Z