Desktop productivity for business analysts and programmers

Limit number of displayed rows

Reply
Contributor
Posts: 33

Limit number of displayed rows

Is there a way to limit number of displayed rows, when dragging a big table into the process flow. I have an MySql table with 800 000 rows, and i want to see the 100 first rows. When i drag the table into the process flow, all the rows are processed, and it takes about 5 minutes to get the results. Is there an option to set that only the x first rows are to be processed?
BR
Jenny
N/A
Posts: 0

Re: Limit number of displayed rows

Jenny,

Try this.
Create new code as follows:

options obs=100;
run;

After you run this code, drag the big table into the process. I believe that should limit you to 100 obs. Afterwards, you would probably want to reset the number of obs to max because this option change affects all subsequent tasks (Someone correct me if I'm wrong, please).

Nori
Ask a Question
Discussion stats
  • 1 reply
  • 97 views
  • 0 likes
  • 2 in conversation