Methods Listed Alphabetically

A B C D E F G H I K L M N O P R S T V W

Name
Syntax and Description
package.ABORT( );
Stops the execution of the HTTP method.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package.ABS( );
Returns a matrix that contains the absolute value of each value in the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ADD();
package.ADD(\[keys\], \[data\]);
package.ADD(\[keys\]);
Adds key values, data values, or both to the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.ADD(package-2);
Adds one matrix to another.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ADDREQUESTHEADER('name', 'value');
Adds a header to the HTTP method request.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ADDSASOAUTHTOKEN( );
Searches the SAS environment for an OAuth access token. If a token is found, it is set as the OAuth token for the request.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_AND(package-2);
Produces a scalar result in an ALL_AND comparison between all elements in one matrix and all elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_EQ(package-2);
Produces a scalar result in an ALL_EQ (ALL equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_GE(package-2);
Produces a scalar result in an ALL_GE (ALL greater-than-or-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_GT(package-2);
Produces a scalar result in an ALL_GT (ALL greater-than) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_LE(package-2);
Produces a scalar result in an ALL_LE (ALL less-than-or-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_LT(package-2);
Produces a scalar result in an ALL_LT (ALL less-than) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_NE(package-2);
Produces a scalar result in an ALL_NE (ALL not-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ALL_OR(package-2);
Produces a scalar result in an ALL_OR comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.AND(package-2);
Compares two matrices based on the AND logical operation, and returns the resulting matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_AND(package-2);
Produces a scalar result in an ANY_AND comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_EQ(package-2);
Produces a scalar result in an ANY_EQ (ANY equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_GE(package-2);
Produces a scalar result in an ANY_GE (ANY greater-than-or-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_GT(package-2);
Produces a scalar result in an ANY_GT (ANY greater-than) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_LE(package-2);
Produces a scalar result in an ANY_LE (any less-than-or-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_LT(package-2);
Produces a scalar result in an ANY_LT (ANY less-than) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_NE(package-2);
Produces a scalar result in an ANY_NE (ANY not-equal-to) comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.ANY_OR(package-2);
Produces a scalar result in an ANY_OR comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.APPEND(dgSource | JSON_string);
Appends the specified source data grid to the specified target data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
returnCode=package.APPLY(IN_OUT subjectString, <numberOfTimes>);
Applies the substitution expression, provided at instantiation time, to the loaded subject data.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
AUDIO (FILE:'path' | 'FILEREFfileref'
<, TYPE: 'audio-type',><audio-control-option-1><,audio-control-option-2, ...>);
Embeds audio into HTML5 or EPUB output.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.BINDPARAMETERS ([parameter-variable-list]);
Binds a list of variables to the parameters in the FedSQL statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BINDRESULTS (parameter-variable-list);
Binds a list of variables to the columns of the result set of the FedSQL statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
BODY_END( );
Specifies the end of the body section of the table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
BODY_START(<option-1><,option-2, ...>);
Specifies the start of the body section of the table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.BOTTOMN(dgSource, col, N);
Sorts the target data grid in ascending order, by the specified column, and then truncates it to the first N rows.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTADDROW();
Adds a row of data for bulk insertion.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTBINDCOLUMNS(variable-list);
Binds a list of variables to the columns that are selected for bulk insertion.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTFLUSH();
Flushes all the rows in the bulk insertion row buffer.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTGETCOLUMNCOUNT();
Returns the number of columns that are selected for bulk insertion.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTGETCOLUMNNAME(index);
package.BULKINSERTGETCOLUMNNAME(index,variable,rc);
Returns the column name for the bulk insertion column at the specified index.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTGETCOLUMNTYPENAME(index);
package.BULKINSERTGETCOLUMNTYPENAME(index,variable,rc);
Returns the type name of the bulk insertion column at the specified column index.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTISPREPARED();
Returns a value that indicates whether the SQLSTMT package instance is prepared for bulk insertion.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.BULKINSERTPREPARE(select-string<, connection-string>);
Prepares an SQLSTMT package instance for a bulk insertion.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
CELL_END( );
Specifies the end of a cell.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
CELL_START(<option-1><,option-2, ...>);
Specifies the start of a cell.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.CHECK( );
package.CHECK(\[keys\]);
Checks whether the specified key is stored in the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CLEAR( );
Removes all items from a hash package without deleting the hash package instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CLEAR();
Deletes all rows and all column metadata from the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CLEARDATA();
Deletes all rows from the specified data grid but does not remove the column metadata.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CLOSERESULTS( );
Releases the result set from the last execution of the statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable-name=package.COLS( );
Returns the number of columns in the specified matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNADD(colName, typeName);
Adds a column of specified type to the target data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNADDCHARTYPE(colName);
Adds a character column to the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNADDNUMTYPE(colName);
Adds a numeric column of type decimal to the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCLEAR(col, <rowStartIndex, rowEndIndex>);
Clears all the rows in a data grid column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCORR(col1, col2 <, rowStartIndex, rowEndIndex>);
Returns the Pearson correlation coefficient of the two specified columns.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNT();
Returns the number of columns in the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNTMATCH(cmpCol, operator, cmpValue);
Returns the number of rows that match the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNTMATCHBYFILTER(filter <, varList>);
package.COLUMNCOUNTMATCHBYFILTER(filter, rowStartIndex, rowEndIndex <, varList>);
Returns the number of rows that match the specified criteria. This criteria is defined by a filter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNTMATCHIN(cmpColumn, cmpOperator, inDatagrid <, rowStartIndex, rowEndIndex>);
Returns the number of matching rows in the specified column for which the comparison operation evaluates to true. Multiple values are used as the comparator in the operation. These values are defined in the first column of the data grid that is specified for the inDatagrid argument.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNTMISSING(col <, rowStartIndex, rowEndIndex>);
Returns the number of missing values for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNCOUNTVALID(col <, rowStartIndex, rowEndIndex>);
Returns the number of valid nonmissing numeric values for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNDELETE(col);
Deletes the specified column from the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNEXISTS(colName);
Returns 1 (true) if the specified column exists. Otherwise, returns 0 (false).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNIDEX(colName);
Returns the ordinal position of the specified column name.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNISNUMERIC(col);
Returns 1 (true) if the specified column is a numeric data type. Otherwise, returns 0 (false).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMAX(col <, rowStartIndex, rowEndIndex>);
Returns the maximum value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMAXBOOL(col <, rowStartIndex, rowEndIndex>);
Returns the maximum Boolean value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMAXINT(col <, rowStartIndex, rowEndIndex>);
Returns the maximum integer value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMAXSTRING(col <, rowStartIndex, rowEndIndex>);
Returns the maximum string value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMEAN(col <, rowStartIndex, rowEndIndex>);
Returns the mean value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMEDIAN(col <, rowStartIndex, rowEndIndex>);
Returns the median value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMIN(col <, rowStartIndex, rowEndIndex>);
Returns the minimum value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMINBOOL(col < , rowStartIndex, rowEndIndex >);
Returns the minimum Boolean value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMININT(col <, rowStartIndex, rowEndIndex>);
Returns the minimum integer value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMINLONG(col <, rowStartIndex, rowEndIndex>);
Returns the minimum long value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNMINSTRING(col <, rowStartIndex, rowEndIndex>);
Returns the minimum string value for the specified criteria.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNNAME(colIndex);
Returns the name of the column that is in the one-based ordinal position.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNRENAME(col, newName)
Renames the specified column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNSTDDEV(col <, rowStartIndex, rowEndIndex>);
Returns the standard deviation of the values in the specified column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNSUM(col);
Returns the sum of DOUBLE values in the specified column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNSUMLONG(col);
Returns the sum of LONG values in the specified column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COLUMNTYPENAME(colName);
Returns the type name of the specified column name.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.CONNECT ([[host | resource-config] [, port ]]);
Connects to the Redis server.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package.COPY( );
Copies one matrix to another.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.COPY(dgSource);
Creates a duplicate of the source data grid into the target data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CREATEGETMETHOD {( ) | ('url')};
Creates an HTTP GET method to retrieve a resource from a web server.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CREATEHEADMETHOD{( ) | ('url')};
Creates an HTTP HEAD method to test whether a web resource exists and to retrieve its headers.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CREATEPARSER ( );
package.CREATEPARSER (json-text, tipping-size);
package.CREATEPARSER (json-text);
package.CREATEPARSER (tipping-size);
Creates a JSON Parser instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CREATEPOSTMETHOD {( ) | ('url')};
Creates an HTTP POST method to request the web server to accept data for a resource.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.CREATEWRITER (<PRETTY>);
Creates a JSON writer instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DATA(\[data\]);
Specifies the data variables to be stored in the hash package by using a variable list.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DATASET([']data-source['] | '\{sql-text\}' );
Specifies the name of a table to load into the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DEFINEDATA('data');
Defines data variables for the hash package using implicit variables.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DEFINEDONE( );
Indicates that all key and data definitions are complete.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DEFINEKEY('key');
Defines key variables for the hash package using implicit variables.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
DELETE( );
Deletes an instance of a class.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.DELETE( );
Deletes an FCMP package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes a hash or hash iterator package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes an HTTP package instance and frees its resources.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes a JSON package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes a logger package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes a matrix package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DELETE( );
Deletes an instance of the SQLSTMT package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.DELETEKEY (key);
Removes the specified key.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DESERIALIZE(JSON_string);
Creates a data grid from the specified JSON string.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DESTROYPARSER ( );
Destroys a JSON Parser instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DESTROYWRITER ( );
Destroys a JSON writer instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
d=package.DET( );
Computes the determinant of a square matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.DISCONNECT();
Disconnects from the Redis server.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DISTINCTCOUNT();
Returns the number of unique rows in the data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.DUPLICATE('option');
Determines whether to ignore duplicate keys when loading a table into the hash package. The default is to store the first key and ignore all subsequent duplicates.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.EDIV(package-2);
Performs an elementwise scalar division.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.EMAX(package-2);
Performs an elementwise comparison of two matrices and returns the largest elements.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.EMIN(package-2);
Performs an elementwise comparison of two matrices and returns the smallest elements.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.EMOD(package-2);
Returns the remainder of the division of elements of the first matrix by elements of the second matrix in an elementwise scalar operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.EMULT(package-2);
Performs an elementwise scalar multiplication.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
x=package-1.EPOW(package-2);
Raises a number to a specified power in an elementwise operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.EQ(package-2);
Produces a scalar result in an equal-to comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.EXECUTE( );
Executes the FedSQL statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.EXECUTEMETHOD( );
Executes the HTTP method and enables retrieval of the response body as a complete entity.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.EXECUTEMETHODSTREAM( );
Executes the HTTP method and enables streaming of the response body from the HTTP server.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.EXISTS (key, isSet);
Determines whether a specified key exists.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package.EXP( );
Returns a matrix that contains an exponential value for each value in the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FETCH ([result-variable-list]);
Fetches the next row of data from the result set of the FedSQL statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDCOMPARE(cmpColName, operator, cmpValue, cmpRowIndex);
Returns the value of a compare on a specific column and row value in the datagrid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGET(cmpCol, operator, cmpValue, srcCol <, rowStartIndex, rowEndIndex>);
Returns the value of the first row in the source column for which the comparison operation evaluates to true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGETBYFILTER(filter, srcColName <, varList>);
package.FILTEREDGETBYFILTER(filter, srcColName, rowStartIndex, rowEndIndex <, varList>);
Returns the value of the first row in the source column for which the comparison operation evaluates to true. The comparison operation is defined using a filter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGETIN(cmpColumn, cmpOperator, inDatagrid, srcCol <, rowStartIndex, rowEndIndex>);
Returns the value of the first row in the source column for which the comparison operation evaluates to true. Multiple values are used as the comparator in the operation. These values are defined in the first column of the data grid that is specified for the inDatagrid argument.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGETINDEX(cmpCol, operator, cmpValue <, rowStartIndex, rowEndIndex>);
Returns the index of the first row for which the comparison operation evaluates to true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGETINDEXBYFILTER(filter <, varList>);
package.FILTEREDGETINDEXBYFILTER(filter, rowStartIndex, rowEndIndex <, varList>);
Returns the index of the first row for which the comparison operation evaluates to true. The comparison operation is defined using a filter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDGETINDEXIN(cmpColumn, cmpOperator, inDatagrid <, rowStartIndex, rowEndIndex>);
Returns the index of the first row for which the comparison operation evaluates to true. Multiple values are used as the comparator in the operation. These values are defined in the first column of the data grid that is specified for the inDatagrid argument.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDSET(cmpCol, operator, cmpValue, rowIndex, setCol, setValue);
Sets the value in the specified column to the specified value if the comparison evaluates to true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDSETALL(cmpCol, operator, cmpValue, setCol, setValue);
Sets the cell in the specified column to the specified value if the specified comparison evaluates to true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDSETALLBYFILTER(filter, setColName, setValue <, varList>);
Sets the cell in the specified column to the specified value if the specified comparison evaluates to true. The comparison operation is defined using a filter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FILTEREDSETBYFILTER(filter, rowIndex, setColName, setValue <, varList>);
Sets the value in the specified column to the specified value if the comparison evaluates to true. The comparison operation is defined using a filter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FIND( );
package.FIND(\[keys\], \[data\]);
package.FIND(\[keys\]);
Determines whether the specified key is stored in the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FIND_NEXT( );
package.FIND_NEXT(\[data\]);
Sets the current list item to the next item in the current key's multiple item list and sets the data for the corresponding data variables.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FIND_PREV( );
package.FIND_PREV(\[data\]);
Sets the current list item to the previous item in the current key's multiple item list and sets the data for the corresponding data variables.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FIRST( );
package.FIRST(\[data\]);
Returns the first value in the underlying hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package.FLOOR( );
Returns a matrix that contains the integer part of each value in the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
FOOT_END( );
Specifies the end of the footer section of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
FOOT_START(<option-1><,option-2, ...>);
Specifies the start of the footer section of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
FOOTNOTE(DATA:'displayed-data' <,option-1><,option-2, ...>);
Adds a footnote to the page.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
FORMAT_CELL(DATA:'displayed-data' <,option-1><,option-2, ...>);
Formats the contents of a cell.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
FORMAT_TEXT(DATA:'displayed-data' <,option-1><,option-2, ...>);
Writes text to the active output destination(s).
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.FULLJOIN(dgLeft, colLeft, dgRight, colRight);
package.FULLJOIN(dgLeft, dgRight, dgJoin);
Performs a full join of two data grids and populates the target data grid with the results of the join.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.FULLJOINBYFILTER(dgLeft, dgRight, keepColumns, filter <, varList>);
Performs a full join of two data grids and populates the target data grid with the results of the join. The target column and source row criteria are specified using a column keep clause and a row filter definition.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.FULLJOINCOUNT(colLeft, dgRight, colRight);
dgLeft.FULLJOINCOUNT(dgRight, dgJoin);
Returns the number of rows that would be produced by a full join operation. No data grid is affected by this operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.FULLJOINCOUNTBYFILTER(dgRight, filter < , varList>);
Returns the number of rows that would be produced by a full join operation. The source row criteria is specified using a row filter definition. No data grid is affected by this operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.GE(package-2);
Produces a scalar result in a greater-than-or-equal-to comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETBIGINT (index);
package.GETBIGINT (index, variable, rc);
Returns the value of the designated result set column as type BIGINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.GETBINARY (key, variable);
Gets the specified binary key and its assigned value.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETBOOL(col, rowIndex);
Returns the Boolean value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETCHAR (index);
package.GETCHAR (index, variable, rc);
Returns the designated result set column as type CHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETCOLUMNCOUNT();
Returns the number of columns in the result set.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETCOLUMNNAME(index);
package.getColumnName(index, variable, rc);
Returns the column name of the result set column with the designated index.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETCOLUMNTYPENAME(index);
package.getColumnTypeName(index, variable, rc);
Returns the data type of the result set column with the designated index.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETDATE (index);
package.GETDATE (index, variable, rc);
Returns the designated result set column as type DATE.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETDECIMAL (index);
package.GETDECIMAL (index, variable, rc);
Returns the designated result set column as type DECIMAL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETDOUBLE(col, rowIndex);
Returns the decimal value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
returnCode=package.GETGROUP (IN_OUT resultString, groupNumber);
Stores the text represented by the given capture group based on the previous match into the user-supplied resultString.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
ending-index=package.GETGROUPEND (groupNumber) returns int;
Returns the ending index of the given capture group.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
length=package.GETGROUPLENGTH (groupNumber);
Returns the length of the given capture group's text in characters.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
starting-index=package.GETGROUPSTART (groupNumber);
Returns the starting index of the given capture group.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETINT(col, rowIndex);
Returns the integer value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETINTEGER (index);
package.GETINTEGER (index, variable, rc);
Gets the designated result set column as type INTEGER.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETLOCALTIME (<time-zone-ID>);
Returns current local time.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETLONG(col, rowIndex);
Returns the long value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
returnCode=package.GETMATCH (IN_OUT resultString);
Places the text of the previous match into the result string.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
ending-index=package.GETMATCHEND();
Returns the next position after the end of the text from the previous match.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
length=package.GETMATCHLENGTH ();
Returns the number of characters of the previous match.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
starting-index=package.GETMATCHSTART();
Returns the starting index of the previous match operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETNCHAR (index);
package.GETNCHAR (index, variable, rc);
Gets the designated result set column as type NCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETNEXTTOKEN (rc, token-type, parse-flags);
package.GETNEXTTOKEN (rc, token, token-type, parse-flags);
package.GETNEXTTOKEN (rc, token, token-type, parse-flags, line-number,
column-number);
Returns the next validated JSON language item or element from the JSON text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETNUMERIC (index);
package.GETNUMERIC (index, variable, rc);
Returns the designated result set column as type NUMERIC.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETNVARCHAR (index);
package.GETNVARCHAR (index, variable, rc);
Returns the designated result set column as type NVARCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETOFFSET ( );
variable=package.GETOFFSET (local-time);
variable=package.GETOFFSET (time-zone-ID);
variable=package.GETOFFSET (local-time, time-zone-ID);
Returns the time zone offset of the time zone from Universal Coordinated Time (UTC) at the specified local time. If local time is not specified, current local time is used.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETOFFSETUTC (UTC-time, time-zone-ID);
Returns the time zone offset of the time zone from UTC at the specified UTC time.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETREAL (index);
package.GETREAL (index, variable, rc);
Returns the designated result set column as type REAL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETRESPONSEBODYASBINARY(variable, rc);
Returns the entire body from the HTTP response in binary format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETRESPONSEBODYASSTRING(variable, rc);
Returns the entire body from the HTTP response in character string format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
content-type-variable=package.GETRESPONSECONTENTTYPE( );
Returns the content type from the HTTP response.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETRESPONSEHEADERSASSTRING(variable, rc);
Returns the response headers from the HTTP method in character string format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETSMALLINT (index);
package.GETSMALLINT (index, variable, rc);
Returns the designated result set column as type SMALLINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
status-code-variable=package.GETSTATUSCODE( );
Returns the HTTP status code from the most recently executed HTTP method.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETSTRING(col, rowIndex);
Returns the string value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETTIME (index);
package.GETTIME (index, variable, rc);
Returns the designated result set column as type TIME.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETTIMESTAMP (index);
package.GETTIMESTAMP (index, variable, rc);
Returns the designated result set column as type TIMESTAMP.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETTIMEZONEID ( );
Returns the current time zone ID.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETTIMEZONENAME ( );
Returns the current time zone name.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETTINYINT (index);
package.GETTINYINT (index, variable, rc);
Returns the designated result set column as type TINYINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETUTCTIME ( );
Returns the current UTC time.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.GETVALUE(col, rowIndex);
Returns the value of the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETVARBINARY (index);
package.GETVARBINARY (index, variable, rc);
Returns the designated result set column as type VARBINARY.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.GETVARCHAR (index);
package.GETVARCHAR (index, variable, rc);
Returns the designated result set column as type VARCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.GT(package-2);
Produces a scalar result in a greater-than comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.HAS_NEXT( );
Determines whether there is a next item in the current key's multiple data item list.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.HAS_PREV( );
Determines whether there is a previous item in the current key's multiple data item list.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.HASHEXP(exponent);
Defines the hash package’s internal table size. The size of the hash table is 2 .
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
HEAD_END( );
Specifies the end of the header section of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
HEAD_START(<option-1><,option-2, ...>);
Specifies the start of the header section of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
rc=package.HGET (key, field, variable);
Retrieves the value associated with the field in the hash that is stored at the specified key.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.HGETALL (key, datagrid);
Retrieves all fields and values of the hash that is stored at the specified key, and then appends them to the given datagrid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.HGETSUBSET (key, datagrid);
Adds a row to the given datagrid. Then, for each field in the hash that matches a column in the datagrid, adds the corresponding value to the newly added datagrid row.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
HREF (DATA: 'displayed-data', URL:'data-path' <,option-1> <,option-2, ...>);
Creates a link.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
rc=package.HSET (key, field, value);
Sets the specified fields to their respective values in the hash stored at the specified key.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
IMAGE (FILE:"FILEREF:fileref" | "filename"<,option-1> <,option-2, ...>);
Inserts an image into all open output destinations.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.IN(array-name);
Loads an array into a matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
METHOD INIT( );
END;
Calls a DS2 system method where program initializations can take place.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.INNERJOIN(dgLeft, colLeft, dgRight, colRight);
package.INNERJOIN(dgLeft, dgRight, dgJoin);
Performs an inner join of two data grids and populates the target data grid with the results of the join.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.INNERJOINBYFILTER(dgLeft, dgRight, keepColumns, filter <, varList>);
Performs an inner join of two data grids and populates the target data grid with the results of the join. The target column and source row criteria are specified using a column keep clause and a row filter definition.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.INNERJOINCOUNT(colLeft, dgRight, colRight);
dgLeft.INNERJOINCOUNT(dgRight, dgJoin);
Returns the number of rows that would be produced by an inner join operation. No data grid is affected.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.INNERJOINCOUNTBYFILTER(dgRight, filter <, varList>);
Returns the number of rows that would be produced by an inner join operation. The source row criteria is specified using a row filter definition. No data grid is affected by this operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
im=matrix-package.INVERSE( );
Computes the inverse of a matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISBOOLEANFALSE(token-type);
Returns true if the token is false.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISBOOLEANTRUE(token-type);
Returns true if the token is true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISFLOAT(token-type, parse-flags);
Returns true if the token is a floating point number in text form.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISINTEGER (token-type, parse-flags);
Returns true if the token is an integer in text form.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISLABEL(token-type, parse-flags);
Returns true if the token is an object label.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISLEFTBRACE(token-type);
Returns true if the token is a left brace ( { ).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISLEFTBRACKET(token-type);
Returns true if the token is a left bracket ( [ ).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISLEVELACTIVE(<'>level<'>);
Returns a value that indicates whether the logger package that is associated with the logger name suppresses a message at the logger level.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISNULL(token-type);
Returns true if the token is null.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISNUMERIC(token-type);
Returns true if the token is numeric in text form.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISPARTIAL(parse-flags);
Returns true if the token is incomplete because of tipping.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISPREPARED( );
Returns a value that indicates whether the SQLSTMT package instance is prepared.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISRIGHTBRACE(token-type);
Returns true if the token is a right brace ( } ).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISRIGHTBRACKET(token-type);
Returns true if the token is a right bracket ( ] ).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ISSTRING(token-type);
Returns true if the token is a string.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.KEYS(\[keys\]);
Defines the key variables for the hash package using a variable list.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.LAST( );
package.LAST(\[data\]);
Returns the last value in the underlying hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
LAYOUT_ABSOLUTE(<option-1><,option-2, ...>);
Creates an absolute layout container. The LAYOUT_ABSOLUTE method enables you to specify the exact location on a page for your regions and is limited to one page of layout.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
LAYOUT_END( );
Ends a gridded or absolute layout block.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
LAYOUT_GRIDDED(<option-1><,option-2, ...>);
Creates a gridded layout container. The LAYOUT_GRIDDED method enables you to arrange output in a two-dimensional gridded structure such as a spreadsheet or a piece of graph paper.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
r=package-1.LE(package-2);
Produces a scalar result in a less-than-or-equal-to comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.LEFTJOIN(dgLeft, colLeft, dgRight, colRight);
package.LEFTJOIN(dgLeft, dgRight, dgJoin);
Performs a left join of two data grids and populates the target data grid with the results of the join.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.LEFTJOINBYFILTER(dgLeft, dgRight, keepColumns, filter <, varList>);
Performs a left join of two data grids and populates the target data grid with the results of the join. The target column and source row criteria are specified using a column keep clause and a row filter definition.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.LEFTJOINCOUNT(colLeft, dgRight, colRight);
dgLeft.LEFTJOINCOUNT(dgRight, dgJoin);
Returns the number of rows that would be produced by a left join operation. No data grid is affected.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.LEFTJOINCOUNTBYFILTER(dgRight, filter<, varList>);
Returns the number of rows that would be produced by a left join operation. The source row criteria is specified using a row filter definition. No data grid is affected by this operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
LINE(<option-1><,option-2, ...>);
Inserts a horizontal rule (line) across the page.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.LOG(<'>level<'>, 'raw-message');
package.LOG(<'>level<'>, <message-format>'argument-1' <..., argument-9>);
Send the specified message to the logger at the specified level.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package.LOG( );
Returns a matrix that contains the natural logarithm for each value in the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=package-1.LT(package-2);
Produces a scalar result in a less-than comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
returnCode=package.MATCH ( VARCHAR subjectString, <offset-index>) returns int;
Performs a match operation using the previously parsed regular expression.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package-1.MULT(matrix-package-2);
Multiplies one matrix by another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.MULTIDATA(['option']);
Specifies whether multiple data items are allowed for each key.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.NAME();
Returns the name that is given at the declaration of the data grid instance.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package-1.NE(matrix-package-2);
Produces a scalar result in a not-equal-to comparison between elements in one matrix and elements in another matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.NEXT( );
package.NEXT(\[data\]);
Returns the next value in the underlying hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
NOTE(DATA:'displayed-data' <,option-1><,option-2, ...>);
Writes a note to the active output destination(s).
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
r=matrix-package-1.OR(matrix-package-2);
Compares two matrices based on the OR logical operation, and returns the resulting matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ORDERED('option');
Specifies whether or how the data is returned in key-value order if you use the hash package with a hash iterator package or if you use the hash package OUTPUT method.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
matrix-package.OUT(array-name);
Writes matrix row data to a variable array.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.OUTPUT ([']output-table['] );
Creates a table that contains the data in the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
PAGE( );
Creates a page break.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
returnCode=pcrxfind-package.PARSE (pcrxfind-expression);
Compiles a Perl-compatible regular expression that can be used for pattern matching.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
returnCode=pcrxreplace-package.PARSE (pcrxreplace-expression);
Compiles a Perl-compatible regular expression that can be used for pattern matching.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
PREPARE ('sql-text' );
Prepares a FedSQL statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.PREV( );
package.PREV(\[data\]);
Returns the previous value in the underlying hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REF( );
package.REF(\[keys\], \[data\]);
package.REF(\[keys\]);
Consolidates a FIND and ADD methods into a single method call.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
REGION(<option-1><,option-2, ...>);
Creates a region container for absolute layouts.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
REGION(<option-1><,option-2, ...>);
Creates a region container for gridded layouts.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
REGISTEROUTPARAMETER (index)
Registers the designated parameter as an output parameter.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REMOVE( );
package.REMOVE(\[keys\]);
Removes the data that is associated with the specified key from the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REMOVEALL();
package.REMOVEALL(\[keys\]);
Removes the data that is associated with all keys from the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REMOVEDUP( );
Removes the data that is associated with the current key’s current data item from the hash package.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REPLACE( );
package.REPLACE(\[keys\], \[data\]);
package.REPLACE(\[keys\]);
Replaces the data that is associated with the specified key with new data.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.REPLACEDUP( );
Replaces the data that is associated with the current key's current data item with new data.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.RIGHTJOIN(dgLeft, colLeft, dgRight, colRight);
package.RIGHTJOIN(dgLeft, dgRight, dgJoin);
Performs a right join of two data grids and populates the target data grid with the results of the join.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.RIGHTJOINBYFILTER(dgLeft, dgRight, keepColumns, filter <, varList>);
Performs a right join of two data grids and populates the target data grid with the results of the join. The target column and source row criteria are specified using a column keep clause and a row filter definition.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.RIGHTJOINCOUNT(colLeft, dgRight, colRight);
dgLeft.RIGHTJOINCOUNT(dgRight, dgJoin);
Returns the number of rows that would be produced by a right join operation. No data grid is affected.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
dgLeft.RIGHTJOINCOUNTBYFILTER(dgRight, filter <, varList>);
Returns the number of rows that would be produced by a right join operation. The source row criteria is specified using a row filter definition. No data grid is affected by this operation.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
ROW_END( );
Specifies the end of a row.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
ROW_START(<option-1><,option-2, ...>);
Specifies the beginning of a row.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.ROWADD(n);
Appends the specified number of rows to the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ROWCOUNT();
Returns the number of rows in the data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.ROWDELETE(rowStartIndex <, rowEndIndex>);
Deletes the specified rows from the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable-name=matrix-package.ROWS( );
Returns the number of rows in the specified matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
METHOD RUN( );
END;
Calls a DS2 system method where DS2 program code can run in an implicit loop.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.SELECT ([logicalDB]);
Selects the logical database with the specified zero-based numeric index.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SERIALIZE();
package.SERIALIZE(length, jsonString);
Returns the JSON string of the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SERIALIZEDATA();
package.SERIALIZEDATA(length, jsonString);
Returns the JSON string of the row data of the specified data grid. The column metadata is not included.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SERIALIZEMETADATA();
package.SERIALIZEMETADATA(length, jsonString);
Returns the JSON string of the column metadata of the specified data grid. The row data is not included.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETALL(col, setValue);
Sets all the values of a column to the specified value.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETBIGINT (index, value);
Sets the designated parameter to the specified value of type BIGINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
rc=package.SETBINARY (key, value [,options [, option_value]]);
Sets a binary value.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETBOOL(col, rowIndex, setValue);
Sets the specified Boolean value to the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETCHAR (index, value);
Sets the designated parameter to the specified value of type CHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETCUR( );
package.SETCUR(\[keys\], \[data\]);
Specifies a starting key item for iteration.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETDATE (index, value);
Sets the designated parameter to the specified value of type DATE.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETDECIMAL (index, value);
Sets the designated parameter to the specified value of type DECIMAL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETDOUBLE(col, rowIndex, setValue);
Sets the specified decimal value to the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETINT(col, rowIndex, setValue);
Sets the specified integer value to the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETINTEGER (index, value);
Sets the designated parameter to the specified value of type INTEGER.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETLONG(col, rowIndex, setValue);
Sets the specified long value (64-bit integer) to the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETNAME(newName);
Renames the specified data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETNCHAR (index, value);
Sets the designated parameter to the specified value of type NCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETNUMERIC (index, value);
Sets the designated parameter to the specified value of type NUMERIC.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETNVARCHAR (index, value);
Sets the designated parameter to the specified value of type NVARCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETOAUTHTOKEN('variable');
Specifies a string that contains the OAuth access token for the request.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
thread.SETPARMS(parameter-value<, ...parameter-value>);
Initializes parameters for an instance of a DS2 thread.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETPARSERINPUT(<json-text,>);
Provides JSON text to the parser when it needs more text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETPASSWORD('variable');
Specifies the string that represents the password associated with the specified user name.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETPROXYPASSWORD('variable');
Specifies the string that represents the password associated with the specified proxy user name.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETPROXYURL('variable');
Specifies the proxy URL to which the HTTP client should connect.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETPROXYUSERNAME('variable');
Specifies the string that represents the domain-qualified user name of the user who is attempting to connect to the specified proxy URL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETREAL (index, value);
Sets the designated parameter to the specified value of type REAL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETREQUESTBODYASBINARY(variable);
Adds the specified body to the HTTP method request in binary format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETREQUESTBODYASSTRING(variable);
Adds the specified body to the HTTP method request in character string format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETREQUESTBODYCHARACTERSET('variable');
Specifies the character set to use when encoding the request body.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETREQUESTCONTENTTYPE(content-type);
Specifies the content type of the body of the HTTP method request.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETRESPONSEBODYCHARACTERSET('variable');
Specifies the character set to use when decoding the response body.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETSMALLINT (index, value);
Sets the designated parameter to the specified value of type SMALLINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETSOCKETTIMEOUT(time-out-value);
Specifies the socket time-out value to wait for a response from an HTTP web server.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETSTRING(col, rowIndex, setValue);
Sets the specified string value to the cell in the specified row and column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETTIME (index, value);
Sets the designated parameter to the specified value of type TIME.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETTIMESTAMP (index, value);
Sets the designated parameter to the specified value of type TIMESTAMP.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETTINYINT (index, value);
Sets the designated parameter to the specified value of type TINYINT.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETURL('variable');
Specifies the URL to which the HTTP client should connect.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETUSERNAME('variable');
Specifies the string that represents the domain-qualified user name of the user who is attempting to connect to the specified URL.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETVALUE(col, rowIndex, setValue);
Sets the specified value to the cell in the specified row and column. This is supported only for column types of DECIMAL and STRING.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETVARBINARY (index, value);
Sets the designated parameter to the specified value of type VARBINARY.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SETVARCHAR (index, value);
Sets the designated parameter to the specified value of type VARCHAR.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SORT(sortcol, isAscending | dgSort);
Sorts the target data grid.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package.SQRT( );
Returns a matrix that contains the square root of each value in the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.STREAMRESPONSEBODYASBINARY(variable, rc);
Streams the body, in chunks, from the HTTP response in binary format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.STREAMRESPONSEBODYASSTRING(variable, rc);
Streams the body, in chunks, from the HTTP response in character string format.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package-1.SUB(matrix-package-2);
Subtracts one matrix from another.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SUBSET(dgSource, cmpCol, operator, cmpValue);
package.SUBSET(dgSource, dgCriteria);
Subsets the data grid to include only those rows for which comparison column and value evaluates to true.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SUBSETBYFILTER(dgSource, keepColumns, filter <, varList>);
Subsets the data grid to include only those rows for which the row filter evaluates to true. The target column and source row criteria are specified using a column keep clause and a row filter definition.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
summary-variable=package.SUM();
summary-variable= package.SUM(\[keys\]);
Retrieves the summary value for a given key from the hash table and stores the value in a variable.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
summary-variable=package.SUMDUP();
summary-variable= package.SUMDUP(\[keys\]);
Retrieves the summary value for the current data item of the current key and stores the value in a variable.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.SUMINC(suminc-variable);
Specifies a variable that maintains a summary count of hash package keys.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
TABLE_END( );
Specifies the end of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
TABLE_START(<option-1><,option-2, ...>);
Specifies the start of a table.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
METHOD TERM ( );
END;
Calls a DS2 system method where program finalizations can take place.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
TITLE(DATA:'displayed-data' <,option-1><,option-2, ...>);
Adds a title to a page.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
array-name.TOARRAY(matrix-package);
Moves the values from a matrix package into a DS2 array.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.TOISO8601 (local-time);
variable=package.TOISO8601 (local-time, time-zone-ID);
Converts local time to an ISO8601 string with time zone offset.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.TOLOCALTIME (UTC-time);
variable=package.TOLOCALTIME (UTC-time, time-zone-ID);
Converts UTC time to local time.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.TOPN (dgSource, col, N);
Sorts the target data grid in descending order, by the specified column, and then truncates it to the first N rows.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.TOTIMESTAMPZ (local-time<, time-zone-ID>);
Converts local time to a TIMESTAMP string with time zone.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable=package.TOUTCTIME (local-time);
variable=package.TOUTCTIME (local-time, time-zone-ID);
Converts local time to UTC time.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
variable-array-name.TOVARARRAY(matrix-package);
Moves the values from a matrix package into a variable array.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
r=matrix-package.TRANS( );
Returns a matrix that transposes the rows and columns of the input matrix.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.VERSION();
Returns the version of the data grid interface.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
VIDEO (FILE: 'path' | 'FILEREFfileref'
<, TYPE:file-type, ><video-control-option-1><,video-control-option-2, ...>);
Embeds video into HTML5 or EPUB output.
Product: Base SAS
Document: SAS Viya Workbench: Advanced Topics for the Output Delivery System
package.WRITEARRAYOPEN( );
Writes the open bracket ( [ ) signifying the beginning of an array.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITEBOOLEANFALSE( );
Writes a Boolean false value to the text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITEBOOLEANTRUE( );
Writes a Boolean true value to the text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITECLOSE( );
Closes the corresponding object ( } ) or array ( ] ).
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITEDOUBLE(double-value);
package.WRITEDOUBLE(double-value, width);
package.WRITEDOUBLE(double-value, width, precision);
package.WRITEDOUBLE(double-value, width, precision, options);
Writes a DOUBLE value in text form.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITENULL( );
Writes a null value to the text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITEOBJOPEN( );
Writes the open brace ( { ) signifying the beginning of an object.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITERGETTEXT(rc, json-text);
Obtains the JSON text that is produced by the writer.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
package.WRITESTRING({<' | ">}string{<' | ">}, flags);
Writes a string to the JSON text.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
Last updated: September 24, 2026