08-21-2012 09:16 AM
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.
08-22-2012 10:49 AM
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.
create table statecodes as
select distinct statename, statecode, state