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,
SK
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;
Thank you very much for the clarification. It works.
very much appreciated.
Thanks,
Saravanan
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.