Date: Wed, 3 Oct 2001 18:12:47 -0500
Reply-To: "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject: Re: Text File Import Problem
Content-Type: text/plain; charset="iso-8859-1"
Without seeing your actual data file, I can't be sure, but check the
documentation for the infile statement. There are options like flowover and
missover that might may the difference.
From: Mike Stuart [mailto:muon33@NYC.RR.COM]
Sent: Wednesday, October 03, 2001 9:29 AM
Subject: Text File Import Problem
Having problems with a straight-forward import, I think the problem
has to do with non-viz characters, but I'm not sure. When viewed, the
file I'm trying to read in is relatively straight-forward, one email
address per line. I'm using the code below to read in this file.
data ffx.epilist ;
infile epilist truncover ;
input @1 email $50. ;
email = left(trim(lowcase(email))) ;
domain = substr(email,(index(email,'@')+1)) ;
The output however looks like this:
obs email domain
1 firstname.lastname@example.org email@example.com jieuw@lm dkadk.com
It looks like the line delimiter is missing. Suggestions on how to
fix? I've tried the import wizard using a number of different
delimiter option and am getting the same result.