To browse the data sets on the SAS server, select File > SAS > Browse Data. The Browse SAS Data window appears. See Figure 2.19.
Figure 2.19 Browse SAS Data
Figure 2.20 Data Preview
Click Get Details in the Browse SAS Data window to see the size and last modification date for each data set in the library. This option helps you estimate whether your computer can process the entire data set.
Figure 2.21 Column Details
By default, JMP specifies All rows for import.
2.
Click Import.
Figure 2.22 Import Options
1.
In the Import Options section, select First x rows only and specify the number of rows to import.
1.
In the Import Options section, select Auto-sample and specify the number of MB to import.
Figure 2.23 Select Columns
3.
Click Add.
1.
Click Where.
3.
Click OK to return to the Browse SAS Data window.
4.
Click Import.
Figure 2.24 Custom SQL
3.
Click Execute Custom SQL.
In the Sample Imported Data area of the Import Options outline, select the Custom random sample check box. By default, 5% of the rows are imported. To change the random sample import settings, click the Settings button.
Figure 2.25 Sampling Settings
You can set the sample size be percentage or by number of rows. To ensure that each row is sampled only once, de-select the With replacement option. To ensure that any row can be sampled and appear more than once in the imported data, select the option.
If With replacement is selected, you can specify to either add each duplicated row as a separate row or combine all duplicated rows into one row. If the second option is selected, a column is added to the table that contains a count of how many times each row was sampled.
1.
Select File > Open.
2.
Select SAS Data Sets from the Files of type list.
4.
Click Open.

Help created on 7/12/2018