LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 20 Jan 2004 15:16:43 -0800
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: bad value
Comments: To: William Kossack <kossackw@NJC.ORG>


In your situation I have on occasion pasted the suspicious text to notepad or other limited text editor that accepts standard ASCII characters and then back to my editor.

What is your hex sequence? A colon is '3A'x .

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: William Kossack [mailto:kossackw@NJC.ORG] Sent: Tuesday, January 20, 2004 2:54 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: bad value

In trying to clean up the data I'm using the compress function as in x=compress(value,':');

This removes the unwanted colons that appear in all other fields but one of the fields is not affected.

I looked at the data in hex and it appears to be a colon with a space in front. The data is brought in from microsoft access. We tried to filter it in access by using a colon and nothing happened. However it appears as a colon in access

Jack Hamilton wrote:

> My first question would be "What makes you think it contains a colon?" > > Your best option for figuring out what this string contains is probably > the $HEX. format. > > -- > > Manager, Technical Development > Metrics Department, First Health > West Sacramento, California USA > > >>> "William Kossack" <kossackw@NJC.ORG> 01/20/2004 2:10 PM >>> > I've got a string value that appears to have a value that is not what > it > appears. > > It looks like a string containing a colon ':' but sas, access, or > anything I've tried does not see it as a colon so my code never finds > the value so I can remove it > > what is my best option for figuring out what this string contains?.

Back to: Top of message | Previous page | Main SAS-L page