<?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 SQL Error in SAS Procedures</title>
    <link>https://communities.sas.com/t5/SAS-Procedures/SQL-Error/m-p/18539#M3657</link>
    <description>I am running a proc sql statement that joins a table to a view (the view is a pass-through Oracle query).  I have written several of these, but on this one I am getting an error have never seen.  The table loads, but as I scroll down, it has two rows numbered 259.  When I get to these rows, an error window opens that says:&lt;BR /&gt;
&lt;BR /&gt;
Must be 0 &amp;lt;= a_nRecord &amp;lt; RecordCount.  &lt;BR /&gt;
Parameer name: a_nRecord&lt;BR /&gt;
Actual value was 260.&lt;BR /&gt;
&lt;BR /&gt;
When I click OK, the table closes.  Any ideas?&lt;BR /&gt;
&lt;BR /&gt;
Thanks,&lt;BR /&gt;
Chris</description>
    <pubDate>Mon, 28 Feb 2011 18:28:55 GMT</pubDate>
    <dc:creator>cjohnson</dc:creator>
    <dc:date>2011-02-28T18:28:55Z</dc:date>
    <item>
      <title>SQL Error</title>
      <link>https://communities.sas.com/t5/SAS-Procedures/SQL-Error/m-p/18539#M3657</link>
      <description>I am running a proc sql statement that joins a table to a view (the view is a pass-through Oracle query).  I have written several of these, but on this one I am getting an error have never seen.  The table loads, but as I scroll down, it has two rows numbered 259.  When I get to these rows, an error window opens that says:&lt;BR /&gt;
&lt;BR /&gt;
Must be 0 &amp;lt;= a_nRecord &amp;lt; RecordCount.  &lt;BR /&gt;
Parameer name: a_nRecord&lt;BR /&gt;
Actual value was 260.&lt;BR /&gt;
&lt;BR /&gt;
When I click OK, the table closes.  Any ideas?&lt;BR /&gt;
&lt;BR /&gt;
Thanks,&lt;BR /&gt;
Chris</description>
      <pubDate>Mon, 28 Feb 2011 18:28:55 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Procedures/SQL-Error/m-p/18539#M3657</guid>
      <dc:creator>cjohnson</dc:creator>
      <dc:date>2011-02-28T18:28:55Z</dc:date>
    </item>
  </channel>
</rss>

