Get all frequency values for a column

post/servers/{serverName}/caslibs/{caslibName}/tables/{tableName}/columns/{columnName}/frequency

Internal-Use Only

Creates a CAS table containing the frequency for a single column in the loaded CAS table. The result is output to the new CAS table requested by the passed query parameters.

Request Samples

Response Samples

201
application/vnd.sas.cas.table+json
1{
2  "version": 3,
3  "name": "CUSTOMERS",
4  "tableReference": {
5    "tableUri": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
6    "sessionId": "ad0b5228-cc89-874c-8893-c1c420f6e0cb",
7    "sourceCaslibName": "CASUSER",
8    "sourceTableName": "CUSTOMERS.sashdat"
9  },
10  "serverName": "cas-shared-default",
11  "caslibName": "CASUSER",
12  "scope": "global",
13  "state": "loaded",
14  "repeated": false,
15  "created": "2017-04-11T17:17:15.373000Z",
16  "lastModified": "2017-04-11T18:50:42.106000Z",
17  "createdBy": "userid",
18  "lastModifiedBy": "userid",
19  "lastAccessed": "2017-04-11T19:12:13.102000Z",
20  "sourceLastModified": "2017-03-12T03:43:22.101000Z",
21  "label": "My table label",
22  "rowCount": 160,
23  "columnCount": 9,
24  "characterSet": "UTF8",
25  "encoding": "utf-8",
26  "disconnected": false,
27  "attributes": {
28    "owner": "someuser",
29    "size": 115704,
30    "encryption": "NONE",
31    "time": "18Nov2016:15:27:28",
32    "group": "users"
33  },
34  "links": [
35    {
36      "method": "GET",
37      "rel": "up",
38      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables",
39      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables",
40      "type": "application/vnd.sas.collection",
41      "itemType": "application/vnd.sas.cas.table"
42    },
43    {
44      "method": "GET",
45      "rel": "self",
46      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
47      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
48      "type": "application/vnd.sas.cas.table"
49    },
50    {
51      "method": "DELETE",
52      "rel": "delete",
53      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS",
54      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS"
55    },
56    {
57      "method": "PUT",
58      "rel": "updateState",
59      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/state",
60      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/state"
61    },
62    {
63      "method": "PUT",
64      "rel": "updateScope",
65      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/scope",
66      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/scope",
67      "responseType": "application/json;text/plain"
68    },
69    {
70      "method": "GET",
71      "rel": "summaryStatistics",
72      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/summaryStatistics",
73      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/summaryStatistics",
74      "type": "application/vnd.sas.collection",
75      "itemType": "application/vnd.sas.cas.column"
76    },
77    {
78      "method": "GET",
79      "rel": "distinctCount",
80      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/distinctCount",
81      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/distinctCount",
82      "type": "application/vnd.sas.collection",
83      "itemType": "application/vnd.sas.cas.column"
84    },
85    {
86      "method": "GET",
87      "rel": "columns",
88      "href": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/columns",
89      "uri": "/casManagement/servers/cas-shared-default/caslibs/CASUSER/tables/CUSTOMERS/columns",
90      "type": "application/vnd.sas.collection",
91      "itemType": "application/vnd.sas.cas.column"
92    },
93    {
94      "method": "GET",
95      "rel": "dataTable",
96      "href": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
97      "uri": "/dataTables/dataSources/cas~fs~cas-shared-default~fs~CASUSER/tables/CUSTOMERS",
98      "type": "application/vnd.sas.data.table"
99    }
100  ]
101}

Path Parameters

Name	Type	Required	Description
caslibName	string	true	The name of the Caslib containing the input table.
columnName	string	true	The name of column for which frequency info is requested.
serverName	string	true	The name of the server containing the input Caslib.
tableName	string	true	The name of the input table for which column frequency is requested.

Query Parameters

Name	Type	Required	Description
outputTableScope	string	false	The scope of the output table. Valid values in include session and global. Defaults to global. Global caslibs can contain global and session tables. Session caslibs can only contain session tables.
sessionId	string	false	The optional ID of the session containing the Caslib. If unspecified, only tables in global caslibs will be accessible.
sortBy	string	false	The optional order by which to sort the results. If omitted, sorting is not performed. An ascending sort is more performant than a descending sort. Valid sort column names include: Frequency and FmtVar. Valid sort order values include: ascending and descending. When sorting by Frequency, the FmtVar is automatically used as the secondary ascending sort. Sample sortBy values: Value of sortByResult Frequency:ascendingsort by ascending Frequency, ascending FmtVar Frequency:descendingsort by descending Frequency, ascending FmtVar FmtVar:ascendingsort by ascending FmtVar FmtVar:descendingsort by descending FmtVar
outputCaslibName	string	true	The name of the Caslib for the output CAS table.
outputTableName	string	true	The name of output CAS table. The following columns of interest will be present in the output table: Column NameContent Frequency The frequency of the value FmtVar The formatted value CharVar For a character column, the unformatted value NumVar For a numeric column, the unformatted value

Responses

Status	Meaning	Description
201	Created	The table details for the output table was returned.	Schema
404	Not Found	The requested CAS server or Caslib does not exist.
409	Conflict	The request could not be completed due to a conflict with the current state of the resource. Details are included in the response body.