Date:         Mon, 20 Mar 2006 11:50:38 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: PROC IMPORT a very wide '|' delimited text file
In-Reply-To:  <200603201906.k2KGTaqN005071@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Susie.Li@TVGUIDE.COM wrote:
>I used the following PROC IMPORT codes to read in a very long
>pipe-delimited text file.  The first line of data contains the variable
>name such as:
>"ACCNTNUM"|"REFNO"|"TRM_NBR"
>
>It ended up truncating the data.  Can anyone help?
>
>
>PROC IMPORT OUT= WORK.testin
>             DATAFILE= "D:\test_qorder"
>             DBMS=DLM REPLACE;
>      DELIMITER='7C'x;
>      GETNAMES=YES;
>      DATAROW=2;
>RUN;

I haven't seen this problem before.  I'm wondering.  Could you have read
the data in something which accidentally put hard returns in, so SAS is
seeing
the lines ending before they ought to?

In the meantime, I wouldn't use DELIMITER='7C'x when I could just write
DELIMITER='|' instead.  And DATAROW is goign to be 2 anyway as the default,
since you have GETNAMES=YES.

You might also try using the Import Wizard instead and seeing if that makes
any difference.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/