topic Re: Zipcode Reduction in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177436#M13614 <HTML><HEAD></HEAD><BODY><P>There is a whole category in the SAS docu for Zip code related functions.</P><P><A class="active_link" href="https://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm" title="https://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm">SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition</A></P><P></P><P>You could use a function which returns the state based on a zip code. That would allow you to group them.</P></BODY></HTML> Sat, 12 Apr 2014 08:14:37 GMT Patrick 2014-04-12T08:14:37Z Zipcode Reduction https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177435#M13613 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have a dataset which has 17854 distinct levels of zipcodes spread across USA . Is there any function in SAS or any method using which I can reduce the number of levels ? I need to reduce it to less than 500 distinct levels.</P><P></P><P></P><P>Thanks and Regards,</P><P>Minal</P></BODY></HTML> Sat, 12 Apr 2014 05:23:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177435#M13613 MinalMMurkhande 2014-04-12T05:23:11Z Re: Zipcode Reduction https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177436#M13614 <HTML><HEAD></HEAD><BODY><P>There is a whole category in the SAS docu for Zip code related functions.</P><P><A class="active_link" href="https://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm" title="https://support.sas.com/documentation/cdl/en/lefunctionsref/67239/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm">SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition</A></P><P></P><P>You could use a function which returns the state based on a zip code. That would allow you to group them.</P></BODY></HTML> Sat, 12 Apr 2014 08:14:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177436#M13614 Patrick 2014-04-12T08:14:37Z Re: Zipcode Reduction https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177437#M13615 <HTML><HEAD></HEAD><BODY><P>You could use the scf groupings (see: <A href="http://pe.usps.com/text/LabelingLists/L005.htm" title="http://pe.usps.com/text/LabelingLists/L005.htm">USPS.com® - Learn About Integrating with USPS APIs</A> )</P></BODY></HTML> Sat, 12 Apr 2014 14:25:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Zipcode-Reduction/m-p/177437#M13615 art297 2014-04-12T14:25:56Z