topic Re: SAS Function-- Convert state name to two character USPS state code in SAS Programming

SAS Function-- Convert state name to two character USPS state code

Saravanan — Tue, 21 Aug 2012 13:16:37 GMT

Hi,

Is there any SAS function which converts state name to two character US postal code?

For example, North Carolina should give 37

i do not have abbreviated state name to use stfips function.

Thanks,

Re: SAS Function-- Convert state name to two character USPS state code

ballardw — Wed, 22 Aug 2012 14:49:43 GMT

37 is FIPS not POSTAL Code. Postal would be NC.

The dataset SASHELP.Zipcode has full name 2 letter postal code and 2 digit FIPS codes, so you could build a look up data set and either create an informat or use merge or SQL to join to your data.

proc sql;

create table statecodes as

select distinct statename, statecode, state

from sashelp.zipcode;

quit;

Re: SAS Function-- Convert state name to two character USPS state code

Saravanan — Wed, 22 Aug 2012 15:42:46 GMT

Thank you very much for the clarification. It works.

very much appreciated.

Thanks,

Saravanan