Common Parameter: importOptions

CASL Syntax

importOptions={fileType="AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "SPSS" | "XLS", fileType-specific-parameters}

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.

Default1
Range1–5
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"

specifies how data is transferred between the data source and SAS Cloud Analytic Services.

DefaultAUTO
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.

varcharConversion=double

specifies the number of bytes to use as a threshold. When a column with the CHAR data type has a length that is equal to or exceeds the specified number of bytes, the VARCHAR data type is used.

Default0
Range1–32767

Parameters for fileType="CSV"

allowTruncation=TRUE | FALSE

specifies that truncation of character data that is too long for a given field is allowed.

DefaultTRUE
delimiter="string"

specifies the character to use as the field delimiter.

Default","
encoding="string"

specifies the text encoding of the file. If you do not specify this parameter, then the session encoding is used.

Default"utf-8"
getNames=TRUE | FALSE

when set to True, the values in the first line of the file are used as variable names.

DefaultTRUE
guessRows=64-bit-integer

specifies the number of rows to scan in order to determine data types for variables.

Default20
Minimum value1
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.

Default0
Minimum value0
stripBlanks=TRUE | FALSE

removes leading and trailing blanks from character variables.

DefaultFALSE
varChars=TRUE | FALSE

when set to True, variable-length strings are used for character variables.

DefaultTRUE
vars={{casvarcsvdesc-1} <, {casvarcsvdesc-2}, ...>}

specifies the names, types, formats, and other metadata for variables.

The casvarcsvdesc value can be one or more of the following:
format="string"

specifies the format to apply to the variable.

formattedLength=integer

specifies the length of format field plus the format precision.

informat="string"

specifies the informat to apply to the variable.

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.

Default8
Minimum value1
name="string"

specifies the name for the variable.

nfd=integer

specifies the length of the format precision.

nfl=integer

specifies the length of the format field.

type="BINARY" | "CHAR" | "DATE" | "DATETIME" | "DECQUAD" | "DECSEXT" | "DOUBLE" | "INT32" | "INT64" | "TIME" | "VARBINARY" | "VARCHAR"

specifies the data type for the variable.

DefaultDOUBLE

Parameters for fileType="DOCUMENT"

fileExtList={"CSV", "DOC", "DOCX", "EPUB", "HTML", "KEY", "MBOX", "MSG", "NUMBERS", "ODP", "ODS", "ODT", "PAGES", "PDF", "PPT", "PPTX", "PST", "RTF", "TNEF", "TXT", "WPD", "XLS", "XLSX", "XML"}

specifies the file extensions for subsetting document selection.

recurse=TRUE | FALSE

recursively import documents when the caslib definition permits access to subdirectories.

DefaultTRUE
tikaConv=TRUE | FALSE

specifies to convert the documents with the Apache Tika document conversion library.

DefaultFALSE

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.

Default5
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.

DefaultFALSE

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.

DefaultTRUE
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={"string-1" <, "string-2", ...>}

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter.

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.

Default0
Minimum value0
parallelMode="FALLBACK" | "FORCE" | "NONE"

specifies how the table is transferred from SAS LASR Analytic Server to SAS Cloud Analytic Services.

DefaultFALLBACK
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.

DefaultFALSE
varchars=TRUE | FALSE

when set to True, variable-length strings are used for character variables.

DefaultFALSE
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="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.

DefaultTRUE
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.

Lua Syntax

importOptions={fileType="AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "SPSS" | "XLS", fileType-specific-parameters}

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.

Default1
Range1–5
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"

specifies how data is transferred between the data source and SAS Cloud Analytic Services.

DefaultAUTO
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.

varcharConversion=double

specifies the number of bytes to use as a threshold. When a column with the CHAR data type has a length that is equal to or exceeds the specified number of bytes, the VARCHAR data type is used.

Default0
Range1–32767

Parameters for fileType="CSV"

allowTruncation=true | false

specifies that truncation of character data that is too long for a given field is allowed.

Defaulttrue
delimiter="string"

specifies the character to use as the field delimiter.

Default","
encoding="string"

specifies the text encoding of the file. If you do not specify this parameter, then the session encoding is used.

Default"utf-8"
getNames=true | false

when set to True, the values in the first line of the file are used as variable names.

Defaulttrue
guessRows=64-bit-integer

specifies the number of rows to scan in order to determine data types for variables.

Default20
Minimum value1
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.

Default0
Minimum value0
stripBlanks=true | false

removes leading and trailing blanks from character variables.

Defaultfalse
varChars=true | false

when set to True, variable-length strings are used for character variables.

Defaulttrue
vars={{casvarcsvdesc-1} <, {casvarcsvdesc-2}, ...>}

specifies the names, types, formats, and other metadata for variables.

The casvarcsvdesc value can be one or more of the following:
format="string"

specifies the format to apply to the variable.

formattedLength=integer

specifies the length of format field plus the format precision.

informat="string"

specifies the informat to apply to the variable.

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.

Default8
Minimum value1
name="string"

specifies the name for the variable.

nfd=integer

specifies the length of the format precision.

nfl=integer

specifies the length of the format field.

type="BINARY" | "CHAR" | "DATE" | "DATETIME" | "DECQUAD" | "DECSEXT" | "DOUBLE" | "INT32" | "INT64" | "TIME" | "VARBINARY" | "VARCHAR"

specifies the data type for the variable.

DefaultDOUBLE

Parameters for fileType="DOCUMENT"

fileExtList={"CSV", "DOC", "DOCX", "EPUB", "HTML", "KEY", "MBOX", "MSG", "NUMBERS", "ODP", "ODS", "ODT", "PAGES", "PDF", "PPT", "PPTX", "PST", "RTF", "TNEF", "TXT", "WPD", "XLS", "XLSX", "XML"}

specifies the file extensions for subsetting document selection.

recurse=true | false

recursively import documents when the caslib definition permits access to subdirectories.

Defaulttrue
tikaConv=true | false

specifies to convert the documents with the Apache Tika document conversion library.

Defaultfalse

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.

Default5
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.

Defaultfalse

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.

Defaulttrue
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={"string-1" <, "string-2", ...>}

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter.

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.

Default0
Minimum value0
parallelMode="FALLBACK" | "FORCE" | "NONE"

specifies how the table is transferred from SAS LASR Analytic Server to SAS Cloud Analytic Services.

DefaultFALLBACK
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.

Defaultfalse
varchars=true | false

when set to True, variable-length strings are used for character variables.

Defaultfalse
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="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.

Defaulttrue
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.

Python Syntax

importOptions={"fileType":"AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "SPSS" | "XLS", fileType-specific-parameters}

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.

Default1
Range1–5
"dataTransferMode":"AUTO" | "PARALLEL" | "SERIAL"

specifies how data is transferred between the data source and SAS Cloud Analytic Services.

DefaultAUTO
"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.

"varcharConversion":double

specifies the number of bytes to use as a threshold. When a column with the CHAR data type has a length that is equal to or exceeds the specified number of bytes, the VARCHAR data type is used.

Default0
Range1–32767

Parameters for fileType="CSV"

"allowTruncation":True | False

specifies that truncation of character data that is too long for a given field is allowed.

DefaultTrue
"delimiter":"string"

specifies the character to use as the field delimiter.

Default","
"encoding":"string"

specifies the text encoding of the file. If you do not specify this parameter, then the session encoding is used.

Default"utf-8"
"getNames":True | False

when set to True, the values in the first line of the file are used as variable names.

DefaultTrue
"guessRows":64-bit-integer

specifies the number of rows to scan in order to determine data types for variables.

Default20
Minimum value1
"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.

Default0
Minimum value0
"stripBlanks":True | False

removes leading and trailing blanks from character variables.

DefaultFalse
"varChars":True | False

when set to True, variable-length strings are used for character variables.

DefaultTrue
"vars":[{casvarcsvdesc-1} <, {casvarcsvdesc-2}, ...>]

specifies the names, types, formats, and other metadata for variables.

The casvarcsvdesc value can be one or more of the following:
"format":"string"

specifies the format to apply to the variable.

"formattedLength":integer

specifies the length of format field plus the format precision.

"informat":"string"

specifies the informat to apply to the variable.

"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.

Default8
Minimum value1
"name":"string"

specifies the name for the variable.

"nfd":integer

specifies the length of the format precision.

"nfl":integer

specifies the length of the format field.

"type":"BINARY" | "CHAR" | "DATE" | "DATETIME" | "DECQUAD" | "DECSEXT" | "DOUBLE" | "INT32" | "INT64" | "TIME" | "VARBINARY" | "VARCHAR"

specifies the data type for the variable.

DefaultDOUBLE

Parameters for fileType="DOCUMENT"

"fileExtList":["CSV", "DOC", "DOCX", "EPUB", "HTML", "KEY", "MBOX", "MSG", "NUMBERS", "ODP", "ODS", "ODT", "PAGES", "PDF", "PPT", "PPTX", "PST", "RTF", "TNEF", "TXT", "WPD", "XLS", "XLSX", "XML"]

specifies the file extensions for subsetting document selection.

"recurse":True | False

recursively import documents when the caslib definition permits access to subdirectories.

DefaultTrue
"tikaConv":True | False

specifies to convert the documents with the Apache Tika document conversion library.

DefaultFalse

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.

Default5
"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.

DefaultFalse

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.

DefaultTrue
"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":["string-1" <, "string-2", ...>]

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter.

"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.

Default0
Minimum value0
"parallelMode":"FALLBACK" | "FORCE" | "NONE"

specifies how the table is transferred from SAS LASR Analytic Server to SAS Cloud Analytic Services.

DefaultFALLBACK
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.

DefaultFalse
"varchars":True | False

when set to True, variable-length strings are used for character variables.

DefaultFalse
"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="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.

DefaultTrue
"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.

R Syntax

importOptions=list(fileType="AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "SPSS" | "XLS", fileType-specific-parameters)

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.

Default1
Range1–5
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"

specifies how data is transferred between the data source and SAS Cloud Analytic Services.

DefaultAUTO
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.

varcharConversion=double

specifies the number of bytes to use as a threshold. When a column with the CHAR data type has a length that is equal to or exceeds the specified number of bytes, the VARCHAR data type is used.

Default0
Range1–32767

Parameters for fileType="CSV"

allowTruncation=TRUE | FALSE

specifies that truncation of character data that is too long for a given field is allowed.

DefaultTRUE
delimiter="string"

specifies the character to use as the field delimiter.

Default","
encoding="string"

specifies the text encoding of the file. If you do not specify this parameter, then the session encoding is used.

Default"utf-8"
getNames=TRUE | FALSE

when set to True, the values in the first line of the file are used as variable names.

DefaultTRUE
guessRows=64-bit-integer

specifies the number of rows to scan in order to determine data types for variables.

Default20
Minimum value1
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.

Default0
Minimum value0
stripBlanks=TRUE | FALSE

removes leading and trailing blanks from character variables.

DefaultFALSE
varChars=TRUE | FALSE

when set to True, variable-length strings are used for character variables.

DefaultTRUE
vars=list( list(casvarcsvdesc-1) <, list(casvarcsvdesc-2), ...>)

specifies the names, types, formats, and other metadata for variables.

The casvarcsvdesc value can be one or more of the following:
format="string"

specifies the format to apply to the variable.

formattedLength=integer

specifies the length of format field plus the format precision.

informat="string"

specifies the informat to apply to the variable.

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.

Default8
Minimum value1
name="string"

specifies the name for the variable.

nfd=integer

specifies the length of the format precision.

nfl=integer

specifies the length of the format field.

type="BINARY" | "CHAR" | "DATE" | "DATETIME" | "DECQUAD" | "DECSEXT" | "DOUBLE" | "INT32" | "INT64" | "TIME" | "VARBINARY" | "VARCHAR"

specifies the data type for the variable.

DefaultDOUBLE

Parameters for fileType="DOCUMENT"

fileExtList=list("CSV", "DOC", "DOCX", "EPUB", "HTML", "KEY", "MBOX", "MSG", "NUMBERS", "ODP", "ODS", "ODT", "PAGES", "PDF", "PPT", "PPTX", "PST", "RTF", "TNEF", "TXT", "WPD", "XLS", "XLSX", "XML")

specifies the file extensions for subsetting document selection.

recurse=TRUE | FALSE

recursively import documents when the caslib definition permits access to subdirectories.

DefaultTRUE
tikaConv=TRUE | FALSE

specifies to convert the documents with the Apache Tika document conversion library.

DefaultFALSE

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.

Default5
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.

DefaultFALSE

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.

DefaultTRUE
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=list("string-1" <, "string-2", ...>)

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter.

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.

Default0
Minimum value0
parallelMode="FALLBACK" | "FORCE" | "NONE"

specifies how the table is transferred from SAS LASR Analytic Server to SAS Cloud Analytic Services.

DefaultFALLBACK
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.

DefaultFALSE
varchars=TRUE | FALSE

when set to True, variable-length strings are used for character variables.

DefaultFALSE
vars=list("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="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.

DefaultTRUE
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.

Last updated: June 07, 2018