https://communities.sas.com/t5/SAS-Enterprise-Guide/Limit-number-of-displayed-rows/m-p/1001#M287 Jenny,<BR /> <BR /> Try this.<BR /> Create new code as follows:<BR /> <BR /> options obs=100;<BR /> run;<BR /> <BR /> 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).<BR /> <BR /> Nori Mon, 10 Jul 2006 14:39:46 GMT deleted_user 2006-07-10T14:39:46Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Limit-number-of-displayed-rows/m-p/1000#M286 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 /> BR<BR /> Jenny Mon, 10 Jul 2006 10:34:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Limit-number-of-displayed-rows/m-p/1000#M286 Jennys 2006-07-10T10:34:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Limit-number-of-displayed-rows/m-p/1001#M287 Jenny,<BR /> <BR /> Try this.<BR /> Create new code as follows:<BR /> <BR /> options obs=100;<BR /> run;<BR /> <BR /> 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).<BR /> <BR /> Nori Mon, 10 Jul 2006 14:39:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Limit-number-of-displayed-rows/m-p/1001#M287 deleted_user 2006-07-10T14:39:46Z