topic Re: Separating FIPS code in SAS Enterprise Guide

Separating FIPS code

ccaudillo100 — Mon, 25 Jul 2022 18:40:38 GMT

Hello, I am wanting to separate the FIPs code into just state and county number. Any advice?

Shown below is what I am wanting

What I have	What I want
FIPS	State	County
5017	5	17
5041	5	41
20107	20	107
46097	46	97

Re: Separating FIPS code

ballardw — Mon, 25 Jul 2022 18:50:45 GMT

Is your current FIPS variable numeric or character? Do you want character or numeric State and County? If character do you want the leading 0 that should be present to avoid confusion?

Re: Separating FIPS code

Tom — Mon, 25 Jul 2022 18:52:16 GMT

Are those numbers?

data want;
  set have;
  state = int(fips/1000);
  county = mod(fips,1000);
run;

Or strings?

data want;
  set have;
  state=put(int(input(fips,32.)/100),Z2.);
  county=put(mod(input(fips,32.),100),Z3.);
run;

Re: Separating FIPS code

ccaudillo100 — Mon, 25 Jul 2022 18:55:40 GMT

For me it was just numeric but both are helpful for me in the future! Thank you so much!