Data Managment on SAS Viya

Getting started with Data Management (DM) on SAS Viya

Data Management on SAS Viya enables developers to:

Load, import and profile data using an integrated development environment (IDE) or REST APIs.
Cleanse, prepare, and transform your data.
Use functions to manage and provide governance for data assets and their relationships.

SAS Viya DM API reference

Explore the capabilities of SAS Viya Data Management REST APIs

SAS Viya Data Management APIs

SAS Viya DM REST API examples

GitHub repository containing SAS Viya Data Management REST API examples

REST API examples on GitHub

OnDemand webinars

Learn more about SAS Data Management through webinars on sas.com

Go to webinars

Join the conversation!

Ask, find, and share more on the SAS Data Management Community

Data Management Community

View all Data Management blog posts

Subscribe to the Data Management RSS feed

Sample code

The sample code below performs an HTTP GET request to get a table by passing its session identifier as the query parameter sessionId. To see further sample code, visit the samples page on GitHub.

Get table contents


# HTTP GET request to get a table passing their session identifier as the query parameter sessionId

GET /dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES?sessionId=d5272d22-ef57-4r61-lb80-4a98f1l4cc96

# Response application/vnd.sas.data.table+json

{
  "name": "AIRLINES",
  "providerId": "cas",
  "dataSourceId": "cas~fs~cas~fs~CASTestTmp",
  "creationTimeStamp": "2016-03-03T14:59:52.000Z",
  "modifiedTimeStamp": "2016-03-03T14:59:52.000Z",
  "createdBy": "etlguest",
  "modifiedBy": "etlguest",
  "type": "table",
  "attributes": {
    "loaded": true,
    "sourceTableName": null,
    "characterSet": "UTF8",
    "global": true,
    "caslibId": "CASTestTmp",
    "rowCount": 6048,
    "columnCount": 8,
    "sessionId": "feb250ff-15fc-ed44-913c-28c3f311c17b",
    "encoding": "utf-8",
    "serverId": "cas"
  },
  "version": 1,
  "links": \[
    {
      "method": "GET",
      "rel": "self",
      "href": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES",
      "uri": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES",
      "type": "application/vnd.sas.data.table"
    },
    {
      "method": "GET",
      "rel": "sessionScoped",
      "href": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.data.table"
    },
    {
      "method": "GET",
      "rel": "session",
      "href": "/dataSources/providers/cas/sources/cas/sessions/d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/dataSources/providers/cas/sources/cas/sessions/d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.data.session"
    },
    {
      "method": "GET",
      "rel": "up",
      "href": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.collection",
      "itemType": "application/vnd.sas.data.table"
    },
    {
      "method": "GET",
      "rel": "dataSource",
      "href": "/dataSources/providers/cas/sources/cas~fs~CASTestTmp?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/dataSources/providers/cas/sources/cas~fs~CASTestTmp?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.data.source"
    },
   {
      "method": "GET",
      "rel": "provider",
      "href": "/dataTables/providers/cas",
      "uri": "/dataTables/providers/cas",
      "type": "application/vnd.sas.data.provider"
    },
    {
      "method": "GET",
      "rel": "rows",
      "href": "/rowSets/tables/cas~fs~cas~fs~CASTestTmp~fs~AIRLINES/rows?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/rowSets/tables/cas~fs~cas~fs~CASTestTmp~fs~AIRLINES/rows?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.collection",
      "itemType": "application/vnd.sas.data.row.summary"
    },
    {
      "method": "GET",
      "rel": "columns",
      "href": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES/columns?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "uri": "/dataTables/dataSources/cas~fs~cas~fs~CASTestTmp/tables/AIRLINES/columns?sessionId=d5272d22-ef57-4761-8b80-4998f114cc96",
      "type": "application/vnd.sas.collection",
      "itemType": "application/vnd.sas.data.column.summary"
    }
  \]
}

Additional resources

SAS Data Preparation Support site — quick links to learning resources, doc and support channels

SAS Data Quality 3.4: Getting Started — documentation

Exploring SAS Viya: Programming and Data Management — free e-book explaining how to manage and access data files, libraries, and existing SAS code

Give us your feedback