Date:         Fri, 24 Mar 2000 19:02:12 PST
Reply-To:     wei cheng <cheng_wei@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wei cheng <cheng_wei@HOTMAIL.COM>
Subject:      Re: Double tabs space problem on INPUT statement
Comments: To: sarthur67@YAHOO.COM
Content-Type: text/plain; format=flowed

Steve,

Use the DSD option in the infile statement.

Wei

>From: Stephen Arthur <sarthur67@YAHOO.COM>
>Reply-To: Stephen Arthur <sarthur67@YAHOO.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Double tabs space problem on INPUT statement
>Date: Fri, 24 Mar 2000 16:03:53 -0800
>
>SAS,
>
>I am trying to read into SAS a tab delimited file that
>I downloaded off an internet site.
>
>My DATA step looks something like this:
>****************************************************;
>
>data genedata;
>
>  length var1 var2 var3 $ 10;
>
>  infile lib.dataset
>    delimiter = '09'x firstobs = 2 missover ;
>
>  input var1 $ var2 $ var3 $ var4;
>
>run;
>
>****************************************************;
>
>The problem is, is that sometimes there are two tabs
>('09'x) next to eachother, with no blank space in
>between the tab characters, because of missing data on
>that record, so SAS is not recognizing that there
>should be missing information between the tabs and
>therefore puts the wrong data in the wrong columns,
>shifted left.
>
>Examples
>a[tab]b[tab]c[tab]1       (no problem)
>d[tab][tab]e[tab]2        (problem)
>[tab]f[tab]g[tab]3   (problem)
>
>Does anyone know of a solution?
>
>steve
>
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Talk to your friends online with Yahoo! Messenger.
>http://im.yahoo.com

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com