topic Re: Profiling Details in Viya Data Explorer in SAS Data Management

Profiling Details in Viya Data Explorer

snathju — Tue, 10 Apr 2018 16:01:56 GMT

Hi ,

In the profile section of the data explorer I can see a particular column called "Pattern Count". Can anyone please help me understand the meaning of that column.

Thanks and Regards

Subhojit

Re: Profiling Details in Viya Data Explorer

LouGalway_sas — Tue, 10 Apr 2018 16:10:20 GMT

Subhojit,

Pattern count is the number of different distinct patterns in the column.

Regards,

Lou

Re: Profiling Details in Viya Data Explorer

snathju — Tue, 10 Apr 2018 16:18:37 GMT

Could you please explain in a bit more details .

Say I have a table of 10 records , and a particular column of that table
has the following entries:

a , b, c, a , c ,b, a, b, b, c

what will be the pattern count for this

Thanks and regards
Subhojit

Re: Profiling Details in Viya Data Explorer

Erik_Zencos — Wed, 11 Apr 2018 13:47:53 GMT

In your example that would only be one pattern count (length one, lower case). Think of a field containing state with the following content:

NY, ny, New York, new york

This field have four patterns, if you only expect the field to have a two letters (upper case), you can quickly see that you have a data quality issue.