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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.