3 Replies Latest reply on Oct 25, 2013 5:41 AM by Andrei Rukavina

    Extract exceeds lines

    Hellen Escarate

      Hello,

       

      When I am creating a extract and I put the number of lines, for exemple 500, the extract exceeds the numer of lines.

       

      Do you know this problem?

       

      I am using SAS source.

       

      thanks!

       

      Best Regards,

      Hellen

        • 1. Re: Extract exceeds lines
          Tracy Rodgers

          Hi Hellen,

           

          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?

           

          -Tracy

          • 2. Re: Extract exceeds lines
            Hellen Escarate

            Hi Tracy,

             

            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.

             

            Thanks!

            Best regards.

             

            Hellen

            • 3. Re: Extract exceeds lines
              Andrei Rukavina

              Hi Hellen,

               

              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?

               

              Regards!

              Andrei.-