| Date: | Wed, 3 Oct 2001 09:29:10 -0700 |
|---|
| Reply-To: | Mike Stuart <muon33@NYC.RR.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Mike Stuart <muon33@NYC.RR.COM> |
|---|
| Organization: | http://groups.google.com/ |
|---|
| Subject: | Text File Import Problem |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
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)) ;
run ;
The output however looks like this:
obs email domain
1 test1@dkadk.com 3234dk@efg.com jieuw@lm dkadk.com
3234dk@efg.com
etc.
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.
Thanks -
| 
