City - State/Province - Postal Code (International)

SAS Quality Knowledge Base for Contact Information 27

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 a 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
	St-Albert QC J0A 1E0	SAINT-ALBERT QC CA-J0A1E0
	St-Jean-Baptiste QC J0L 2B0	SAINT-JEAN-BAPTISTE QC CA-J0L2B0
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 French 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.