Date:         Thu, 13 Mar 2003 18:07:46 -0500
Reply-To:     "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
Subject:      Re: SCF to state?
Comments: To: "Krone, Ben --- Manager - Operations Systems --- GO"
          <Ben.Krone@freight.fedex.com>
Content-Type: text/plain; charset="iso-8859-1"

Thanks, got me most of the way there.  Unfortunately not all zip codes
ending in 01 are legit and SAS gives an error, but I generated a dataset
with every number between 0 and 99999, converted to character, packed in
leading 0's, and the create a variable scf=substr(zip,1,3) and a variable
state=zipstate(zip).

Then a proc freq on scf*state/list got me the list I needed.

Was quite a fun exercise and a good reminder of some functions that I don't
use very often.

-----Original Message-----
From: Krone, Ben --- Manager - Operations Systems --- GO
Sent: Thursday, March 13, 2003 5:21 PM
To: Wainwright, Andrea
Subject: RE: SCF to state?


Andrea,

Zipstate function only works on 5-digit zips, but you could probably do
something like:

data scfdata;
  set scfdata;
  state = zipstate(scfvar||'01');
run;

HTH
Ben

-----Original Message-----
From: Wainwright, Andrea
Sent: Thursday, March 13, 2003 4:07 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SCF to state?


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?


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


**********************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
****************************************************************

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