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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.