Data Controller Documentation

Overview

The Data Controller for SAS® enables users to self serve their data changes, and for data owners to retain control over those updates by reviewing and approving them.

Online resources

The following resources contain additional information on the Data Controller:

• DC Overview Presentation
• Data Controller LinkedIn page
• Data Controller website
• Data Controller flyer (front / back)
• Data Controller videos
• Data Controller SAS Code
• Data Controller Download

Product Features

Data Controller is regularly updated with new features. If you see something that is not listed, and we agree it would be useful, you can engage us with Developer Days to build the feature in.

• Excel uploads - drag & drop directly into SAS. All versions of excel supported.
• Data Lineage - at both table and column level, export as image or CSV
• Data Validation Rules - both automatic and user defined
• Data Dictionary - map data definitions and ownership
• Data Catalog - including primary key extraction
• DDL generator - in SAS, TSQL and PGSQL flavours
• Workflow - run a SAS program before or after an edit or approval
• Role based security - editors, approvers, administrators
• Data Models supported: SCD2, Bitemporal, composite keys, retained keys, update and full replace
• Email Alerts for data changes
• Row Level Security
• Excel formula support
• Dynamic cell dropdown
• Works on ALL flavours of SAS (Foundation, EBI, Viya)