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
ABORT Method	package.ABORT( ); Stops the execution of the HTTP method. Product: Base SAS Document: SAS DS2 Language Reference
ABS Method	r=package.ABS( ); Returns a matrix that contains the absolute value of each value in the input matrix. Product: Base SAS Document: SAS DS2 Language Reference
ADD Method: Hash Package	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 Language Reference
ADD Method: Matrix Package	r=package-1.ADD(package-2); Adds one matrix to another. Product: Base SAS Document: SAS DS2 Language Reference
ADDREQUESTHEADER Method	package.ADDREQUESTHEADER('name', 'value'); Adds a header to the HTTP method request. Product: Base SAS Document: SAS DS2 Language Reference
ADDSASOAUTHTOKEN Method	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 Language Reference
ALL_AND Method	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 Language Reference
ALL_EQ Method	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 Language Reference
ALL_GE Method	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 Language Reference
ALL_GT Method	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 Language Reference
ALL_LE Method	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 Language Reference
ALL_LT Method	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 Language Reference
ALL_NE Method	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 Language Reference
ALL_OR Method	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 Language Reference
AND Method	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 Language Reference
ANY_AND Method	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 Language Reference
ANY_EQ Method	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 Language Reference
ANY_GE Method	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 Language Reference
ANY_GT Method	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 Language Reference
ANY_LE Method	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 Language Reference
ANY_LT Method	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 Language Reference
ANY_NE Method	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 Language Reference
ANY_OR Method	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 Language Reference
APPEND Method	package.APPEND(dgSource \| JSON_string); Appends the specified source data grid to the specified target data grid. Product: Base SAS Document: SAS DS2 Language Reference
APPLY Method	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 Language Reference
AUDIO Method	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 Output Delivery System: Advanced Topics
BINDPARAMETERS Method	package.BINDPARAMETERS ([parameter-variable-list]); Binds a list of variables to the parameters in the FedSQL statement. Product: Base SAS Document: SAS DS2 Language Reference
BINDRESULTS Method	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 Language Reference
BODY_END Method	BODY_END( ); Specifies the end of the body section of the table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
BODY_START Method	BODY_START(<option-1><,option-2, ...>); Specifies the start of the body section of the table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
BOTTOMN Method	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 Language Reference
BULKINSERTADDROW Method	package.BULKINSERTADDROW(); Adds a row of data for bulk insertion. Product: Base SAS Document: SAS DS2 Language Reference
BULKINSERTBINDCOLUMNS Method	package.BULKINSERTBINDCOLUMNS(variable-list); Binds a list of variables to the columns that are selected for bulk insertion. Product: Base SAS Document: SAS DS2 Language Reference
BULKINSERTFLUSH Method	package.BULKINSERTFLUSH(); Flushes all the rows in the bulk insertion row buffer. Product: Base SAS Document: SAS DS2 Language Reference
BULKINSERTGETCOLUMNCOUNT Method	package.BULKINSERTGETCOLUMNCOUNT(); Returns the number of columns that are selected for bulk insertion. Product: Base SAS Document: SAS DS2 Language Reference
BULKINSERTGETCOLUMNNAME Method	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 Language Reference
BULKINSERTGETCOLUMNTYPENAME Method	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 Language Reference
BULKINSERTISPREPARED Method	package.BULKINSERTISPREPARED(); Returns a value that indicates whether the SQLSTMT package instance is prepared for bulk insertion. Product: Base SAS Document: SAS DS2 Language Reference
BULKINSERTPREPARE Method	package.BULKINSERTPREPARE(select-string[, connection-string]); Prepares an SQLSTMT package instance for a bulk insertion. Product: Base SAS Document: SAS DS2 Language Reference
CELL_END Method	CELL_END( ); Specifies the end of a cell. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
CELL_START Method	CELL_START(<option-1><,option-2, ...>); Specifies the start of a cell. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
CHECK Method	package.CHECK( ); package.CHECK(\[keys\]); Checks whether the specified key is stored in the hash package. Product: Base SAS Document: SAS DS2 Language Reference
CLEAR Method	package.CLEAR( ); Removes all items from a hash package without deleting the hash package instance. Product: Base SAS Document: SAS DS2 Language Reference
CLEAR Method: Datagrid Package	package.CLEAR(); Deletes all rows and all column metadata from the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
CLEARDATA Method	package.CLEARDATA(); Deletes all rows from the specified data grid but does not remove the column metadata. Product: Base SAS Document: SAS DS2 Language Reference
CLOSERESULTS Method	package.CLOSERESULTS( ); Releases the result set from the last execution of the statement. Product: Base SAS Document: SAS DS2 Language Reference
CLUSTERCONNECT Method	rc=package.clusterConnect([host/resource-config] [,port]]); Connects to a Redis Cluster. Product: Base SAS Document: SAS DS2 Language Reference
COLS Method	variable-name=package.COLS( ); Returns the number of columns in the specified matrix. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNADD Method	package.COLUMNADD(colName, typeName); Adds a column of specified type to the target data grid. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNADDCHARTYPE Method	package.COLUMNADDCHARTYPE(colName); Adds a character column to the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNADDNUMTYPE Method	package.COLUMNADDNUMTYPE(colName); Adds a numeric column of type decimal to the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCLEAR Method	package.COLUMNCLEAR(col, [rowStartIndex, rowEndIndex]); Clears all the rows in a data grid column. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCORR Method	package.COLUMNCORR(col1, col2 [, rowStartIndex, rowEndIndex]); Returns the Pearson correlation coefficient of the two specified columns. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCOUNT Method	package.COLUMNCOUNT(); Returns the number of columns in the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCOUNTMATCH Method	package.COLUMNCOUNTMATCH(cmpCol, operator, cmpValue); Returns the number of rows that match the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCOUNTMATCHBYFILTER Method	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 Language Reference
COLUMNCOUNTMATCHIN Method	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 Language Reference
COLUMNCOUNTMISSING Method	package.COLUMNCOUNTMISSING(col [, rowStartIndex, rowEndIndex]); Returns the number of missing values for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNCOUNTVALID Method	package.COLUMNCOUNTVALID(col [, rowStartIndex, rowEndIndex]); Returns the number of valid nonmissing numeric values for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNDELETE Method	package.COLUMNDELETE(col); Deletes the specified column from the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNEXISTS Method	package.COLUMNEXISTS(colName); Returns 1 (true) if the specified column exists. Otherwise, returns 0 (false). Product: Base SAS Document: SAS DS2 Language Reference
COLUMNINDEX Method	package.COLUMNIDEX(colName); Returns the ordinal position of the specified column name. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNISNUMERIC Method	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 Language Reference
COLUMNMAX Method	package.COLUMNMAX(col [, rowStartIndex, rowEndIndex]); Returns the maximum value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMAXBOOL Method	package.COLUMNMAXBOOL(col [, rowStartIndex, rowEndIndex]); Returns the maximum Boolean value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMAXINT Method	package.COLUMNMAXINT(col [, rowStartIndex, rowEndIndex]); Returns the maximum integer value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMAXSTRING Method	package.COLUMNMAXSTRING(col [, rowStartIndex, rowEndIndex]); Returns the maximum string value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMEAN Method	package.COLUMNMEAN(col [, rowStartIndex, rowEndIndex]); Returns the mean value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMEDIAN Method	package.COLUMNMEDIAN(col [, rowStartIndex, rowEndIndex]); Returns the median value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMIN Method	package.COLUMNMIN(col [, rowStartIndex, rowEndIndex]); Returns the minimum value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMINBOOL Method	package.COLUMNMINBOOL(col [ , rowStartIndex, rowEndIndex ]); Returns the minimum Boolean value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMININT Method	package.COLUMNMININT(col [, rowStartIndex, rowEndIndex]); Returns the minimum integer value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMINLONG Method	package.COLUMNMINLONG(col [, rowStartIndex, rowEndIndex]); Returns the minimum long value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNMINSTRING Method	package.COLUMNMINSTRING(col [, rowStartIndex, rowEndIndex]); Returns the minimum string value for the specified criteria. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNNAME Method	package.COLUMNNAME(colIndex); Returns the name of the column that is in the one-based ordinal position. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNRENAME Method	package.COLUMNRENAME(col, newName) Renames the specified column. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNSTDDEV Method	package.COLUMNSTDDEV(col [, rowStartIndex, rowEndIndex]); Returns the standard deviation of the values in the specified column. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNSUM Method	package.COLUMNSUM(col); Returns the sum of DOUBLE values in the specified column. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNSUMLONG Method	package.COLUMNSUMLONG(col); Returns the sum of LONG values in the specified column. Product: Base SAS Document: SAS DS2 Language Reference
COLUMNTYPENAME Method	package.COLUMNTYPENAME(colName); Returns the type name of the specified column name. Product: Base SAS Document: SAS DS2 Language Reference
CONNECT Method	rc=package.CONNECT ([[host \| resource-config] [, port ]]); Connects to the Redis server. Product: Base SAS Document: SAS DS2 Language Reference
COPY Method	r=package.COPY( ); Copies one matrix to another. Product: Base SAS Document: SAS DS2 Language Reference
COPY Method: Datagrid Package	package.COPY(dgSource); Creates a duplicate of the source data grid into the target data grid. Product: Base SAS Document: SAS DS2 Language Reference
CREATEGETMETHOD Method	package.CREATEGETMETHOD {( ) \| ('url')}; Creates an HTTP GET method to retrieve a resource from a web server. Product: Base SAS Document: SAS DS2 Language Reference
CREATEHEADMETHOD Method	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 Language Reference
CREATEPARSER Method	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 Language Reference
CREATEPATCHMETHOD Method	package.createPatchMethod{( ) \| ('url)'}; Creates an HTTP PATCH method to request the web server to accept data for a resource. Product: Base SAS Document: SAS DS2 Language Reference
CREATEPOSTMETHOD Method	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 Language Reference
CREATEPUTMETHOD Method	package.createPutMethod {( ) \| ('url)'}; Creates an HTTP PUT method to request the web server to accept data for a resource. Product: Base SAS Document: SAS DS2 Language Reference
CREATEWRITER Method	package.CREATEWRITER ([PRETTY]); Creates a JSON writer instance. Product: Base SAS Document: SAS DS2 Language Reference
DATA Method	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 Language Reference
DATASET Method	package.DATASET([']data-source['] \| '\{sql-text\}' ); Specifies the name of a table to load into the hash package. Product: Base SAS Document: SAS DS2 Language Reference
DEBUG Method	object.DEBUG("message"); Logs a DEBUG message if the specified logger accepts DEBUG messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
DEFINEDATA Method	package.DEFINEDATA('data'); Defines data variables for the hash package using implicit variables. Product: Base SAS Document: SAS DS2 Language Reference
DEFINEDONE Method	package.DEFINEDONE( ); Indicates that all key and data definitions are complete. Product: Base SAS Document: SAS DS2 Language Reference
DEFINEKEY Method	package.DEFINEKEY('key'); Defines key variables for the hash package using implicit variables. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method	DELETE( ); Deletes an instance of a class. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
DELETE Method: FCMP Package	package.DELETE( ); Deletes an FCMP package. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: Hash, and Hash Iterator Package	package.DELETE( ); Deletes a hash or hash iterator package. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: HTTP Package	package.DELETE( ); Deletes an HTTP package instance and frees its resources. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: JSON Package	package.DELETE( ); Deletes a JSON package. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: Logger Package	package.DELETE( ); Deletes a logger package. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: Matrix Package	package.DELETE( ); Deletes a matrix package. Product: Base SAS Document: SAS DS2 Language Reference
DELETE Method: SQLSTMT Package	package.DELETE( ); Deletes an instance of the SQLSTMT package. Product: Base SAS Document: SAS DS2 Language Reference
DELETEKEY Method	rc=package.DELETEKEY (key); Removes the specified key. Product: Base SAS Document: SAS DS2 Language Reference
DESERIALIZE Method	package.DESERIALIZE(JSON_string); Creates a data grid from the specified JSON string. Product: Base SAS Document: SAS DS2 Language Reference
DESTROYPARSER Method	package.DESTROYPARSER ( ); Destroys a JSON Parser instance. Product: Base SAS Document: SAS DS2 Language Reference
DESTROYWRITER Method	package.DESTROYWRITER ( ); Destroys a JSON writer instance. Product: Base SAS Document: SAS DS2 Language Reference
DET Method	d=package.DET( ); Computes the determinant of a square matrix. Product: Base SAS Document: SAS DS2 Language Reference
DISCONNECT Method	rc=package.DISCONNECT(); Disconnects from the Redis server. Product: Base SAS Document: SAS DS2 Language Reference
DISTINCTCOUNT Method	package.DISTINCTCOUNT(); Returns the number of unique rows in the data grid. Product: Base SAS Document: SAS DS2 Language Reference
DUPLICATE Method	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 Language Reference
EDIV Method	x=package-1.EDIV(package-2); Performs an elementwise scalar division. Product: Base SAS Document: SAS DS2 Language Reference
EMAX Method	x=package-1.EMAX(package-2); Performs an elementwise comparison of two matrices and returns the largest elements. Product: Base SAS Document: SAS DS2 Language Reference
EMIN Method	x=package-1.EMIN(package-2); Performs an elementwise comparison of two matrices and returns the smallest elements. Product: Base SAS Document: SAS DS2 Language Reference
EMOD Method	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 Language Reference
EMULT Method	r=package-1.EMULT(package-2); Performs an elementwise scalar multiplication. Product: Base SAS Document: SAS DS2 Language Reference
EPOW Method	x=package-1.EPOW(package-2); Raises a number to a specified power in an elementwise operation. Product: Base SAS Document: SAS DS2 Language Reference
EQ Method	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 Language Reference
ERROR Method	object.ERROR("message"); Logs an ERROR message if the specified logger accepts ERROR messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
EXECUTE Method	package.EXECUTE( ); Executes the FedSQL statement. Product: Base SAS Document: SAS DS2 Language Reference
EXECUTEMETHOD Method	package.EXECUTEMETHOD( ); Executes the HTTP method and enables retrieval of the response body as a complete entity. Product: Base SAS Document: SAS DS2 Language Reference
EXECUTEMETHODSTREAM Method	package.EXECUTEMETHODSTREAM( ); Executes the HTTP method and enables streaming of the response body from the HTTP server. Product: Base SAS Document: SAS DS2 Language Reference
EXISTS Method	rc=package.EXISTS (key, isSet); Determines whether a specified key exists. Product: Base SAS Document: SAS DS2 Language Reference
EXP Method	r=package.EXP( ); Returns a matrix that contains an exponential value for each value in the input matrix. Product: Base SAS Document: SAS DS2 Language Reference
FATAL Method	object.FATAL("message"); Logs a FATAL message if the specified logger accepts FATAL messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
FETCH Method	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 Language Reference
FETCHCHILDKEY Method	rc=package.FETCHCHILDKEY(this-node,key-idx,key-str); Specifies the key string at a given index within a JSON object. Product: Base SAS Document: SAS DS2 Language Reference
FETCHCHILDNODE Method	FORM 1: rc=package.FETCHCHILDNODE(this-node,key-str,node-id); FORM 2: rc=package.FETCHCHILDNODE(this-node,key-idx,node-id); Retrieves a direct child node from a JSON object or JSON array Product: Base SAS Document: SAS DS2 Language Reference
FILTEREDCOMPARE Method	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 Language Reference
FILTEREDGET Method	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 Language Reference
FILTEREDGETBYFILTER Method	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 Language Reference
FILTEREDGETIN Method	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 Language Reference
FILTEREDGETINDEX Method	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 Language Reference
FILTEREDGETINDEXBYFILTER Method	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 Language Reference
FILTEREDGETINDEXIN Method	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 Language Reference
FILTEREDSET Method	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 Language Reference
FILTEREDSETALL Method	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 Language Reference
FILTEREDSETALLBYFILTER Method	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 Language Reference
FILTEREDSETBYFILTER Method	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 Language Reference
FIND Method	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 Language Reference
FIND_NEXT Method	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 Language Reference
FIND_PREV Method	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 Language Reference
FINDNODE Method	rc = package.FINDNODE(root-id, json-path, node-id); Specifies a JSON node within a parsed tree by evaluating a JSON path expression. Product: Base SAS Document: SAS DS2 Language Reference
FIRST Method	package.FIRST( ); package.FIRST(\[data\]); Returns the first value in the underlying hash package. Product: Base SAS Document: SAS DS2 Language Reference
FLOOR Method	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 Language Reference
FOOT_END Method	FOOT_END( ); Specifies the end of the footer section of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
FOOT_START Method	FOOT_START(<option-1><,option-2, ...>); Specifies the start of the footer section of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
FOOTNOTE Method	FOOTNOTE(DATA:'displayed-data' <,option-1><,option-2, ...>); Adds a footnote to the page. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
FORMAT_CELL Method	FORMAT_CELL(DATA:'displayed-data' <,option-1><,option-2, ...>); Formats the contents of a cell. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
FORMAT_TEXT Method	FORMAT_TEXT(DATA:'displayed-data' <,option-1><,option-2, ...>); Writes text to the active output destination(s). Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
FULLJOIN Method	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 Language Reference
FULLJOINBYFILTER Method	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 Language Reference
FULLJOINCOUNT Method	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 Language Reference
FULLJOINTCOUNTBYFILTER Method	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 Language Reference
GE Method	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 Language Reference
GETBIGINT Method	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 Language Reference
GETBINARY Method	rc=package.GETBINARY (key, variable); Gets the specified binary key and its assigned value. Product: Base SAS Document: SAS DS2 Language Reference
GETBOOL Method	package.GETBOOL(col, rowIndex); Returns the Boolean value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETCHAR Method	variable=package.GETCHAR (index); package.GETCHAR (index, variable, rc); Returns the designated result set column as type CHAR. Product: Base SAS Document: SAS DS2 Language Reference
GETCOLUMNCOUNT Method	variable=package.GETCOLUMNCOUNT(); Returns the number of columns in the result set. Product: Base SAS Document: SAS DS2 Language Reference
GETCOLUMNNAME Method	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 Language Reference
GETCOLUMNTYPENAME Method	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 Language Reference
GETDATE Method	variable=package.GETDATE (index); package.GETDATE (index, variable, rc); Returns the designated result set column as type DATE. Product: Base SAS Document: SAS DS2 Language Reference
GETDECIMAL Method	variable=package.GETDECIMAL (index); package.GETDECIMAL (index, variable, rc); Returns the designated result set column as type DECIMAL. Product: Base SAS Document: SAS DS2 Language Reference
GETDOUBLE Method	package.GETDOUBLE(col, rowIndex); Returns the decimal value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETFLOAT Method	rc=package.GETFLOAT(this-node,get-var); Specifies floating-point values that represent nodes. Product: Base SAS Document: SAS DS2 Language Reference
GETGROUP Method	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 Language Reference
GETGROUPEND Method	ending-index=package.GETGROUPEND (groupNumber) returns int; Returns the ending index of the given capture group. Product: Base SAS Document: SAS DS2 Language Reference
GETGROUPLENGTH Method	length=package.GETGROUPLENGTH (groupNumber); Returns the length of the given capture group's text in characters. Product: Base SAS Document: SAS DS2 Language Reference
GETGROUPSTART Method	starting-index=package.GETGROUPSTART (groupNumber); Returns the starting index of the given capture group. Product: Base SAS Document: SAS DS2 Language Reference
GETINT Method	package.GETINT(col, rowIndex); Returns the integer value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETINTEGER Method	variable=package.GETINTEGER (index); package.GETINTEGER (index, variable, rc); Gets the designated result set column as type INTEGER. Product: Base SAS Document: SAS DS2 Language Reference
GETLOCALTIME Method	variable=package.GETLOCALTIME ([time-zone-ID]); Returns current local time. Product: Base SAS Document: SAS DS2 Language Reference
GETLONG Method	package.GETLONG(col, rowIndex); Returns the long value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETMATCH Method	returnCode=package.GETMATCH (IN_OUT resultString); Places the text of the previous match into the result string. Product: Base SAS Document: SAS DS2 Language Reference
GETMATCHEND Method	ending-index=package.GETMATCHEND(); Returns the next position after the end of the text from the previous match. Product: Base SAS Document: SAS DS2 Language Reference
GETMATCHLENGTH Method	length=package.GETMATCHLENGTH (); Returns the number of characters of the previous match. Product: Base SAS Document: SAS DS2 Language Reference
GETMATCHSTART Method	starting-index=package.GETMATCHSTART(); Returns the starting index of the previous match operation. Product: Base SAS Document: SAS DS2 Language Reference
GETNCHAR Method	variable=package.GETNCHAR (index); package.GETNCHAR (index, variable, rc); Gets the designated result set column as type NCHAR. Product: Base SAS Document: SAS DS2 Language Reference
GETNEXTTOKEN Method	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 Language Reference
GETNUMBER Method	rc=package.GETNUMBER(this-node,get-var); Specifies numeric integer or floating-point values as a double. Product: Base SAS Document: SAS DS2 Language Reference
GETNUMERIC Method	variable=package.GETNUMERIC (index); package.GETNUMERIC (index, variable, rc); Returns the designated result set column as type NUMERIC. Product: Base SAS Document: SAS DS2 Language Reference
GETNVARCHAR Method	variable=package.GETNVARCHAR (index); package.GETNVARCHAR (index, variable, rc); Returns the designated result set column as type NVARCHAR. Product: Base SAS Document: SAS DS2 Language Reference
GETOFFSET Method	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 Language Reference
GETOFFSETUTC Method	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 Language Reference
GETREAL Method	variable=package.GETREAL (index); package.GETREAL (index, variable, rc); Returns the designated result set column as type REAL. Product: Base SAS Document: SAS DS2 Language Reference
GETRESPONSEBODYASBINARY Method	package.GETRESPONSEBODYASBINARY(variable, rc); Returns the entire body from the HTTP response in binary format. Product: Base SAS Document: SAS DS2 Language Reference
GETRESPONSEBODYASSTRING Method	package.GETRESPONSEBODYASSTRING(variable, rc); Returns the entire body from the HTTP response in character string format. Product: Base SAS Document: SAS DS2 Language Reference
GETRESPONSECONTENTTYPE Method	content-type-variable=package.GETRESPONSECONTENTTYPE( ); Returns the content type from the HTTP response. Product: Base SAS Document: SAS DS2 Language Reference
GETRESPONSEHEADERSASSTRING Method	package.GETRESPONSEHEADERSASSTRING(variable, rc); Returns the response headers from the HTTP method in character string format. Product: Base SAS Document: SAS DS2 Language Reference
GETSMALLINT Method	variable=package.GETSMALLINT (index); package.GETSMALLINT (index, variable, rc); Returns the designated result set column as type SMALLINT. Product: Base SAS Document: SAS DS2 Language Reference
GETSTATUSCODE Method	status-code-variable=package.GETSTATUSCODE( ); Returns the HTTP status code from the most recently executed HTTP method. Product: Base SAS Document: SAS DS2 Language Reference
GETSTRING Method	package.GETSTRING(col, rowIndex); Returns the string value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETTIME Method	variable=package.GETTIME (index); package.GETTIME (index, variable, rc); Returns the designated result set column as type TIME. Product: Base SAS Document: SAS DS2 Language Reference
GETTIMESTAMP Method	variable=package.GETTIMESTAMP (index); package.GETTIMESTAMP (index, variable, rc); Returns the designated result set column as type TIMESTAMP. Product: Base SAS Document: SAS DS2 Language Reference
GETTIMEZONEID Method	variable=package.GETTIMEZONEID ( ); Returns the current time zone ID. Product: Base SAS Document: SAS DS2 Language Reference
GETTIMEZONENAME Method	variable=package.GETTIMEZONENAME ( ); Returns the current time zone name. Product: Base SAS Document: SAS DS2 Language Reference
GETTINYINT Method	variable=package.GETTINYINT (index); package.GETTINYINT (index, variable, rc); Returns the designated result set column as type TINYINT. Product: Base SAS Document: SAS DS2 Language Reference
GETUTCTIME Method	variable=package.GETUTCTIME ( ); Returns the current UTC time. Product: Base SAS Document: SAS DS2 Language Reference
GETVALUE Method	package.GETVALUE(col, rowIndex); Returns the value of the cell in the specified row and column. Product: Base SAS Document: SAS DS2 Language Reference
GETVARBINARY Method	variable=package.GETVARBINARY (index); package.GETVARBINARY (index, variable, rc); Returns the designated result set column as type VARBINARY. Product: Base SAS Document: SAS DS2 Language Reference
GETVARCHAR Method	variable=package.GETVARCHAR (index); package.GETVARCHAR (index, variable, rc); Returns the designated result set column as type VARCHAR. Product: Base SAS Document: SAS DS2 Language Reference
GT Method	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 Language Reference
HAS_NEXT Method	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 Language Reference
HAS_PREV Method	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 Language Reference
HASHEXP Method	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 Language Reference
HASKEY Method	rc=package.HASKEY(this-node,key-str,has-key); Determines whether a JSON object contains a specific key among its direct children. Nested keys at deeper levels of the tree are not searched. Product: Base SAS Document: SAS DS2 Language Reference
HEAD_END Method	HEAD_END( ); Specifies the end of the header section of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
HEAD_START Method	HEAD_START(<option-1><,option-2, ...>); Specifies the start of the header section of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
HGET Method	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 Language Reference
HGETALL Method	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 Language Reference
HGETSUBSET Method	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 Language Reference
HREF Method	HREF (DATA: 'displayed-data', URL:'data-path' <,option-1> <,option-2, ...>); Creates a link. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
HSET Method	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 Language Reference
IMAGE Method	IMAGE (FILE:"FILEREF:fileref" \| "filename"<,option-1> <,option-2, ...>); Inserts an image into all open output destinations. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
IN Method	package.IN(array-name); Loads an array into a matrix. Product: Base SAS Document: SAS DS2 Language Reference
INFO Method	object.INFO("message"); Logs an INFO message if the specified logger accepts INFO messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
INIT Method	METHOD INIT( ); END; Calls a DS2 system method where program initializations can take place. Product: Base SAS Document: SAS DS2 Language Reference
INNERJOIN Method	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 Language Reference
INNERJOINBYFILTER Method	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 Language Reference
INNERJOINCOUNT Method	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 Language Reference
INNERJOINCOUNTBYFILTER Method	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 Language Reference
INVERSE Method	im=matrix-package.INVERSE( ); Computes the inverse of a matrix. Product: Base SAS Document: SAS DS2 Language Reference
ISBOOLEANFALSE Method	package.ISBOOLEANFALSE(token-type); Returns true if the token is false. Product: Base SAS Document: SAS DS2 Language Reference
ISBOOLEANTRUE Method	package.ISBOOLEANTRUE(token-type); Returns true if the token is true. Product: Base SAS Document: SAS DS2 Language Reference
ISFLOAT Method	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 Language Reference
ISINTEGER Method	package.ISINTEGER (token-type, parse-flags); Returns true if the token is an integer in text form. Product: Base SAS Document: SAS DS2 Language Reference
ISLABEL Method	package.ISLABEL(token-type, parse-flags); Returns true if the token is an object label. Product: Base SAS Document: SAS DS2 Language Reference
ISLEFTBRACE Method	package.ISLEFTBRACE(token-type); Returns true if the token is a left brace ( { ). Product: Base SAS Document: SAS DS2 Language Reference
ISLEFTBRACKET Method	package.ISLEFTBRACKET(token-type); Returns true if the token is a left bracket ( [ ). Product: Base SAS Document: SAS DS2 Language Reference
ISLEVELACTIVE Method	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 Language Reference
ISNULL Method	package.ISNULL(token-type); Returns true if the token is null. Product: Base SAS Document: SAS DS2 Language Reference
ISNUMERIC Method	package.ISNUMERIC(token-type); Returns true if the token is numeric in text form. Product: Base SAS Document: SAS DS2 Language Reference
ISPARTIAL Method	package.ISPARTIAL(parse-flags); Returns true if the token is incomplete because of tipping. Product: Base SAS Document: SAS DS2 Language Reference
ISPREPARED Method	package.ISPREPARED( ); Returns a value that indicates whether the SQLSTMT package instance is prepared. Product: Base SAS Document: SAS DS2 Language Reference
ISRIGHTBRACE Method	package.ISRIGHTBRACE(token-type); Returns true if the token is a right brace ( } ). Product: Base SAS Document: SAS DS2 Language Reference
ISRIGHTBRACKET Method	package.ISRIGHTBRACKET(token-type); Returns true if the token is a right bracket ( ] ). Product: Base SAS Document: SAS DS2 Language Reference
ISSTRING Method	package.ISSTRING(token-type); Returns true if the token is a string. Product: Base SAS Document: SAS DS2 Language Reference
KEYS Method	package.KEYS(\[keys\]); Defines the key variables for the hash package using a variable list. Product: Base SAS Document: SAS DS2 Language Reference
LAST Method	package.LAST( ); package.LAST(\[data\]); Returns the last value in the underlying hash package. Product: Base SAS Document: SAS DS2 Language Reference
LAYOUT_ABSOLUTE Method	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 Output Delivery System: Advanced Topics
LAYOUT_END Method	LAYOUT_END( ); Ends a gridded or absolute layout block. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
LAYOUT_GRIDDED Method	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 Output Delivery System: Advanced Topics
LE Method	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 Language Reference
LEFTJOIN Method	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 Language Reference
LEFTJOINBYFILTER Method	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 Language Reference
LEFTJOINCOUNT Method	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 Language Reference
LEFTJOINCOUNTBYFILTER Method	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 Language Reference
LEN Method	rc=package.LEN(this-node,size); Returns the number of children in a JSON object, key-value pairs, or array elements. Product: Base SAS Document: SAS DS2 Language Reference
LINE Method	LINE(<option-1><,option-2, ...>); Inserts a horizontal rule (line) across the page. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
LOG Method: Logger Package	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 Language Reference
LOG Method: Matrix Package	r=package.LOG( ); Returns a matrix that contains the natural logarithm for each value in the input matrix. Product: Base SAS Document: SAS DS2 Language Reference
LT Method	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 Language Reference
MATCH Method	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 Language Reference
MULT Method	r=matrix-package-1.MULT(matrix-package-2); Multiplies one matrix by another matrix. Product: Base SAS Document: SAS DS2 Language Reference
MULTIDATA Method	package.MULTIDATA(['option']); Specifies whether multiple data items are allowed for each key. Product: Base SAS Document: SAS DS2 Language Reference
NAME Method	package.NAME(); Returns the name that is given at the declaration of the data grid instance. Product: Base SAS Document: SAS DS2 Language Reference
NE Method	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 Language Reference
NEXT Method	package.NEXT( ); package.NEXT(\[data\]); Returns the next value in the underlying hash package. Product: Base SAS Document: SAS DS2 Language Reference
NOTE Method	NOTE(DATA:'displayed-data' <,option-1><,option-2, ...>); Writes a note to the active output destination(s). Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
OR Method	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 Language Reference
ORDERED Method	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 Language Reference
OUT Method	matrix-package.OUT(array-name); Writes matrix row data to a variable array. Product: Base SAS Document: SAS DS2 Language Reference
OUTPUT Method	package.OUTPUT ([']output-table['] ); Creates a table that contains the data in the hash package. Product: Base SAS Document: SAS DS2 Language Reference
PAGE Method	PAGE( ); Creates a page break. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
PARSE Method: PCRXFIND Package	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 Language Reference
PARSE Method: PCRXREPLACE Package	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 Language Reference
PARSEINPUT Method	rc=package.PARSEINPUT(json-text, root-id); Parses the JSON text and builds an in-memory value tree. Product: Base SAS Document: SAS DS2 Language Reference
PREPARE Method	PREPARE ('sql-text' ); PREPARE ('sql-text' , connection-string); Prepares a FedSQL statement. Product: Base SAS Document: SAS DS2 Language Reference
PREV Method	package.PREV( ); package.PREV(\[data\]); Returns the previous value in the underlying hash package. Product: Base SAS Document: SAS DS2 Language Reference
REF Method	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 Language Reference
REGION Method: Absolute	REGION(<option-1><,option-2, ...>); Creates a region container for absolute layouts. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
REGION Method: Gridded	REGION(<option-1><,option-2, ...>); Creates a region container for gridded layouts. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
REGISTEROUTPARAMETER Method	REGISTEROUTPARAMETER (index) Registers the designated parameter as an output parameter. Product: Base SAS Document: SAS DS2 Language Reference
REMOVE Method	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 Language Reference
REMOVEALL Method	package.REMOVEALL(); package.REMOVEALL(\[keys\]); Removes the data that is associated with all keys from the hash package. Product: Base SAS Document: SAS DS2 Language Reference
REMOVEDUP Method	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 Language Reference
REPLACE Method	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 Language Reference
REPLACEDUP Method	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 Language Reference
RIGHTJOIN Method	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 Language Reference
RIGHTJOINBYFILTER Method	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 Language Reference
RIGHTJOINCOUNT Method	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 Language Reference
RIGHTJOINCOUNTBYFILTER Method	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 Language Reference
ROW_END Method	ROW_END( ); Specifies the end of a row. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
ROW_START Method	ROW_START(<option-1><,option-2, ...>); Specifies the beginning of a row. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
ROWADD Method	package.ROWADD(n); Appends the specified number of rows to the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
ROWCOUNT Method	package.ROWCOUNT(); Returns the number of rows in the data grid. Product: Base SAS Document: SAS DS2 Language Reference
ROWDELETE Method	package.ROWDELETE(rowStartIndex <, rowEndIndex>); Deletes the specified rows from the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
ROWS Method	variable-name=matrix-package.ROWS( ); Returns the number of rows in the specified matrix. Product: Base SAS Document: SAS DS2 Language Reference
RUN Method	METHOD RUN( ); END; Calls a DS2 system method where DS2 program code can run in an implicit loop. Product: Base SAS Document: SAS DS2 Language Reference
SELECT Method	rc=package.SELECT ([logicalDB]); Selects the logical database with the specified zero-based numeric index. Product: Base SAS Document: SAS DS2 Language Reference
SERIALIZE Method	package.SERIALIZE(); package.SERIALIZE(length, jsonString); Returns the JSON string of the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
SERIALIZEDATA Method	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 Language Reference
SERIALIZEMETADATA Method	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 Language Reference
SETALL Method	package.SETALL(col, setValue); Sets all the values of a column to the specified value. Product: Base SAS Document: SAS DS2 Language Reference
SETBIGINT Method	package.SETBIGINT (index, value); Sets the designated parameter to the specified value of type BIGINT. Product: Base SAS Document: SAS DS2 Language Reference
SETBINARY Method	rc=package.SETBINARY (key, value [,options [, option_value]]); Sets a binary value. Product: Base SAS Document: SAS DS2 Language Reference
SETBOOL Method	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 Language Reference
SETCHAR Method	package.SETCHAR (index, value); Sets the designated parameter to the specified value of type CHAR. Product: Base SAS Document: SAS DS2 Language Reference
SETCUR Method	package.SETCUR( ); package.SETCUR(\[keys\], \[data\]); Specifies a starting key item for iteration. Product: Base SAS Document: SAS DS2 Language Reference
SETDATE Method	package.SETDATE (index, value); Sets the designated parameter to the specified value of type DATE. Product: Base SAS Document: SAS DS2 Language Reference
SETDECIMAL Method	package.SETDECIMAL (index, value); Sets the designated parameter to the specified value of type DECIMAL. Product: Base SAS Document: SAS DS2 Language Reference
SETDOUBLE Method	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 Language Reference
SETINT Method	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 Language Reference
SETINTEGER Method	package.SETINTEGER (index, value); Sets the designated parameter to the specified value of type INTEGER. Product: Base SAS Document: SAS DS2 Language Reference
SETLONG Method	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 Language Reference
SETNAME Method	package.SETNAME(newName); Renames the specified data grid. Product: Base SAS Document: SAS DS2 Language Reference
SETNCHAR Method	package.SETNCHAR (index, value); Sets the designated parameter to the specified value of type NCHAR. Product: Base SAS Document: SAS DS2 Language Reference
SETNUMERIC Method	package.SETNUMERIC (index, value); Sets the designated parameter to the specified value of type NUMERIC. Product: Base SAS Document: SAS DS2 Language Reference
SETNVARCHAR Method	package.SETNVARCHAR (index, value); Sets the designated parameter to the specified value of type NVARCHAR. Product: Base SAS Document: SAS DS2 Language Reference
SETOAUTHTOKEN Method	package.SETOAUTHTOKEN('variable'); Specifies a string that contains the OAuth access token for the request. Product: Base SAS Document: SAS DS2 Language Reference
SETPARMS Method	thread.SETPARMS(parameter-value[, ...parameter-value]); Initializes parameters for an instance of a DS2 thread. Product: Base SAS Document: SAS DS2 Language Reference
SETPARSERINPUT Method	package.SETPARSERINPUT([json-text,]); Provides JSON text to the parser when it needs more text. Product: Base SAS Document: SAS DS2 Language Reference
SETPASSWORD Method	package.SETPASSWORD('variable'); Specifies the string that represents the password associated with the specified user name. Product: Base SAS Document: SAS DS2 Language Reference
SETPROXYPASSWORD Method	package.SETPROXYPASSWORD('variable'); Specifies the string that represents the password associated with the specified proxy user name. Product: Base SAS Document: SAS DS2 Language Reference
SETPROXYURL Method	package.SETPROXYURL('variable'); Specifies the proxy URL to which the HTTP client should connect. Product: Base SAS Document: SAS DS2 Language Reference
SETPROXYUSERNAME Method	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 Language Reference
SETREAL Method	package.SETREAL (index, value); Sets the designated parameter to the specified value of type REAL. Product: Base SAS Document: SAS DS2 Language Reference
SETREQUESTBODYASBINARY Method	package.SETREQUESTBODYASBINARY(variable); Adds the specified body to the HTTP method request in binary format. Product: Base SAS Document: SAS DS2 Language Reference
SETREQUESTBODYASSTRING Method	package.SETREQUESTBODYASSTRING(variable); Adds the specified body to the HTTP method request in character string format. Product: Base SAS Document: SAS DS2 Language Reference
SETREQUESTBODYCHARACTERSET Method	package.SETREQUESTBODYCHARACTERSET('variable'); Specifies the character set to use when encoding the request body. Product: Base SAS Document: SAS DS2 Language Reference
SETREQUESTCONTENTTYPE Method	package.SETREQUESTCONTENTTYPE(content-type); Specifies the content type of the body of the HTTP method request. Product: Base SAS Document: SAS DS2 Language Reference
SETRESPONSEBODYCHARACTERSET Method	package.SETRESPONSEBODYCHARACTERSET('variable'); Specifies the character set to use when decoding the response body. Product: Base SAS Document: SAS DS2 Language Reference
SETSMALLINT Method	package.SETSMALLINT (index, value); Sets the designated parameter to the specified value of type SMALLINT. Product: Base SAS Document: SAS DS2 Language Reference
SETSOCKETTIMEOUT Method	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 Language Reference
SETSTRING Method	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 Language Reference
SETTIME Method	package.SETTIME (index, value); Sets the designated parameter to the specified value of type TIME. Product: Base SAS Document: SAS DS2 Language Reference
SETTIMESTAMP Method	package.SETTIMESTAMP (index, value); Sets the designated parameter to the specified value of type TIMESTAMP. Product: Base SAS Document: SAS DS2 Language Reference
SETTINYINT Method	package.SETTINYINT (index, value); Sets the designated parameter to the specified value of type TINYINT. Product: Base SAS Document: SAS DS2 Language Reference
SETURL Method	package.SETURL('variable'); Specifies the URL to which the HTTP client should connect. Product: Base SAS Document: SAS DS2 Language Reference
SETUSERNAME Method	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 Language Reference
SETVALUE Method	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 Language Reference
SETVARBINARY Method	package.SETVARBINARY (index, value); Sets the designated parameter to the specified value of type VARBINARY. Product: Base SAS Document: SAS DS2 Language Reference
SETVARCHAR Method	package.SETVARCHAR (index, value); Sets the designated parameter to the specified value of type VARCHAR. Product: Base SAS Document: SAS DS2 Language Reference
SORT Method	package.SORT(sortcol, isAscending \| dgSort); Sorts the target data grid. Product: Base SAS Document: SAS DS2 Language Reference
SQRT Method	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 Language Reference
STREAMRESPONSEBODYASBINARY Method	package.STREAMRESPONSEBODYASBINARY(variable, rc); Streams the body, in chunks, from the HTTP response in binary format. Product: Base SAS Document: SAS DS2 Language Reference
STREAMRESPONSEBODYASSTRING Method	package.STREAMRESPONSEBODYASSTRING(variable, rc); Streams the body, in chunks, from the HTTP response in character string format. Product: Base SAS Document: SAS DS2 Language Reference
SUB Method	r=matrix-package-1.SUB(matrix-package-2); Subtracts one matrix from another. Product: Base SAS Document: SAS DS2 Language Reference
SUBSET Method	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 Language Reference
SUBSETBYFILTER Method	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 Language Reference
SUM Method	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 Language Reference
SUMDUP Method	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 Language Reference
SUMINC Method	package.SUMINC(suminc-variable); Specifies a variable that maintains a summary count of hash package keys. Product: Base SAS Document: SAS DS2 Language Reference
TABLE_END Method	TABLE_END( ); Specifies the end of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
TABLE_START Method	TABLE_START(<option-1><,option-2, ...>); Specifies the start of a table. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
TERM Method	METHOD TERM ( ); END; Calls a DS2 system method where program finalizations can take place. Product: Base SAS Document: SAS DS2 Language Reference
TITLE Method	TITLE(DATA:'displayed-data' <,option-1><,option-2, ...>); Adds a title to a page. Product: Base SAS Document: SAS Output Delivery System: Advanced Topics
TOARRAY Method	array-name.TOARRAY(matrix-package); Moves the values from a matrix package into a DS2 array. Product: Base SAS Document: SAS DS2 Language Reference
TOISO8601 Method	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 Language Reference
TOLOCALTIME Method	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 Language Reference
TOPN Method	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 Language Reference
TOTIMESTAMPZ Method	variable=package.TOTIMESTAMPZ (local-time[, time-zone-ID]); Converts local time to a TIMESTAMP string with time zone. Product: Base SAS Document: SAS DS2 Language Reference
TOUTCTIME Method	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 Language Reference
TOVARARRAY Method	variable-array-name.TOVARARRAY(matrix-package); Moves the values from a matrix package into a variable array. Product: Base SAS Document: SAS DS2 Language Reference
TRACE Method	object.TRACE("message"); Logs a TRACE message if the specified logger accepts TRACE messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
TRANS Method	r=matrix-package.TRANS( ); Returns a matrix that transposes the rows and columns of the input matrix. Product: Base SAS Document: SAS DS2 Language Reference
VERSION Method	package.VERSION(); Returns the version of the data grid interface. Product: Base SAS Document: SAS DS2 Language Reference
VIDEO Method	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 Output Delivery System: Advanced Topics
WARN Method	object.WARN("message"); Logs a WARN message if the specified logger accepts WARN messages. Product: Base SAS Document: SAS Viya Logging Facility for SAS Programs and Jobs
WRITEARRAYOPEN Method	package.WRITEARRAYOPEN( ); Writes the open bracket ( [ ) signifying the beginning of an array. Product: Base SAS Document: SAS DS2 Language Reference
WRITEBOOLEANFALSE Method	package.WRITEBOOLEANFALSE( ); Writes a Boolean false value to the text. Product: Base SAS Document: SAS DS2 Language Reference
WRITEBOOLEANTRUE Method	package.WRITEBOOLEANTRUE( ); Writes a Boolean true value to the text. Product: Base SAS Document: SAS DS2 Language Reference
WRITECLOSE Method	package.WRITECLOSE( ); Closes the corresponding object ( } ) or array ( ] ). Product: Base SAS Document: SAS DS2 Language Reference
WRITEDOUBLE Method	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 Language Reference
WRITENULL Method	package.WRITENULL( ); Writes a null value to the text. Product: Base SAS Document: SAS DS2 Language Reference
WRITEOBJOPEN Method	package.WRITEOBJOPEN( ); Writes the open brace ( { ) signifying the beginning of an object. Product: Base SAS Document: SAS DS2 Language Reference
WRITERGETTEXT Method	package.WRITERGETTEXT(rc, json-text); Obtains the JSON text that is produced by the writer. Product: Base SAS Document: SAS DS2 Language Reference
WRITESTRING Method	package.WRITESTRING({[' \| "]}string{[' \| "]}, flags); Writes a string to the JSON text. Product: Base SAS Document: SAS DS2 Language Reference

Last updated: September 16, 2026