Hello Experts,
Please, I would like to know, if you have created some sas programs and templates for the data quality Dimensions : COMPLETENESS,UNIQUENESS,TIMELINESS,VALIDITY,ACCURACY,CONSISTENCY
In order to enhance the data quality reports ?
Are there any SAS implementions for the data quality dimensions as specified in the standard : BCBS 239 ?
Internet searches for
SAS BCBS 239
finds lots of hits
Thank very much for your answer.
As a part of the creation of the six data quality Dimensions (COMPLETENESS, UNIQUENESS, TIMELINESS, VALIDITY, ACCURACY, CONSISTENCY) via SAS, there are three components that will be involved in the process of the generation of the Data Quality Report:
It seems clear that, there is a strong dependency between the Input Design and SAS program (to run with less coding and keeping more transparency). In order to create by SAS an automatic Data Quality report.
Consequently, are there any general solution that have been proposed for both the Input Design and SAS program?
Thank you very much.
I am referring to the use of the Base SAS to do data quality report with the six data quality Dimensions: COMPLETENESS, UNIQUENESS, TIMELINESS, VALIDITY, ACCURACY, CONSISTENCY
Thank you very much for these useful and details information.
That’s very kind from you.
AS you said ““that is not a trivial task, but can be done, it just takes some time”
That’s right; and, in order to find a general solution, the key could be in the “input Design” that will be running in SAS Program.
As you know, the input design implemented the business rules and easily understood by the functional and Technical; and loaded with less complexity in SAS.
Therefore, in many cases, the inputs design, it is combination of three components:
The appearance of the three components in the “input design” in a smart way could solve the issue
As for input , That's right . Instead, the Output design could have nearly the same format ?
In order to apply the 6 Data quality dimensions on N variables(for exemple : 1000 variables),
How much time do you estimate to do this job?
Is there any method for estimating the time necessary to do this job ?
Thank you very much.
It's a good idea
@PaigeMiller : I think, you mean this link https://blogs.sas.com/content/sascom/tag/bcbs-239/
I have read these 14 principles, I am interested by their implementation in SAS.
Thereby, could the scope of the data quality for the Banking credit risk data, defined by the banking supervisory, "became" the same as “CDEs=Critical Data elements” ? in order to limit the scope of the data quality.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.