Date:         Tue, 26 Nov 2002 16:18:37 -0500
Reply-To:     "Elmaache, Hamani" <Hamani.Elmaache@CCRA-ADRC.GC.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Elmaache, Hamani" <Hamani.Elmaache@CCRA-ADRC.GC.CA>
Subject:      Re: Reading Text File with Pipe delimiter
Comments: To: Prasad Prabhudesai <prasad_prabhud@HOTMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

Hi Prasad .
You can use  proc import:

 proc import datafile='C:\mydata.txt'
                                        out=work.mydata dbms=dlm replace;
                                        getnames=yes;
                                        delimiter=','; /*  or your
delimiter='pipe ' ???*/
                                        run;

-----Original Message-----
From: Prasad Prabhudesai [mailto:prasad_prabhud@HOTMAIL.COM]
Sent: November 26, 2002 3:44 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Reading Text File with Pipe delimiter


I have a text file with about 200,000 records with pipe delimiter and
labels in the first row. Total record length is about 1600.

I would appreciate if anybody can tell him how to read the data in SAS
along with the labels.






--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG