This Data Quality (DQ) and Data Governance (DG) repository is meant to be a clearinghouse of SAS Viya and SAS9 resources. Within this repository you will find many resources covering many different data quality and governance topics. A few of these resources are:
- (DataFlux) DM Studio jobs showing how to use:
- Parsing, Standardization, Right Fielding, Loqate, Entity Resolution (match codes, clustering, survivorship)
- EEL code samples
- Process Job Samples
- Business Rules
- ...
- SAS Studio Flows showing how to use:
- Clean and Parse data steps, Loqate, Entity Resolution (Match codes, clustering, survivorship)
- EEL code samples
- ID code samples
- Geocoding with PROC Geocode
- Data Masking
- DataFlux sample jobs that have been converted over to SAS Studio Flows
- VA Reports
- Loqate
- Clustering
- Profiling
- Business Data Network extracts
- Custom QKB Definitions and QKBs
- ...
This repository's goal is not just to put a job in a folder, but to put the sample data and PPT or readme file along with any other required resources so that users can get the job up and running for demos or personal training.
List of assets in this repository
We welcome contributions! We are hoping we can get everyone to look through their demo assets, projects, etc. and if you have something that you have been asked for in the past please consider contributing it to this project.
Please read CONTRIBUTING.md for details on how to submit contributions to this project.
This project is licensed under the Apache 2.0 License.
SAS Studio
- Can SAS/DataFlux DMStudio Data Jobs be replicated in SAS Viya as SAS Studio Flows?
- Migrating SAS Studio Flows containing Custom Steps
- Customize Your Way to Success: Using Custom Steps From the SAS GitHub
3rd Party Metadata
- OpenMetadata and the SAS Viya Connector
- Boost Data Governance with SAS Information Catalog OpenMetadata Connector
Quality Knowledge Base (QKB)
- SAS Viya: Create SAS Quality Knowledge Base (QKB) Definition Reference Tables for Customized QKB
- SAS Viya: Add a Customized Quality Knowledge Base (QKB) to CAS and SAS Compute
- SAS Viya: Using a SAS Quality Knowledge Base (QKB) Reference Table in a Custom Step
DataFlux Expression Language (EEL)
- SAS Viya: Multi-Rule Data Monitoring Using PROC EEL in SAS Code and Custom Steps
- SAS Viya: Set-based Data Monitoring Using PROC EEL in SAS Code and Custom Steps
- SAS Viya: Group-based Data Monitoring Using PROC EEL in SAS Code and Custom Steps
- SAS Viya: Row-based Data Monitoring Using PROC EEL in SAS Code and Custom Steps