Limit Table Size
The following is a guide on limiting the size of tables in SAS Viya.
When testing new code, limiting the number of observations in a user’s input datasets will prevent the code from taking a long time to run.
Load only the relevant columns and only run test code on a limited number of rows (i.e., 100,000 rows or one million rows instead of all the rows).
- Limit the data being used while testing.
- Test on a sample set of 10,000 or 100,000 rows, not the entire data set, until the code is working 100 percent.