v5.0 Release: Column Level Security
v5.0 Release: Column Level Security
July 11, 2022 / in Data Catalog, Data Lineage, Releases, Special Missings / by Allan Bowe

v5 Release

The big news items for Data Controller since the last release are:

  • Support for Viya 4
  • Support for Base SAS (on SASjs Server)
  • Column Level Security (choose VIEWable or EDITable columns for specific groups)

Version 5 also brings some additional goodies!

  • One click Data Catalog and Table Lineage refresh on install
  • Support for Swedish (and other) Locales
  • Deploy Demo DC without Admin Rights
  • Configurable Audit History Location
  • Password Protected Excel Import
  • Submit reason in HISTORY
  • Shaded PK in VIEW

New Features

Column Level Security

Thanks to the new MPE_COLUMN_LEVEL_SECURITY table it is possible to configure:

  • Which columns should be VISIBLE in VIEW mode
  • Which columns should be EDITABLE in EDIT mode
  • Which columns should be HIDDEN in EDIT mode

Rules apply to the specified DC Groups. When this mode is activated, it is not possible to:

  • Add or Delete records
  • Modify the Primary Key
  • Upload files (eg CSV or Excel)

More information is available in the documentation.

One click Data Catalog and Table Lineage on Install

Previously it was necessary to dig out the relevant services to refresh the Data Catalog (all versions) or the Table Lineage (SAS 9 EBI only).

We now present links during the deploy process to speed up the initialisation of these features.

Support for Swedish (and other) Locales

In Viya and SASjs Server, the session encoding is always UTF-8. For SAS 9 EBI however, the session can vary depending on the Locale - from WLATIN1 through to WLATIN9 and beyond.

Thanks to some updates in our JSON generator we can now support UTF-8 outputs even where the SAS session is not UTF-8.

Deploy Demo DC without Admin Rights

This has always been possible in Viya and SASjs Server (assuming you can write to the necessary folders) but for SAS 9 EBI it was previously necessary to have SAS Management Console or Data Integration Studio (or access to Batch Tools) in order to import the SPK.

Our new deployment process for SAS 9 EBI simply involves running a SAS Program, meaning that you can deploy to any folder in metadata (as a streaming app).

For a full deploy though, you would still need access to the Web Server, in order to deploy the frontend...

Configurable Audit History Location

Since the version 4 release we have been capturing ALL change history in a single audit table.

This has resulted in some voluminous output!

It is now possible (on a per-table basis) to configure alternative audit tables, or to switch the feature off completely.

Password Protected Excel Import

If your Excel is password protected, just provide the password during import to unlock and ingest it. More information here.


We are informated that sometimes you would like to have the option to have FEWER options for inputting data! Who are we to argue. You can now disable the 'EDIT RECORD' dialog using this option.

Submit Reason in HISTORY

We have replaced the "groups" column in the SUBMITTED / APPROVE / HISTORY tabs with 'SUBMIT_REASON' - which is even more reason to describe your submits!

Shaded PK in VIEW

Using this macro we now automagically colour the primary key fields in the VIEW menu.

The logic differs from the EDIT menu in that it looks for an actual, UNIQUE + MISSING index on the target table, as opposed to picking up the BUSKEY from MPE_TABLES.


We zapped a few of these, notable ones:

  • Multiple Approver workflow not working
  • Special Missings in cell dropdowns
  • Special Missings in filters (BETWEEN + IN)
  • Special Missings in CSV uploads
  • Support for leading blanks in Excel uploads
  • Improved Streaming App support under strict CSP policy

Model Changes

We've made the following changes to the data model:

  • Dropped MPE_APPROVALS table
  • Added MPE_SUBMIT table

Roadmap (11th July 2022)

The following items are on our radar for 2022:

  • Admin Screen
  • Data Rollback (from UI)
  • Data Controller API

If you'd like to see something extra or something else entirely, you can also engage us to build it for you! Our team specialises in SAS App Development.

Data Controller

Data Controller is a product of 4GL Apps, a brand of Bowe IO Ltd, which is a UK company with a focus on SAS Software, Apps, and Services.

Other Resources

Visit our educational and fun SAS® software quiz Sasensei and test your knowledge of SAS topics.