One way you could go is to write code to import them specifying the delimiter:
data WORK.DATA_MASTER ;
delimiter='~' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat varname $40. ;
format varname $40.;
obsnum + 1;
You might be able to persuade SAS to write the code for you by getting into the Display Manager, then choosing File-Import Data, then selecting "Delimited File"; you can save the source code after it is done and then fool with it if it wasn't able to import correctly.
----- Original Message -----
From: Irin later
Sent: Friday, May 16, 2008 12:54 PM
Subject: How to import tilde delimited text file directly to SAS 9 through sas code?
My text tilde delimited source files are too huge to 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.
I am trying to find a way for importing these text tilde delimited files directly into SAS 9.
Could you please help me with a code?
Thank you in advance!