Check row availability
Determines whether a data set has access to a specific row.
Name | Type | Required | Description |
---|---|---|---|
libref | string<object-id> | true | Specifies the libref for the request. |
sessionId | string<object-id> | true | Specifies the ID of the session. |
tableName | string<object-id> | true | Specifies the table or data set to query. |
Name | Type | Required | Description |
---|---|---|---|
format | boolean | false | Specifies whether to format the data in the cells. Default: true |
formatMissingValues | boolean | false | If set to true, SAS missing values found in the data will be formatted based on the setting of the SAS Option MISSING. Otherwise, a NULL value will be returned. |
includeColumnNames | boolean | false | Specifies whether the first row that is returned consists of column names. |
includeIndex | boolean | false | Specifies whether the first value in the cell is the index of the requested row. Support for this parameter was added in version 2. Default: false |
limit | integer | false | Specifies the maximum number of rows to return. Default: 100 |
returnNumAsString | boolean | false | If set to true, SAS numeric values found in the data will be returned as strings. Default: false |
start | integer | false | Specifies the offset of the first row to return. Default: 0 |
where | string | false | Specifies that a standard SAS WHERE clause was used to return the rows for this request. |