Date:         Sun, 18 May 2008 18:01:08 -0700
Reply-To:     Richard <richard.hockey@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard <richard.hockey@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How to import tilde delimited text file directly to SAS 9
              through
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On May 17, 3:54 am, irinfig...@yahoo.com (Irin later) wrote:
> <table cellspacing='0' cellpadding='0' border='0' ><tr><td style='font: inherit;'><DIV id=yiv894406661>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>My text tilde delimited source files are too huge to <SPAN> </SPAN>import them to Excel 2002 in order to import then to SAS 9. On the other hand they have data to be fixed and Access rejects part of them.</FONT><FONT face="Times New Roman" size=3> </FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>I am trying to find a way for importing these text tilde delimited files directly into SAS 9.</FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Could you please help me with a code?</FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3> </FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Thank you in advance!</FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3> </FONT></P>
> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Irin</FONT></P></DIV></td></tr></table><br>

Firstly please post to SAS-L in PLAIN TEXT. This was almost impossible
to read.
To read in tilde delimited data just change the delimiter character to
'~' in the DELIMITER= option in proc import or the infile statement
depending on how you intend importing these data.
R