BookmarkSubscribeRSS Feed
Jennys
Calcite | Level 5
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
1 REPLY 1
deleted_user
Not applicable
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1707 views
  • 0 likes
  • 2 in conversation