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 (November 2002, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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()
Comments: To: sas-l@UGA.CC.UGA.EDU
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


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