Actually, translate is not necessary, compress is enough:
> -----Original Message-----
> From: Huang, Ya
> Sent: Monday, December 13, 1999 12:32 PM
> To: 'Micheal Quill'; SAS-L@LISTSERV.UGA.EDU
> Subject: RE: Removing non - printable chars from fields
> try translate and then compress:
> Ya Huang
> Organon Inc.
> > -----Original Message-----
> > From: Micheal Quill [mailto:michaelq@DEMON.NET]
> > Sent: Monday, December 13, 1999 11:09 AM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: Removing non - printable chars from fields
> > Hi,
> > I have loaded in a text file into a table and when I use
> view table to
> > look at the table I have the following situation.
> > Name Age
> > joe-blogs 12
> > joe-blogs| 12
> > Now the likely culprit is the original text files were current.
> > However I don't really want to go back and find the
> original files if
> > I can avoid it . The originals are 30 gzip's that are 1 gig each
> > uncompressed.
> > Using a HEX editor on the SAS data files we get the following
> > 2D 31 20
> > 2D 31 0D
> > Ignore the 2D 31 part, these are codes for the ASCII
> characters. So it
> > looks like I have Carriage Return slapped in the middle of a record.
> > Any ideas ? Does the compress function accept Hexadecimal codes ?
> > How do I select records where one field contain's CR or 0D Hex?
> > I am running Ver 8 under NT.
> > TIA.