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
St-Albert QC J0A 1E0 Saint-Albert QC J0A 1E0
St-Jean-Baptiste QC J0L 2B0 Saint-Jean-Baptiste QC J0L 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 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.

 

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

Doc ID: QKBCI_FRCAN_Std_CSPPC.html