Removing State from City Column

[neeloofar]

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

[Kurt_Bremser · Accepted solution]

You are using a dot here

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

while you should be using a comma.

[neeloofar]

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