SAS Quality Knowledge Base for Contact Information 27

City - State/Province - Postal Code

Standardization Definition

City - State/Province - Postal Code
Description The City - State/Province - Postal Code standardization definition standardizes last line address information.
Examples Input Output
calgary alberta T2A2R1 Calgary AB T2A 2R1
S9H 3W4 Toronto ON Toronto ON S9H 3W4
Toronto, ON, S9H 3W4 Toronto ON S9H 3W4
E Angus QC J0B 1A0 East Angus QC J0B 1A0
DDO QC H8Y 3B8 Dollard-des-Ormeaux QC H8Y 3B8
Toronto ON CA-S9H3W4 Toronto ON S9H 3W4
Saint Albert AB T8N 1M9 St Albert AB T8N 1M9
Saint Jean Baptiste MB R0G 2B0 St Jean Baptiste MB R0G 2B0
Remarks The City - State/Province - Postal Code standardization definition standardizes city names according to the Canada Post SERP database. If two conflicting spellings exist as the SERP standard, this definition selects the English spelling, as seen in the final two examples. Common city abbreviations are expanded into full names. Accents and hyphens are added onto French city names, where applicable.

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: QKBCI_ENCAN_Std_CSPPC.html