Data

Page tree




Back to Knowledge Base

Limit Table Size

Purpose

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.

Best Practice 

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.