In case anyone else runs into a similar issue, SAS Technical Support was able to give us a solution! A modified explanation from them: "Starting in 9.4M2 when you are accessing Oracle 12c or later and your code includes (obs= ), a "fetch first n rows" is appended to the query that is submitted to the database. This results in Oracle only providing the [first n observations] to SAS which explains why the first [n] rows worked but [then] could no longer find the match. Another piece to this issue is...using a function that is not passed to the database automatically. [Running] with [the SQL_FUNCTIONS= option in your LIBNAME statement], the WHERE was passed to the database so the obs= didn't affect the pulling of results." So, we have added the "sql_functions = all" to our database libname statement, and that works. Support also provided us these helpful links: http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n0k1cax0gzsdxdn1a3466l1gwtk9.htm http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p0f64yzzxbsg8un1uwgstc6fivjd.htm
... View more
