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

Jim,

It gets easier than that, its one of the few times I have seen a good case
to use the substr function on the left hand side of the =.

Data _Null_ ;
Var = 'XTEXAS' ;
Put Var= ;
Substr( Var , 1 , 1 ) = '' ;
Put Var= ;
Run ;

Toby Dunn




On Fri, 12 Mar 2010 04:02:30 -0500, Jim Groeneveld <jim.1stat@YAHOO.COM>
wrote:

>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