topic Re: List available standardization definitions for a SAS Quality Knowledge Base in SAS Programming

List available standardization definitions for a SAS Quality Knowledge Base

ojaro — Wed, 15 Jul 2020 12:59:42 GMT

Hi all,

Is there a way to list all available standardization definitions for a SAS Quality Knowledge Base?

I am trying to use the following definition to standardize my phone numbers:

https://support.sas.com/documentation/onlinedoc/qkb/31/QKBCI31/Help/qkb-help.html#qkbci-engbr/qkbci-engbr-std-phone-cntry.html

My code looks like below:

options DQLOCALE=(ENGBR);
data work.claim_telephone;
	set work.claim_telephone;
	phoneNumberStd = dqStandardize(phoneNumber, 'Phone (with Country Code)');
run;

I assume it is not working because I should call the definition with something else than "Phone (with Country Code)"?

Best regards,

Olli

Re: List available standardization definitions for a SAS Quality Knowledge Base

ChrisNZ — Thu, 16 Jul 2020 10:11:35 GMT

See chapter 7 (page 77).

https://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_912/dataqual_ref_8007.pdf

Re: List available standardization definitions for a SAS Quality Knowledge Base

ojaro — Thu, 16 Jul 2020 13:06:56 GMT

Looks like this macro was what I was after:

%dqputloc(enusa);