Date:         Wed, 27 May 2009 03:52:06 -0700
Reply-To:     Akramx <akram.chriai@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Akramx <akram.chriai@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: removing a string
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 27 mai, 11:53, hummingbird10...@HOTMAIL.COM (Annie Lee) wrote:
> Hi,
>
> I would like to extract and remove a string (&) from a variable.
> I would appreciate it if anyone can offer any advice!
>
> Data:
>
> num          Dept
> 1            IT HR
> 2            IT Education & Service
> 3            IT Catering
> 4            Media HR
> 5            Media Receiving & Delivery
>
> Results:
>
> num          Dept
> 1            IT HR
> 2            IT Education & Service
> 3            IT Catering
> 4            Media HR
> 5            Media Receiving & Delivery

Hi,
Try to use this: NewDept=compress(Dept,'&');