Date: Fri, 1 Nov 2002 18:21:42 -0600
Reply-To: Robert Saunders <robert.c.saunders@VANDERBILT.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Robert Saunders <robert.c.saunders@VANDERBILT.EDU>
Subject: an inverse of FIPNAME() or STNAME()
Content-Type: text/plain; charset="us-ascii"; format=flowed
I have STATE in state name form (e.g., 'MARYLAND') instead of postal codes
(e.g., 'MD'), I would like to convert the name to a postal code.
The ST functions (STNAME,STFIPS) convert postal codes to either FIPS
numbers or state names, but nothing goes the other direction.
So, I thought about converting my state name to a FIPS number and then
using FIPSTATE() to make the postal code. However, I don't see a way to
convert from state name to the FIPS number.
Thanks,
r
|