| Date: | Fri, 3 Aug 2001 14:02:32 +0100 |
| Reply-To: | "Vyverman, Koen" <koen.vyverman@FID-INTL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | "Vyverman, Koen" <koen.vyverman@FID-INTL.COM> |
| Subject: | Re: Reading a txt-file with 'squares' (hexadecimal values) |
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Dirk,
> All useful codes in themselves, but they didn't solve my problem yet,
> I've got a txt-file with a square in the var 'name' that always stop
> reading, try the code below for an exemple:
> data a;
> infile baddata dlm =',';
> input @;
> _infile_=left(compbl(translate(_infile_,'
> ','000102030405060708090A0B0C0D0E0F101112131415161718191A1B1C1
> D1E1F'x)));
> informat name $10.;
> input name;
> run;
Please see my recent message about the '1A'x embedded characters
for details. Simply modifying your infile statement as follows
should work:
infile baddata ignoredoseof;
That is, if you're using SASv8.2 ...
Kind Regards,
Koen.
---------------------------------
Koen Vyverman
Database Marketing Manager
Fidelity Investments - Luxembourg
---------------------------------
|