topic Re: correct city names in SAS Programming https://communities.sas.com/t5/SAS-Programming/correct-city-names/m-p/175480#M264640 <HTML><HEAD></HEAD><BODY><P>If the Data Quality Server is licensed at your site then you could use function <SPAN class="keyword">DQSTANDARDIZE()</SPAN></P><P><SPAN class="keyword"></SPAN><A class="active_link" href="http://support.sas.com/documentation/cdl/en/dqclref/63171/HTML/default/viewer.htm#p0k705exnmtpgin1xppkpx5f7r30.htm" title="http://support.sas.com/documentation/cdl/en/dqclref/63171/HTML/default/viewer.htm#p0k705exnmtpgin1xppkpx5f7r30.htm">SAS(R) 9.3 Data Quality Server Reference</A></P><P></P><P>Else: It's quite a bit of coding and if you search this forum then you'll find multiple discussions around data cleansing and standardisation.</P></BODY></HTML> Sat, 15 Feb 2014 08:59:01 GMT Patrick 2014-02-15T08:59:01Z correct city names https://communities.sas.com/t5/SAS-Programming/correct-city-names/m-p/175479#M264639 <HTML><HEAD></HEAD><BODY><P>Dear All:</P><P></P><P>Could you please tell me whether there is a function in SAS that can me correct and identify U.S. city and state names?&nbsp; For example, the following is manually entered.&nbsp; Thus, it contains data entry errors.&nbsp; Could you please tell me the best way to clean these city names within SAS.&nbsp; Thank you!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="477"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">MIMNEAPOLIS</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">MN</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">MIDWAY</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">TN</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">BOULDER(BROOMFIELD</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">CO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">CHICACO</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">IL</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">ETIWANDA</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">CA</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">MIDVALE</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">UT</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">MICHIGAN CITY</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">IN</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="339"><P><SPAN style="color: black;">EMERYVILLE</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P><SPAN style="color: black;">CA</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 15 Feb 2014 07:15:12 GMT https://communities.sas.com/t5/SAS-Programming/correct-city-names/m-p/175479#M264639 caveman529 2014-02-15T07:15:12Z Re: correct city names https://communities.sas.com/t5/SAS-Programming/correct-city-names/m-p/175480#M264640 <HTML><HEAD></HEAD><BODY><P>If the Data Quality Server is licensed at your site then you could use function <SPAN class="keyword">DQSTANDARDIZE()</SPAN></P><P><SPAN class="keyword"></SPAN><A class="active_link" href="http://support.sas.com/documentation/cdl/en/dqclref/63171/HTML/default/viewer.htm#p0k705exnmtpgin1xppkpx5f7r30.htm" title="http://support.sas.com/documentation/cdl/en/dqclref/63171/HTML/default/viewer.htm#p0k705exnmtpgin1xppkpx5f7r30.htm">SAS(R) 9.3 Data Quality Server Reference</A></P><P></P><P>Else: It's quite a bit of coding and if you search this forum then you'll find multiple discussions around data cleansing and standardisation.</P></BODY></HTML> Sat, 15 Feb 2014 08:59:01 GMT https://communities.sas.com/t5/SAS-Programming/correct-city-names/m-p/175480#M264640 Patrick 2014-02-15T08:59:01Z