|
its not much information about your problem. Did you try it with something
like:
data a;
infile "c:\daten\test.dat" dlm="," truncover;
if _n_=1 then do input; delete; end;
else input
site : 8.
id : 8.
pid : 8.
it : $5.
dd : ANYDTDTM20.
itd : 8.
rtd : 8.
linkid : 8.
sp : 8.
fc : 8.
dtc : ANYDTDTM20.
dtm : ANYDTDTM20.
u : $5.
;
u = compress(u,'""');
it = compress(it,'""');
format dtm dtc dd datetime20.;
run;
That seems to work for your example.
Gerhard
On Wed, 5 Nov 2008 07:45:07 -0800, olivesecret@GMAIL.COM wrote:
>I will appreciate for any suggestions. The data is a txt file. The
>first two observations of the data is:
>
>"=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM","
U"
>1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008
>=13:10:20,"obd"
>
>Thanks a lot!
|
