We're excited to announce the new features in the v4 release:
As well as the following fixes:
We've also completely refactored the underlying engine for Dynamic Cell Dropdowns to make it faster, more robust, and easier to test.
We're also pleased to report that all the backend SAS Services now run with strict mode enabled, ensuring that SAS will 'fail fast' in case of data issues.
Some more background on our major features:
Data Controller allows you to view and edit formats directly in the catalog. It does not require the maintenance of a secondary "cntlin" table! This ensures that the formats you are viewing / editing are indeed, the latest ones.
All of the usual Data Controller features are available for formats too, including:
Information on configuration is available in the documentation
Did you know that, in addition to a regular missing value in SAS (
.), there are 27 other types of missing? They are represented by the letters a-z and an underscore (
These values can now be both viewed and edited in Data Controller following an update to the SASjs Adapter.
There is nothing extra to configure for special SAS numerics - they are simply available by default, for numeric cells.
Previously, transactional changes made to tables in Data Controller could only be tracked by means of individual CSV files. A user could (and still can) navigate to the HISTORY tab, find their change, and download a zip file containing all relevant information such as the original excel that was uploaded, SAS logs, the changed records (CSV) and the staging dataset.
The issue is that this information did not capture the original, unchanged records (necessary to support rollbacks), nor did it provide a central point for querying the entire change history of a particular variable / record over time.
These issues are now resolved with the introduction of the MPE_AUDIT table.
The macro used to load this table is open source and available here.
We continue to update and improve Data Controller. Upcoming features include:
You can track our progress, and submit ideas, here.
Did you know Data Controller is free for up to 5 users? Contact us for your copy!