Help using Base SAS procedures

SQL Error

Reply
Frequent Contributor
Posts: 97

SQL Error

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:

Must be 0 <= a_nRecord < RecordCount.
Parameer name: a_nRecord
Actual value was 260.

When I click OK, the table closes. Any ideas?

Thanks,
Chris
Christopher Johnson
www.codeitmagazine.com
Ask a Question
Discussion stats
  • 0 replies
  • 93 views
  • 0 likes
  • 1 in conversation