Date:         Thu, 13 Mar 2003 17:16:53 -0800
Reply-To:     "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Subject:      Re: SCF to state?
Comments: To: "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
In-Reply-To:  <D5170EA5CC08D5119F160002A52CBD1F11F3D8F9@kdcnt4mbx06.kdc.c
              apitalone.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 05:06 PM 03/13/2003 -0500, Wainwright, Andrea wrote:

>Does anyone have a list matching SCF's to state?
>
>(SCF is the first three digits of a ZIP code)
>
>Does SAS have a function?
>

Can't you do it in SAS?

E.g., create a data set of zips (1 - 99999) and create a 3 digit substr
then run the 5 digit zip against the state function, then proc freq state
against the 3 digit substr

Not perfect - should work.

etc.



>********************************
>Andrea Wainwright
>Names One
>Sr. SAS Programmer/Analyst
>
>**************************************************************************
>The information transmitted herewith is sensitive information intended only
>for use by the individual or entity to which it is addressed. If the reader
>of this message is not the intended recipient, you are hereby notified that
>any review, retransmission, dissemination, distribution, copying or other
>use of, or taking of any action in reliance upon this information is
>strictly prohibited. If you have received this communication in error,
>please contact the sender and delete the material from your computer.

------------------------------------------------------------
William W. Viergever          Voice  : (916) 483-8398
Viergever & Associates        Fax    : (916) 486-1488
Sacramento, CA 95825          E-mail : wwvierg@attglobal.net
------------------------------------------------------------