<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400644#M97138</link>
    <description>&lt;P&gt;Do you just have issues with that one field that is in column 273?&lt;/P&gt;
&lt;P&gt;If so then read the column using the $CHAR1. informat and do a proc freq on the observed values , probably with $HEX2. format attached and see what values are actually in your source data.&amp;nbsp; It is hard to tell in your posting but it looks like the value it is complaining about is&amp;nbsp; '02'x.&amp;nbsp; So perhaps it is a binary integer instead of a packed decimal?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 03 Oct 2017 16:33:22 GMT</pubDate>
    <dc:creator>Tom</dc:creator>
    <dc:date>2017-10-03T16:33:22Z</dc:date>
    <item>
      <title>Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400611#M97127</link>
      <description />
      <pubDate>Thu, 26 Oct 2017 01:20:20 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400611#M97127</guid>
      <dc:creator>martystoked</dc:creator>
      <dc:date>2017-10-26T01:20:20Z</dc:date>
    </item>
    <item>
      <title>Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400644#M97138</link>
      <description>&lt;P&gt;Do you just have issues with that one field that is in column 273?&lt;/P&gt;
&lt;P&gt;If so then read the column using the $CHAR1. informat and do a proc freq on the observed values , probably with $HEX2. format attached and see what values are actually in your source data.&amp;nbsp; It is hard to tell in your posting but it looks like the value it is complaining about is&amp;nbsp; '02'x.&amp;nbsp; So perhaps it is a binary integer instead of a packed decimal?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2017 16:33:22 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400644#M97138</guid>
      <dc:creator>Tom</dc:creator>
      <dc:date>2017-10-03T16:33:22Z</dc:date>
    </item>
    <item>
      <title>Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400683#M97147</link>
      <description>&lt;P&gt;According to the copy book that I have that field is a: PIC&amp;nbsp; S9(1) COMP-3. My other concern though is that it doesn't look to be translating the first part of the program that I have pointed out in my other picture. Not sure if that could be causing the problems? I am running the process now to see if I can get a proc freq on those values.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2017 17:45:35 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400683#M97147</guid>
      <dc:creator>martystoked</dc:creator>
      <dc:date>2017-10-03T17:45:35Z</dc:date>
    </item>
    <item>
      <title>Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400706#M97149</link>
      <description>&lt;P&gt;'02'x is not a valid value for packed decimal. The second nibble of the byte should contain the hex values C, D or F.&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2017 18:27:39 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400706#M97149</guid>
      <dc:creator>Kurt_Bremser</dc:creator>
      <dc:date>2017-10-03T18:27:39Z</dc:date>
    </item>
    <item>
      <title>Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400714#M97150</link>
      <description>&lt;P&gt;Since the error for position happens quite late horizontally (lots of previous PD variables) and vertically (almost 1500000 records without problems), it points to a problem in the creation of the mainframe file. Have it checked by the host programmer responsible.&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2017 18:34:21 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400714#M97150</guid>
      <dc:creator>Kurt_Bremser</dc:creator>
      <dc:date>2017-10-03T18:34:21Z</dc:date>
    </item>
    <item>
      <title>Re: Mainframe to SAS FTP formatting sometimes works and sometimes isnt reading the file correctly</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400737#M97154</link>
      <description>&lt;P&gt;That's what I was thinking because it is sometimes working thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2017 19:01:07 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Mainframe-to-SAS-FTP-formatting-sometimes-works-and-sometimes/m-p/400737#M97154</guid>
      <dc:creator>martystoked</dc:creator>
      <dc:date>2017-10-03T19:01:07Z</dc:date>
    </item>
  </channel>
</rss>

