Check row set availability
Determines whether a row set is available on for a data set.
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 |
---|---|---|---|
columnDetail | string | false | Specifies the level of column information to return. Allowed values: namesdetailsummary Default: names |
columnNaturalOrder | boolean | false | When includeColumns is specified, a value of true for columnNaturalOrder specifies that the cells of the row set are returned in the order in which they occur in the data set instead of in the order that is specified by includeColumns. Default: false |
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. |
includeColumns | string | false | Specifies a comma separated list of columns to include in the row set. If you do not specify a list, all columns are returned. The order of the column names in the list is the order in which the cells of the row set are in as well. |
limit | integer | false | Specifies the maximum number of rows to return. The default value is "10". |
returnNumAsString | boolean | false | If set to true, SAS numeric values found in the data will be returned as strings. Default: false |
sortBy | string<sort-criteria> | false | Sets the sort order for the returned row set. |
start | integer | false | Specifies the offset of the first row to return. The default value is "0". |
where | string | false | Specifies that a standard SAS WHERE clause was used to build the row set for this request. |