Common Parameter: importOptions
CASL Syntax
Lua Syntax
Parameters for fileType="AUTO"
No parameters apply when you specify AUTO
Parameters for fileType="BASESAS"
charMultiplier=double
specifies a multiplier value to expand fixed-width character variables that might require transcoding. The lengths are increased to avoid character data truncation. The lengths are increased by multiplying the length by the specified value.
| Default | 1 |
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
password="string"
specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.
read="string"
specifies the Read password for the SAS data set.
Parameters for fileType="CSV"
allowTruncation=TRUE | FALSE
specifies that truncation of character data that is too long for a given field is allowed.
| Default | TRUE |
delimiter="string"
specifies the character to use as the field delimiter.
| Default | "," |
encoding="string"
specifies the text encoding of the file.
| Default | "utf-8" |
getNames=TRUE | FALSE
when set to True, the values in the first line of the file are used as variable names.
| Default | TRUE |
guessRows=64-bit-integer
specifies the number of rows to scan in order to determine data types for variables. Specify 0 to scan all rows.
| Default | 20 |
| Minimum value | 1 |
locale="string"
specifies the locale for interpreting data in the file
nThreads=integer
specifies the number of threads to use on each machine in the server. By default, the server uses one thread for each CPU that is licensed to use SAS software.
| Default | 0 |
| Minimum value | 0 |
stripBlanks=TRUE | FALSE
removes leading and trailing blanks from character variables.
| Alias | shootBlanks |
| Default | FALSE |
varChars=TRUE | FALSE
when set to True, variable-length strings are used for character variables.
| Default | TRUE |
vars={{casvardesc-1} <, {casvardesc-2}, ...>}
specifies the names, types, formats, and other metadata for variables.
format="string"
specifies the format to apply to the variable.
formattedLength=integer
specifies the format field length plus the format precision length.
label="string"
specifies the descriptive label for the variable.
length=integer
specifies the unformatted length of the variable. This parameter applies to fixed-length character variables (type="CHAR") only.
| Default | 8 |
| Minimum value | 1 |
name="string"
specifies the name for the variable.
nfd=integer
specifies the format precision length.
nfl=integer
specifies the format field length.
type="BINARY" | "CHAR" | "DATE" | "DATETIME" | "DECQUAD" | "DECSEXT" | "DOUBLE" | "INT32" | "INT64" | "TIME" | "VARBINARY" | "VARCHAR"
specifies the data type for the variable.
| Default | DOUBLE |
Parameters for fileType="DTA"
No parameters apply when you specify DTA
Parameters for fileType="ESP"
maxTime=integer
specifies the number of seconds to receive data from SAS Event Stream Processing before declaring an end of file on the stream. The data is read until an end of file is found, and then the action stops running.
| Default | 5 |
sasTypes=TRUE | FALSE
when set to True, the table is created with character and float data types only. When set to False, the table uses the same data types that are used in the ESP event.
| Default | FALSE |
Parameters for fileType="EXCEL"
getNames=TRUE | FALSE
when set to True, the values in the first line of the file are used as variable names.
| Default | TRUE |
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
Parameters for fileType="FMT"
name="string"
specifies a file system path and filename. The file must be a SAS item store that includes the formats to import.
Parameters for fileType="HDAT"
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for fileType="JMP"
No parameters apply when you specify JMP
Parameters for fileType="LASR"
compPgm="string"
specifies an expression for each computed variable that you include in the computedVars parameter.
compVars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter.
format="string"
specifies the format to apply to the variable.
formattedLength=integer
specifies the format field length plus the format precision length.
label="string"
specifies the descriptive label for the variable.
name="variable-name"
specifies the name for the variable.
nfd=integer
specifies the format precision length.
nfl=integer
specifies the format field length.
nThreads=integer
specifies the number of threads to use on each machine in the server. By default, the server uses one thread for each CPU that is licensed to use SAS software.
| Default | 0 |
| Minimum value | 0 |
parallelMode="FALLBACK" | "FORCE" | "NONE"
FALLBACK
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
FORCE
specifies to perform a parallel load. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
NONE
specifies to perform a serial load.
preserveOrder=TRUE | FALSE
when set to True, the rows are inserted into the new table in the same order as they are received from the SAS LASR Analytic Server. Creating the table is less efficient when this parameter is used.
| Default | FALSE |
varchars=TRUE | FALSE
when set to True, variable-length strings are used for character variables.
| Default | FALSE |
vars={"string-1" <, "string-2", ...>}
specifies the variables to use in the action.
where="where-expression"
specifies an expression for subsetting the input data.
Parameters for fileType="MVA"
No parameters apply when you specify MVA
Parameters for fileType="SPSS"
No parameters apply when you specify SPSS
Parameters for fileType="XLS"
getNames=TRUE | FALSE
when set to True, the values in the first line of the file are used as variable names.
| Default | TRUE |
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.