SAS Quality Knowledge Base for Contact Information 27

City - State/Province - Postal Code (International)

Standardization Definition

City - State/Province - Postal Code (International)
Description The City - State/Province - Postal Code (International) standardization definition standardizes last line address information and formats Postal Code with country code prefix.
Examples Input Output
calgary alberta T2A 2R1 CALGARY AB  CA-T2A2R1
S9H 3W4 Toronto ON TORONTO ON  CA-S9H3W4
Toronto, ON, S9H 3W4 TORONTO ON  CA-S9H3W4
E Angus QC J0B 1A0 EAST ANGUS QC  CA-J0B1A0
DDO QC H8Y 3B8 DOLLARD-DES-ORMEAUX QC  CA-H8Y3B8
Toronto ON CN S9H3W4 TORONTO ON  CA-S9H3W4
Toronto ON CDN-S9H3W4 TORONTO ON  CA-S9H3W4
Saint Albert AB T8N 1M9 ST ALBERT AB  CA-T8N1M9
Saint Jean Baptiste MB R0G 2B0 ST JEAN BAPTISTE MB  CA-R0G2B0
Remarks The City - State/Province - Postal Code (International) 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. Note that two spaces are inserted before the postal code, per the Universal Postal Union (UPU) standard for addressing mail for international use.