Thank you very much. It's a good idea  ... View more

@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. ... View more

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 ?    ... View more

As for input , That's right . Instead, the Output design could have nearly the same format ? ... View more

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: Set of fields to apply the data quality Data Quality Dimensions to apply: COMPLETENESS, UNIQUENESS, TIMELINESS, VALIDITY, ACCURACY, CONSISTENCY Set of reference variables used in the compare. The appearance of the three components in the “input design” in a smart way could solve the issue    ... View more

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 ... View more

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:   Input Design SAS Program Output (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? ... View more

Thank your for your answer As an exemple, we can start by these data sets   Table : One idn var 1 3 2 10   Table : Two idn var 1 8 3 7   When, we use this code proc compare base=one comp=two; out=res outnoequal outbase outcomp; id idn; run;   getting the output   _TYPE_ obs Var base 1 3 compare 1 8 base 2 10 compare 3 7     I want this output _TYPE_ obs Var base 1 3 compare 1 8     ... View more

@ballardw: Thank you very much.  Yes, it is  related to reading a text file. As you know, it is indpendant of code, it is really a data problem   I must have this data input ID   name         comments 1     Cook          treatement R10 Beta45   With this matter, I will have ID   name         comments 1     Cook          treatement ùR10 Beta45   I think some unix commands can resolve the problem( my sas is under unix)       ... View more