The third part of my data governance primer series addresses data quality analysis. Don’t even start a data quality analysis until you have completed the first two steps of your root cause analysis: investigate and prioritize any potential causative factors, then start your metadata assessment. Otherwise, you may be misled
Uncategorized
A data governance primer, part 3: Data quality analysis and the diamond in the rough
Assign the diagonal elements of a matrix
SAS/IML programmers know that the VECDIAG matrix can be used to extract the diagonal elements of a matrix. For example, the following statements extract the diagonal of a 3 x 3 matrix: proc iml; m = {1 2 3, 4 5 6, 7 8 9}; v = vecdiag(m); /* v = {1,5,9}
A custom task to check your data cardinality
The other day I showed how to check your data cardinality by using a simple SAS program. I also promised to provide a custom task that makes the process even easier within SAS Enterprise Guide. Today I'm delivering on that promise. I've just added the custom task to the support.sas.com