LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
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.


>******************************** >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 : ------------------------------------------------------------

Back to: Top of message | Previous page | Main SAS-L page