LEFTJOINCOUNTBYFILTER Method
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.
| Returned data type: | INTEGER |
|---|---|
| Notes: | If an error occurs, this method returns -1. |
| Support for this method starts in 2025.02. |
Table of Contents
Syntax
Package Variable
dgLeft
specifies a name that references the datagrid package instance.
Required Arguments
dgRight
specifies the variable name of the right data grid.
filter
specifies the row selection criteria. For more information, see About the Filter Syntax in SAS DS2 Programmer’s Guide.
Optional Arguments
varList
specifies a DS2 varlist that contains the set of DS2 variables to use to resolve the parameterized values in the filter. The parameter resolution code expects the data type of the DS2 varList variable to be consistent with the data type of the associated column.