Processes | Utilities | List of Variable Names and Types

List of Variable Names and Types
This option is available for improving import speed for extremely wide text files that are tab delimited, space delimited, or comma separated. Specify each of the variable names, even if they already exist in the first row of the file.
Variables are either numeric or character. Type a dollar sign ( $ ) following each character variable . Separate names by an empty space or use ranges of variables with a hyphen. For example, specify
ID $ Sex $ Age (SNP1-SNP100000) ($)
to import the first column as character ID , the second column as character Sex , the third column as numeric Age , and the following 100,000 columns as SNP1 to SNP100000 with character type. Note that to classify all the SNP columns in a range as character, you must enclose both the range specification and the $ in parentheses as shown. However, you can often obtain better performance by not using parentheses and instead specifying a common length for the range of character variables in the next parameter ( List of Variable Names and Lengths ). For example, specify
ID $ Sex $ Age SNP1-SNP500000
for this parameter, and
ID $10 Sex $1 Age 3 SNP1-500000 $2
for the next parameter ( List of Variable Names and Lengths ) to set a length of 10 for ID , 1 for Sex , 3 for Age , and 2 for all variables SNP1 to SNP500000 .
Specifying this parameter and the following parameter ( List of Variable Names and Length ) for ranges of character variables can significantly reduce import time. The default length of character string is 8. Please define those variables with length larger than 8, or they will be truncated.
Leave this field empty for the system to automatically detect the variable names and types.
To Specify a List of Variable Names and Types:
*
Type the appropriate line into the List of Variable Names and Types box.
Refer to Base SAS documentation on the INPUT statement for additional details.