IMPORT Procedure
GUESSINGROWS Statement
Specifies the number of rows of the file to scan
to determine the appropriate data type and length for the columns.
| Restriction: | This value should be greater than the value specified for DATAROW. |
| Interaction: | The GUESSINGROWS statement is valid only for delimited files. |
Syntax
GUESSINGROWS=n;
Required Argument
- n
-
Indicate the number of rows the IMPORT procedure scans in the input file to determine the appropriate data type and length of columns. The scan data process scans from row 1 to the number that is specified by the GUESSINGROWS option.Default:20Range:1 to 2147483647Note:You can change the default value in the SAS Registry under SAS Registry
ProductsBaseEFIGuessingRows.