List available standardization definitions for a SAS Quality Knowledge Base

[ojaro]

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

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

[ChrisNZ]

See chapter 7 (page 77).

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

[ojaro · Accepted solution]

Looks like this macro was what I was after:

%dqputloc(enusa);