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 | |
| Saint Albert | St Albert | |
| Saint Jean Baptiste | St Jean Baptiste | |
| Remarks | The City 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 |
Doc ID: QKBCI_ENCAN_Std_City.html |