how to get more then 100 records when creating data query in SAS VA
Hello Syed,
Thanks & Regards,
Teja Surapaneni
still i am not getting more then 100 records in data query using SAS VA, why there is restriction to get whole data.
Hi Syed,
By Default the query builder, just show you first 100 rows of your output table. So that you will get an idea of how the data will display.
that doesn't mean that your query has only 100 records. You can always change how many rows you want to see for your output table.
- Amol Mekha
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.