I haven't been able to find any cases where this has happened. It may have something to do with using an ODBC driver.
Just to confirm you have Top X rows and not percent selected in the extract dialog box, right?
Thanks for your answer.
Ok, we have Top X rows in extract dialog box, not percent.
But we have two situations that the extract exceeds lines:
1) When we have put the number of rows in extract dialog box.
2) When we haven't put the number of rows in extract dialog box.
And when we have used a database source with a little number of lines (for exemple 2000 rows) the extract is completed, and not exceeds lines.
Have you added this on your ODBC properties, required for stable behavior:
Records to Buffer= 1000
Support VARCHAR= checked
Disable _0 override parsing= checked
Infer type in min/max functions= checked
Would you mind coping here your Custom Query or SAS Code?