Removing State from City Column

neeloofar — Thu, 10 Dec 2020 15:07:35 GMT

Good Morning,

I'm wondering if anyone can give me direction on how to remove the state from where my city column is listed.

^That is the first data line, I am trying to remove Mississippi and just have Blue Mountain independently.

Here is my code,

DATA WORK.C;

SET Hyp.C ( KEEP = SocSecNum FirstInit MiddleInit LastInit CityState ZipCd
RENAME = (SocSecNum = SSN )
);

LENGTH Inits $3
City $20
StateCd$2;

Inits = COMPRESS(CATS(FirstInit, MiddleInit, LastInit), '.');

City = SCAN(CityState,1,'.');

Format StateCd $StateCd.;

RUN;

This is the first two observations that my code produces:

Thanks in advance for the advice.

Best,

Neeloo

Re: Removing State from City Column

Kurt_Bremser — Thu, 05 Nov 2020 18:06:07 GMT

You are using a dot here

City = SCAN(CityState,1,'.');

while you should be using a comma.

neeloofar — Thu, 05 Nov 2020 18:19:14 GMT

Wow, so simple, I overlooked it, thank you so much!!