SAS Quality Knowledge Base for Contact Information 27
| City | ||
|---|---|---|
| Description | The City standardization definition standardizes city names. | |
| Examples | Input | Output |
| vancouver | Vancouver | |
| TORONTO | Toronto | |
| T.O. | Toronto | |
| NOTL | Niagara on the Lake | |
| DDO | Dollard-des-Ormeaux | |
| Sherbrooke (Ascot) | Ascot, Sherbrooke | |
| Mt-Saint-Grégoire | Mont-Saint-Grégoire | |
| Montreal | Montréal | |
| Notre Dame | Notre-Dame | |
| St-Albert | Saint-Albert | |
| St-Jean-Baptiste | Saint-Jean-Baptiste | |
| Remarks | The City standardization defintion 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 |
Doc ID: QKBCI_FRCAN_Std_City.html |