Date:         Fri, 12 Mar 2010 04:02:30 -0500
Reply-To:     Jim Groeneveld <jim.1stat@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <jim.1stat@YAHOO.COM>
Subject:      Re: Substr or Compress-Remove a Character

Hi Kim,

DATA Birth;
  BirthPlace = 'XCALIFORNIA';
  BirthPlace = SUBSTR(BirthPlace, 1+(UPCASE(BirthPlace)=:'X'));
  PUT BirthPlace=;
RUN;

Regards - Jim.
--
Jim Groeneveld, Netherlands
Statistician, SAS consultant
http://jim.groeneveld.eu.tf

My computer sorrily regrets to communicate our nogo to SGF-2010.


On Thu, 11 Mar 2010 12:20:14 -0500, Kim Brown <kibrown@LADHS.ORG> wrote:

>Hello,
>I have 2 million records with birth places, a third of the records the
>location has an 'X' as the first character. Is there a way to remove
>the 'X'? I tried to use a compress function.
>birthplace4=compress(birthplace3, 'X')--this removed all 'X' from every
>place. Any help is appreciated. Thanks, Kim
>
>I have this:
>XARIZONA
>         XARKANSAS
>         XCALIFORNIA
>         XCOLORADO
>         XCONNECTICUT
>         XFLORIDA
>         XGEORGIA
>         XILLINOIS
>         XINDIANA
>         XKANSAS
>         XKENTUCKY
>         XLOUISIANA
>         XMARYLAND
>         XMASSACHUSETTS
>         XMICHIGAN
>         XMISSISSIPPI
>         XMISSOURI
>         XNEVADA
>         XNEW JERSEY
>         XNEW MEXICO
>         XNEW YORK
>         XOHIO
>         XOKLAHOMA
>XTEXAS
>
>Want:
>ARIZONA
>          ARKANSAS
>          CALIFORNIA
>          COLORADO
>          CONNECTICUT
>          FLORIDA
>          GEORGIA
>          ILLINOIS
>          INDIANA
>          KANSAS
>          KENTUCKY
>          LOUISIANA
>          MARYLAND
>          MASSACHUSETTS
>          MICHIGAN
>          MISSISSIPPI
>          MISSOURI
>          NEVADA
>          NEW JERSEY
>          NEW ME ICO
>          NEW YORK
>          OHIO
>          OKLAHOMA
> TEXAS