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
... View more