Date: Thu, 5 Mar 2009 10:59:03 -0800
Reply-To: biggiefish <esther.fu@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: biggiefish <esther.fu@GMAIL.COM>
Subject: Re: Tab-delimited problem, "extra space between each character"
Content-Type: text/plain; charset=ISO-8859-1
Encoding = "unicode" fixed all my problems! Thank you so much peter!!
On Mar 5, 1:49 pm, biggiefish <esther...@gmail.com> wrote:
> I don't think it's a DBCS issue, but the data is coming in from a
> Siebel system. Not sure if that has anything to do with it.
> I tried the hex suggestion: here is what I got for 10 observations:
> put var $hex50.;
> I'm not sure what it means, or what it has in between the
> The original text is supposed to be:
> Hiawatha Broadband Communications Inc PRCB 26L000009AWQ
> Siouxland Urology Assoc PRCB 26L000009AYH
> Schaefer Greenhouses Inc PRCB 26L000009QL1
> New Hope Village Inc PRCB 26L000009RTZ
> Unitech Prepress Solutions Inc PRCB 26L000009VSY
> On Mar 5, 12:48 pm, snoopy...@GMAIL.COM (Joe Matise) wrote:
> > Sounds like it might be a DBCS (double byte character) file, being read in
> > as a single byte character [the second byte being transformed to a space, as
> > it's a nonprintable character], perhaps? Is it a file from an asian
> > language system, perhaps?
> > -Joe
> > On Thu, Mar 5, 2009 at 11:30 AM, biggiefish <esther...@gmail.com> wrote:
> > > Hi,
> > > Has anyone encountered a problem where after you import a tab-
> > > delimited file, there is an extra quote in each field, as well as
> > > extra space inserted between each character, like this,
> > > " O u t b o u n d T e l e p r o s p e c t i n g "
> > > instead of
> > > Outbound Teleprospecting
> > > Any help would be greatly appreciated. Thank you so much in advance!!
> > > Esther