Common Parameter: importOptions

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

specifies the Alter password for the SAS data set.

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.

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

specifies a password for encrypting or decrypting stored data.

specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.

specifies the Read password for the SAS data set.

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.

specifies the Write password for the SAS data set.

when set to True, line feed and carriage return characters are ignored when they are in a field that is enclosed in quotation marks. A line feed character has the ASCII value 10 and the carriage return character has a value of 13. Only the double quotation mark character (") is supported for ignoring the two characters. By default, loadTable will not check for new lines within quoted strings.

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

Specify compressed CSV archive type, valid archive types are 'gz' and 'zip'.

specifies the field delimiter. The delimiter can be a single 7-bit character, or 'TAB', or '^[@A-Z]', or one of [\\, \0, \a, \b, \t, \v, \f]. Multi-byte UTF-8 characters are not valid. The ^A value corresponds to the 0X01 that is commonly used with Apache Hive.

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

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

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

specifies the locale for interpreting data in the file

when set to True, the server attempts to load all CSV files from the specified path into a single in-memory table. The files must have the same number of columns and the same column data types.

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.

when set to True, path column/value pairs are added to table.

when set to True, quoted data are strings.

when set to True, the delimited file is read sequentially so that error messages from parsing can indicate the line number for the problem.

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

when this parameter and multiFile are set to True, each row includes a column that identifies the CSV file name that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified path, including the file name, to the CSV file that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified directory path to the CSV file that contributed the row.

removes leading and trailing blanks from character variables.

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

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

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.

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

when set to True, the sheet names are written to a CAS table.

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.

specifies the name of the worksheet to import.

specifies a file system path and filename. The file must be a SAS item store that includes the formats to import.

specifies the backing store to use for an in-memory table. If you specify a setting when you load one table, it overrides the setting for the caslib. If you specify a setting when you add a caslib, it applies to all tables in the caslib.

specifies a password for encrypting or decrypting stored data.

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

when set to True, the server attempts to determine the dimensions, resolution, and format of each file.

specifies the file extensions for subsetting the files to import.

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

specifies an expression for each computed variable that you include in the computedVars parameter.

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.

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.

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

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.

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

specifies the variables to use in the action.

specifies an expression for subsetting the input data.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

specifies the name of the worksheet to import.

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

specifies the Alter password for the SAS data set.

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.

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

specifies a password for encrypting or decrypting stored data.

specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.

specifies the Read password for the SAS data set.

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.

specifies the Write password for the SAS data set.

when set to True, line feed and carriage return characters are ignored when they are in a field that is enclosed in quotation marks. A line feed character has the ASCII value 10 and the carriage return character has a value of 13. Only the double quotation mark character (") is supported for ignoring the two characters. By default, loadTable will not check for new lines within quoted strings.

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

Specify compressed CSV archive type, valid archive types are 'gz' and 'zip'.

specifies the field delimiter. The delimiter can be a single 7-bit character, or 'TAB', or '^[@A-Z]', or one of [\\, \0, \a, \b, \t, \v, \f]. Multi-byte UTF-8 characters are not valid. The ^A value corresponds to the 0X01 that is commonly used with Apache Hive.

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

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

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

specifies the locale for interpreting data in the file

when set to True, the server attempts to load all CSV files from the specified path into a single in-memory table. The files must have the same number of columns and the same column data types.

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.

when set to True, path column/value pairs are added to table.

when set to True, quoted data are strings.

when set to True, the delimited file is read sequentially so that error messages from parsing can indicate the line number for the problem.

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

when this parameter and multiFile are set to True, each row includes a column that identifies the CSV file name that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified path, including the file name, to the CSV file that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified directory path to the CSV file that contributed the row.

removes leading and trailing blanks from character variables.

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

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

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.

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

when set to True, the sheet names are written to a CAS table.

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.

specifies the name of the worksheet to import.

specifies a file system path and filename. The file must be a SAS item store that includes the formats to import.

specifies the backing store to use for an in-memory table. If you specify a setting when you load one table, it overrides the setting for the caslib. If you specify a setting when you add a caslib, it applies to all tables in the caslib.

specifies a password for encrypting or decrypting stored data.

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

when set to True, the server attempts to determine the dimensions, resolution, and format of each file.

specifies the file extensions for subsetting the files to import.

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

specifies an expression for each computed variable that you include in the computedVars parameter.

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.

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.

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

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.

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

specifies the variables to use in the action.

specifies an expression for subsetting the input data.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

specifies the name of the worksheet to import.

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

specifies the Alter password for the SAS data set.

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.

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

specifies a password for encrypting or decrypting stored data.

specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.

specifies the Read password for the SAS data set.

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.

specifies the Write password for the SAS data set.

when set to True, line feed and carriage return characters are ignored when they are in a field that is enclosed in quotation marks. A line feed character has the ASCII value 10 and the carriage return character has a value of 13. Only the double quotation mark character (") is supported for ignoring the two characters. By default, loadTable will not check for new lines within quoted strings.

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

Specify compressed CSV archive type, valid archive types are 'gz' and 'zip'.

specifies the field delimiter. The delimiter can be a single 7-bit character, or 'TAB', or '^[@A-Z]', or one of [\\, \0, \a, \b, \t, \v, \f]. Multi-byte UTF-8 characters are not valid. The ^A value corresponds to the 0X01 that is commonly used with Apache Hive.

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

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

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

specifies the locale for interpreting data in the file

when set to True, the server attempts to load all CSV files from the specified path into a single in-memory table. The files must have the same number of columns and the same column data types.

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.

when set to True, path column/value pairs are added to table.

when set to True, quoted data are strings.

when set to True, the delimited file is read sequentially so that error messages from parsing can indicate the line number for the problem.

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

when this parameter and multiFile are set to True, each row includes a column that identifies the CSV file name that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified path, including the file name, to the CSV file that contributed the row.

when this parameter and multiFile are set to True, each row includes a column that identifies the fully-qualified directory path to the CSV file that contributed the row.

removes leading and trailing blanks from character variables.

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

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

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.

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

when set to True, the sheet names are written to a CAS table.

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.

specifies the name of the worksheet to import.

specifies a file system path and filename. The file must be a SAS item store that includes the formats to import.

specifies the backing store to use for an in-memory table. If you specify a setting when you load one table, it overrides the setting for the caslib. If you specify a setting when you add a caslib, it applies to all tables in the caslib.

specifies a password for encrypting or decrypting stored data.

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

when set to True, the server attempts to determine the dimensions, resolution, and format of each file.

specifies the file extensions for subsetting the files to import.

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

specifies an expression for each computed variable that you include in the computedVars parameter.

specifies the names of the computed variables to create. Specify an expression for each variable in the computedVarsProgram parameter. If you do not specify this parameter, then all variables from computedVarsProgram are automatically included.

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.

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

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.

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

specifies the variables to use in the action.

specifies an expression for subsetting the input data.

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

when set to False, the server does not load the contents of the files into a column in the output table. This can be useful to determine the number of files and file types. By default, the contents of the files are loaded into a column.

specifies the file extensions for subsetting the files to import.

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

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

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.

specifies the name of the worksheet to import.